第一步先连接数据库
public class DBUHelpers {
private static String DRIVER = "com.mysql.jdbc.Driver";
private static String URL = "jdbc:mysql://localhost:3306/zhongyin?useSSL=false&serverTimezone=UTC&characterEncoding=utf8";
private static String USERNAME = "root";
private static String PASSWORD = "123456";
private static Connection conn;
private static PreparedStatement ps;
private static ResultSet rs;
//预加载
static{
try {
Class.forName(DRIVER);
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
//建立连接
public static Connection getConn(){
try {
conn = DriverManager.getConnection(URL,USERNAME,PASSWORD);
return conn;
} catch (SQLException e) {
e.printStackTrace();
}
return null;
}
第二部你要通过数据库找到自己所在表中的三个列名