db.java

JSP网上书店系统,有完整的程序,可以直接使用,无需修改

package com.tsinghua.db;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;

public class DB {
    
	public static Connection getconn()throws Exception{
		Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
		Connection conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;databasename=sellbooks", "sa", "");
		return conn;
	}
	public static Statement getset(Connection conn)throws Exception{
		Statement set=conn.createStatement();
		return set;
	}
	public static ResultSet getrs(Statement set,String sql)throws Exception{
		ResultSet rs=set.executeQuery(sql);
		return rs;
	}
	public static PreparedStatement getpset(Connection conn,String sql)throws Exception{
		PreparedStatement pset=conn.prepareStatement(sql);
		return pset;
	}
	public static   void close(ResultSet rs)throws Exception{
		 rs.close();
	}
	public static void close(Statement set)throws Exception{
		set.close();
	}
	public static void close(Connection conn)throws Exception{
		conn.close();
	}

	
	
}