【JDBC-Mysql】使用 JDBC 操作 Mysql 数据库

1）导入依赖

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>5.7.27</version>
</dependency>

2）定义Connection连接类

public class Conn {
   
	//定义Driver
    public static final String driver = "com.mysql.jdbc.Driver";
	//定义getConnection方法获取Connection
    public static Connection getConnection(String url, String username, String password) {
   
        Connection conn = null;
        try {
   
        	//注册驱动
            Class.forName(driver);
            //获取Connection
            conn = DriverManager.getConnection(url, username, password);
        } catch (ClassNotFoundException e) {
   
            e.printStackTrace();
        } catch (SQLException e) {
   
            e.printStackTrace();
        }
        return conn;
    }
	
	//关闭连接
    public static void close(Connection conn, PreparedStatement ps, ResultSet rs) {
   
        if (conn != null) {
   
            try {
   
                conn.close();
            } catch (SQLException e) {
   
                e.printStackTrace();
            }
        }