封装数据库DML,DQL操作——代码详解

一、封装数据库DML操作

public class DB_utils {
   
    
	static final String URL = "jdbc:mysql://localhost:3306/dep ?serverTimezone=GMT";
	static final String USER = "root";
	static final String PWD = "password";

   - 封装加载驱动方法
	public static Connection getConnection() {
   
		Connection connection = null;
		try {
   

			Class.forName("com.mysql.cj.jdbc.Driver");
			connection = DriverManager.getConnection(URL, USER, PWD);

		} catch (Exception e) {
   
			// TODO: handle exception
			e.printStackTrace();
		}
		return connection;
	}
    
    封装DML语句方法，调用该方法只需传sql语句和数组
	public static int execute(String sql,Object[] o) {
   
		Connection con = null;
		try {
   

			con = getConnection();
			PreparedStatement ps = con.prepareStatement(sql);
			if (o!=null && o.length>0) {
   
				for(