1.jdbc创建连接Connect
import java.sql.*;
public class JdbcUtils {
private static final String DRIVER = "com.mysql.jdbc.Driver";
private static final String URL = "jdbc:mysql://localhost:3306/test";
private static final String USER = "root";
private static final String PWD = "root";
private static Connection connection;
public static Connection getConnection(){
try {
Class.forName(DRIVER);
return DriverManager.getConnection(URL,USER,PWD);
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return null;
}
public static void closeAll(ResultSet rs, PreparedStatement ps, Connection connection) {
if(rs != null) {
try {
rs.close();
} catch (SQLException e) {