daobase.java

网上购书系统 采用jsp+servlet+sql2000

package base;


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

public class DaoBase {
	private Connection conn=null;
	private String url="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=bookshop";
	private String user="sa";
	private String password="sa";

	/**
	 * @return the conn
	 */
	public Connection getConn() {
		try{
			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
			conn=DriverManager.getConnection(url,user,password);
		}catch(Exception ex){
			ex.printStackTrace();
		}
		return conn;
	}
	
	public void closeConn(){
		try{
			conn.close();
		}catch(Exception ex){
			ex.printStackTrace();
		}
	}
}