package helper;

import java.sql.*;
public class SQLConnection {
	static String dbDriver="com.mysql.jdbc.Driver";		
    static{
        try{
        }catch(Exception ex){
        	System.out.print("---------------------om.microsoft.sqlserver.jdbc.SQLServerDri");
            ex.printStackTrace();
        }

    }

    public static Connection getConn(){
        try{
        	Class.forName(dbDriver).newInstance(); 
        	Connection conn=DriverManager.getConnection("jdbc:mysql://127.0.0.1/gwlzxt?user=root&password=123456&useUnicode=true&characterEncoding=GBK");
            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){
           }
       }
    }

}