dbconn.java

uliu liuoulo p hp pi ij jp

package conn;
import java.sql.*;
public  class DBConn
{
	private static  Connection con=null; 
	public  static Connection GetConnection()
	{
		 if(con==null)
		 {
			try{
				//定义URL
				String url="jdbc:odbc:LocalServer";
				//装入驱动程序
				Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
				//建立连接
				con=DriverManager.getConnection(url,"sa","LycGxy0422");
				
			}
			catch(ClassNotFoundException e)
			{
				System.out.println(e);
			}
			catch(SQLException e){
				System.out.println(e.getMessage());
			} 
		}
		return con;
	}
	public static  void closeConnection()
	{
          try{
               if(con!=null)
                    con.close();
               con=null;
          }catch(Exception e){
               e.printStackTrace();
          }
     }

}