java连接数据库工具类

package dao;

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

public class Jdbchelper {
    private static String url="jdbc:mysql://localhost:3306/yyjtwo?characterEncoding=UTF-8";
    private static String username="yyj2";
    private static String password="yyj2";
    private static Connection conn=null;

    public static Connection getConn(){
        if(conn==null){
            try {
                Class.forName("com.mysql.jdbc.Driver");
                conn= DriverManager.getConnection(url,username,password);
            }
            catch (Exception e){
                e.printStackTrace();
                System.out.println("数据库连接失败");
            }
        }
        return conn;
    }

    //获取列表
    public Map<String,Object> findOne(String sql, Object... params){
        Map<String,Object> one=new HashMap<String,Object>();
        try{
            Connection conn=Jdbchelper.getConn();
            PreparedStatement ps=conn.prepareStatement(sql);
            if(null!=params){
                for(int i=0;i<params.length;i++){
                    ps.setObject(i+1,params[i]);
                }
            }
            ResultSet rs=ps.executeQuery();
            ResultSetMetaData rsm=rs.getMetaData();
            while (rs.next()){
                for(int i=1;i<=rsm.getColumnCount();i++){
                    String columnName=rsm.getColumnLabel(i);
                    Object value=rs.getObject(columnName);
                    one.put(columnName,value);
                }
            }
        }
        catch (Exception e){
            e.printStackTrace();
            System.out.println("查询失败");
        }
        return one;
    }

    //获取列表
    public List<Map<String,Object>> findList(String sql, Object... params){
        List<Map<String,Object>> list=new ArrayList<Map<String,Object>>();
        try{
            Connection conn=Jdbchelper.getConn();
            PreparedStatement ps=conn.prepareStatement(sql);
            if(null!=params){
                for(int i=0;i<params.length;i++){
                    ps.setObject(i+1,params[i]);
                }
            }
            ResultSet rs=ps.executeQuery();
            while (rs.next()){
                ResultSetMetaData rsm=rs.getMetaData();
                Map<String,Object> map1=new HashMap<String,Object>();
                for(int i=1;i<=rsm.getColumnCount();i++){
                    String columnName=rsm.getColumnLabel(i); //获取别名
                    //String columnName=rsm.getColumnName(i);  //获取原来名字
                    Object value=rs.getObject(columnName);
                    map1.put(columnName,value);
                }
                list.add(map1);
            }
        }
        catch (Exception e){
            e.printStackTrace();
            System.out.println("查询失败");
        }
        return list;
    }

    //删除 修改 新增保存
    public int executeSave(String sql,Object... params){
        int result=0;
        try{
            Connection conn=Jdbchelper.getConn();
            PreparedStatement ps=conn.prepareStatement(sql);
            if(params!=null){
                for(int i=0;i<params.length;i++){
                    ps.setObject(i+1,params[i]);
                }
            }
            result=ps.executeUpdate();
        }
        catch (Exception e){
            e.printStackTrace();
        }
        return result;
    }



    public static void main(String[] args) {
        Jdbchelper jdbchelper=new Jdbchelper();
        String sql="select * from user where no=?";
        String params = "001";
        List<Map<String,Object>> list=jdbchelper.findList(sql,params);
        for(int i=0;i<list.size();i++){
            Map<String,Object> map=list.get(i);
            System.out.println(map.get("no"));
        }

        System.out.println(getConn());
    }


}