userdb.java

B2C的J2EE开发的 MVC +DAO 设计

package ldsj.gjm.db;

import java.sql.Connection;
import java.sql.DriverManager;

public class userdb 
{
	private Connection usercon=null;
	  public userdb(){}
	  public Connection getUserDB()
	  {
		  try 
		  {
			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
			try 
			{
				if(usercon==null)
				{
				usercon=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=B2C","sa","ok");
				}
				
			} 
			catch (Exception e) 
			{
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			
		  } 
		  catch (ClassNotFoundException e) 
		  {
			
			e.printStackTrace();
		}
		  
		  return usercon;
	  }
}