撸一个jdbc工具类

package com.test;

import java.beans.Statement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLClientInfoException;
import java.sql.SQLException;

/**
 * @title BaseDao
 * @author Bailu
 * @time 下午1:08:11
 *
 */
//数据库连接和关闭类
/**
 * 加载驱动
 * 创建连接对象
 * 准备sql语句
 * 创建执行对象
 * 执行并获取结果
 * 释放链接 
 */
public class BaseDao {
	public static Connection conn=null;
	public static PreparedStatement state= null;
	public static ResultSet result=null;
	
	
	public static Connection getConn() throws SQLException,ClassNotFoundException {
		Class.forName("com.mysql.cj.jdbc.Driver");
		conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/stu0215?useSSL=false&serverTimezone=Asia/Shanghai","root","root");//此处所用数据库为mysql8.0 其他版本的链接信息需要自行更改一下
		return conn;
	}
	/**
	*数据更新
	*/
	public static int update(String sql,Object...obs) {
		int result = 0;
		try{
			conn = getConn();
			state = conn.prepareStatement(sql);
			for (int i = 0; i < obs.length; i++) {
				state.setObject(i+1, obs[i]);
			}
			result = state.executeUpdate();
			
		}catch(Exception e){
			e.printStackTrace();
		}
		return result;
		
	}
	/**
	*查询
	*/
	public static ResultSet query(String sql,Object...obs) {
		try {
			conn=getConn();
			state=conn.prepareStatement(sql);	
			for (int i = 0; i < obs.length; i++) {
				state.setObject(i+1, obs[i]);
			}
			result=state.executeQuery();
		} catch (Exception e) {
			e.printStackTrace();
		}
		return result; 
	}
	
	public static void closeObject(){
		try {
			if(result!=null){
				result.close();
			}
			if(result!=null){
				result.close();
			}
			if(result!=null){
				result.close();
			}
		} catch (Exception e) {
			// TODO: handle exception
			e.printStackTrace(); 
		}
	}

}