java连接数据库MySQL

来源：互联网发布：网络车珠子是什么意思编辑：程序博客网时间：2024/06/18 10:03

public class Db {
   static{
       try {
           Class.forName("com.mysql.jdbc.Driver").newInstance();
       } catch (InstantiationException e) {
           e.printStackTrace();
       } catch (IllegalAccessException e) {
           e.printStackTrace();
       } catch (ClassNotFoundException e) {
           e.printStackTrace();
       }
   }
   public static Connection getCon(){
           Connection conn = null;
           try {
               conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/EduWeiXin?user=root&password=&useUnicode=true&characterEncoding=utf-8");
           } catch (SQLException e) {
               // TODO Auto-generated catch block
               e.printStackTrace();
           }
           return conn;
       }
   public static void closeConn(PreparedStatement st,ResultSet rs, Connection conn) {
       if(null != st){
           try {
               st.close();
           } catch (SQLException e) {
               // TODO Auto-generated catch block
               e.printStackTrace();
           }
       }
       if(null != rs){
           try {
               rs.close();
           } catch (SQLException e) {
               e.printStackTrace();
           }
       }
       if(null != conn){
           try {
               conn.close();
           } catch (SQLException e) {
               e.printStackTrace();
           }
       }
   }
}

0 0