dbconnection.java

电子商务网站中实现分页的源代码

package com.monitor.dao;

import java.sql.*;

public class DBConnection {
	private static final String CONSTR = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
	private static final String URL = "jdbc:sqlserver://HJT\\SQLEXPRESS:1433;database=demoschool;username=sa;password=accp";
	private Connection conn=null;
	
	public DBConnection() throws SQLException, ClassNotFoundException{
		Class.forName(CONSTR);
		conn = DriverManager.getConnection(URL);
	}
	
	public ResultSet executeAllQuery(String strSql) throws SQLException{
		return conn.createStatement().executeQuery(strSql);
	}
	
	public void closeConnection() throws SQLException{
		if(conn!=null){
			if(!conn.isClosed()){
				conn.close();
			}
		}
	}
}