conn.java

来自「实现了基本的网上预订、预订管理、客户信息管理等功能」· Java 代码 · 共 42 行

package db;
import java.sql.*;
public class conn{
	String sDBDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
	String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=hotel"; 
    String user="sa"; 
    String password=""; 
	Connection connect=null;
	ResultSet rs=null;
	public conn(){
		try{
			Class.forName(sDBDriver);
		}
		catch(java.lang.ClassNotFoundException e){
			System.err.println(e.getMessage());
		}
	}
	public ResultSet executeQuery(String sql){
		try{
			connect=DriverManager.getConnection(url,user,password);
			Statement stmt = connect.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
			rs=stmt.executeQuery(sql);
		}
		catch(SQLException el){
			System.err.println(el.getMessage());
		}
		return rs;
	}
	public int executeUpdate(String sql){
		int result = 0;
		try{
			connect=DriverManager.getConnection(url,user,password);
			Statement stmt=connect.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
			result=stmt.executeUpdate(sql);
		}
		catch(SQLException el){
			System.err.println(el.getMessage());
		}
		return result;
	}
}