src/com/drugsp/util/DB_util.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

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

package com.drugsp.util;

import java.sql.*;
import java.util.ArrayList;
import java.util.LinkedHashMap;
import java.util.List;
import java.util.Map;

public class DB_util {
	  private static final String DRIVER="com.mysql.jdbc.Driver";
	    private static final String URL="jdbc:mysql://localhost:3306/drugsp?useUnicode=true&characterEncoding=utf8&serverTimezone=UTC";
	    private static final String USERNAME="root";
	    private static final String PASSWORD="123456";
	    //获取连接对象
	    private static Connection getConnection() {
	        Connection conn=null;
	        try {
	            Class.forName(DRIVER);
	            try {
	                conn= DriverManager.getConnection(URL, USERNAME, PASSWORD);
	                return conn;
	            } catch (SQLException e) {
	                System.out.println("连接失败");
	                e.printStackTrace();
	            }
	        } catch (ClassNotFoundException e) {
	            System.out.println("驱动注册失败");
	            e.printStackTrace();
	        }
	        return null;
	    }
	    //增删改
	    public  int Update(String sql ,Object[] obj){
	        Connection conn=null;
	        PreparedStatement ps=null;
	        try {
	            conn=getConnection();
	            ps=conn.prepareStatement(sql);
	            if (obj!=null) {
	                for (int i = 0; i < obj.length; i++) {
	                    ps.setObject(i+1, obj[i]);
	                }
	            }
	            return ps.executeUpdate();
	        } catch (SQLException e) {
	            e.printStackTrace();
	        }finally {
	            closeDB(null, ps, conn);
	        }
	        return 0;
	    }
	    //查
	    public  List<Map<String, String>> select(String sql, Object[] obj) {
	        Connection conn=null;
	        PreparedStatement ps=null;
	        ResultSet rs=null;

            //将结果集放到List<Map<String, String>>中
            List<Map<String, String>> list=new ArrayList<Map<String,String>>();
	        try {