src/util/DBConn.java

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

package util;

import java.sql.*;
public class DBConn {
    static{
        try{
        	Class.forName("com.mysql.jdbc.Driver");
//        	Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
//          Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        }catch(Exception ex){
            ex.printStackTrace();
        }

    }

    public static Connection getConn(){
        try{
        	Connection conn=DriverManager.getConnection("jdbc:mysql://localhost/tsgl?useUnicode=true&characterEncoding=utf-8","root","root");
//        	Connection conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;databasename=csgl","sa","123");
//       	Connection conn=DriverManager.getConnection("jdbc:odbc:temp");
            return conn;
        }catch(Exception ex){
            ex.printStackTrace();
            return null;
        }
    }
    public static void close(Connection conn,Statement st,ResultSet rs){
    	if(rs!=null){
            try{
                rs.close();
            }catch(SQLException ex){
            }
       }
       if(st!=null){
           try {
               st.close();
           }catch(Exception ex){
           }
       }
       if(conn!=null){
           try{
               conn.close();
           }catch(Exception ex){
           }
       }
    }

}