15 lines
742 B
Java
15 lines
742 B
Java
import java.sql.*;
|
|
public class Check {
|
|
public static void main(String[] a) throws Exception {
|
|
Class.forName("com.mysql.cj.jdbc.Driver");
|
|
try (Connection c = DriverManager.getConnection(
|
|
"jdbc:mysql://101.35.52.237:13319/ai_smart_ee?useUnicode=true&characterEncoding=utf8&serverTimezone=Asia/Shanghai&useSSL=false&allowPublicKeyRetrieval=true",
|
|
"root", "cstcom.123!")) {
|
|
try (Statement s = c.createStatement();
|
|
ResultSet r = s.executeQuery("SHOW COLUMNS FROM lb_third_integration_config WHERE Field IN ('cookie','phpsid','goods_api_token','goods_api_app_str','cookie_cipher')")) {
|
|
while (r.next()) System.out.println(r.getString("Field") + " " + r.getString("Type"));
|
|
}
|
|
}
|
|
}
|
|
}
|