menudb.java

B2C的J2EE开发的 MVC +DAO 设计

package ldsj.gjm.menudb;

import java.sql.*;

public class menudb 
{
  private Connection menucon=null;
  public menudb(){}
  public Connection getMenuDB()
  {
	  try 
	  {
		Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
		try 
		{
			if(menucon==null)
			{
			menucon=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 menucon;
  }
}