DBManager工具类

//和数据库交互,产生连接，执行命令
public class DBManager{

//静态块，当前类被加载的时候执行
static{
Class.forName(“com.mysql.cj.jdbc.Driver”);
}catch(ClassNotFoundException e){
e.printStackTrace();
}

//获取连接
public Connction openConnection() throws SQLException{
String url = “jdbc:mysql//127.0.0.1:3306/STUDENT?useSSL=true&serverTimezone=UTC&CharacterEncoding=utf8”;
return DriverManager.getConnection(url,“root”,“ZXHJ123”);
}

//健壮性，出错概率较小
public void closeConnection(Connction conn){
if (conn ! = null) {
conn.close();
}
}

public int update(Connction conn,String sql,Object...obs){
	int count = 0;
	if (conn != null && !conn.isClosed()) {
		PreparedStatement psment = conn.PreparedStatement(sql);			
		if (obs!=null) {
			for (int i = 0 ; i<obs.length ; i++) {
					psment.setObject(i+1,obs[i]);
				}	
		}
		count = psment.excuteUpdate();
	}
	return count;
}



public ResultSet query(Connction conn,String sql,Object...obs){
	ResultSet rs = null;
	if (conn != null && !conn.isClosed()) {
		PreparedStatement psment = conn.PreparedStatement(sql);			
		if (obs!=null) {
			for (int i = 0 ; i<obs.length ; i++) {
					psment.setObject(i+1,obs[i]);
				}	
		}
		count = psment.excuteQuery();
	}
	return rs;
}

}