basicdao.java

JAVA E拍网上购物业务管理 使用CRM业务流程

package org.ch02zf.dao.daoImpl;

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

import org.apache.log4j.Logger;

public class BasicDao {
	public static final String driverClass = "com.microsoft.jdbc.sqlserver.SQLServerDriver";

	public static final String dbUrl = "jdbc:sqlserver://localhost:1433;databasename=zf";

	public static final String db_user = "sa";

	public static final String db_pass = "accp";
	
	private static final Logger logger  = Logger.getLogger(BasicDao.class.getName());
	public static Connection getCon()
	{
		Connection con = null;
		try{
		Class.forName(driverClass);
		con = DriverManager.getConnection(dbUrl,db_user,db_pass);
		}catch(Exception e)
		{
		logger.info("加载驱动失败"+e.getMessage());	
		con = null;
		}
		return con;
	}

}