src/com/db/DBConnection.java

微信扫码关注公众号，代码整理好后第一时间通知你。

package com.db;

import java.sql.*;

public class DBConnection {
	private static final String DRIVERCLASS="com.mysql.jdbc.Driver";
	private static final String URL="jdbc:mysql://localhost:3306/student?characterEncoding=utf8";
	private static final String USERNAME="root";
	private static final String PASSWORD="root";
	static{
		//加载驱动
		try{
		 Class.forName(DRIVERCLASS);
		}catch(ClassNotFoundException e){
			e.printStackTrace();
		
		}
	}
 public static Connection getConn(){
	 Connection conn=null;
	 try{
	 conn=DriverManager.getConnection(URL,USERNAME,PASSWORD);
	 }catch(SQLException e){
		 e.printStackTrace();
	 }
 return conn;
 }
 
 
 public static void close(ResultSet rs,PreparedStatement ps,Connection conn){
	 try{
		 if(rs!=null) rs.close();
		 if(ps!=null) ps.close();
		 if(conn!=null) conn.close();
		 
	 }catch(Exception e){
		 e.printStackTrace();
	 }
 }
}