JDBC纯驱动连接MySQL

最新推荐文章于 2021-10-08 19:29:27 发布

94_猿猴子

最新推荐文章于 2021-10-08 19:29:27 发布

阅读量193

点赞数

本文链接：https://blog.csdn.net/qq_39017150/article/details/78322421

版权

import java.sql.Statement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;

public class BaseDAO {

   private final static String DRIVER = "com.mysql.jdbc.Driver";
   private final static String URL = "jdbc:mysql://localhost:3306/*";
   private final static String USER = " ";
   private final static String PWD = " ";

   protected Connection openConn() throws Exception {
       Class.forName(DRIVER);
       Connection conn = DriverManager.getConnection(URL, USER, PWD);
       return conn;
   }

   protected void closeConn(Connection conn, Statement st, ResultSet rs) {
       try {
           if (rs != null)
               rs.close();
           if (st != null)
               st.close();
           if (conn != null)
               conn.close();

       } catch (Exception e) {
           e.printStackTrace();
       }
   }

   protected void closeConn(Connection conn, Statement st) {
       this.closeConn(conn, st, null);
   }
}