Java连接数据库及所需jar包

数据库连接代码：

package com.classify.dao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import com.mysql.cj.xdevapi.PreparableStatement;

public class Basedao {
	static {
		//加载驱动
		try {
			Class.forName("com.mysql.cj.jdbc.Driver");
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	
	
	public static Connection getconn() {
		//创建一个链接对象
		Connection conn = null;
		
		try {
			conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/你要连接的数据库名字?serverTimezone=UTC","用户名（一般是root）","登录数据库密码（一般是123456）");
			
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
		return conn;
	}
	
	public static int exectuIUD(String sql,Object[] params) {
		
		int count = 0;
		Connection conn = Basedao.getconn();
		//准备sql语句
		PreparedStatement ps = null;
		
		//insert into user("","","")value(?,?,?)
		try {
			//准备好语句
			ps = conn.prepareStatement(sql);
			
			for( int i=0;i<params.length;i++) {
				ps.setObject(i+1, params[i]);
			}
			//执行语句
			count = ps.executeUpdate();
			
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally {
			Basedao.closeall(null, ps, conn);
		}
		
		return count;
	}
	
	public static void closeall(ResultSet rs, PreparedStatement ps, Connection conn) {
		
		try {
			if(rs!=null) {
				rs.close();
			}
			if(ps!=null)
				ps.close();
			if(conn!=null)
				conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
		
	}
}