MySql工具类——jdbc

public class JdbcUtil {
    static  String driver= "com.mysql.jdbc.Driver";
    static String url = "jdbc:mysql://localhost:3306/kj_01?useUnicode=true&characterEncoding=UTF-8";
    static String username = "root";
    static String password = "3333";
    //返回con
    public static Connection conn(){
        Connection con = null;
        try {
            Class.forName(driver);
            con = DriverManager.getConnection(url, username, password);
        } catch (Exception e) {
            e.printStackTrace();
        }
        return con;
    }
    //sql查询释放资源
    public static void colse(ResultSet rs, PreparedStatement pstm,Connection con)  {
        try {
            if(rs!=null){
                rs.close();
            }
        }catch (Exception e){
            e.printStackTrace();
        }

        try {
            if(pstm!=null){
                pstm.close();
            }
        }catch (Exception e){
            e.printStackTrace();
        }

        try {
            if(pstm!=null){
                pstm.close();
            }
        }catch (Exception e){
            e.printStackTrace();
        }
    }
    //sql增删改释放资源
    public static void colsetwo( PreparedStatement pstm,Connection con)  {
        try {
            if(pstm!=null){
                pstm.close();
            }
        }catch (Exception e){
            e.printStackTrace();
        }

        try {
            if(pstm!=null){
                pstm.close();
            }
        }catch (Exception e){
            e.printStackTrace();
        }
    }
}