f0706bab0553001d1ae3aaac3a26ea5a

来自「酒店预订系统具有登录」· 代码 · 共 62 行

package hote;

import java.sql.*;

public class query {

	private String dbDriver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";// SQL2005

	private String url = "jdbc:sqlserver://localhost:1433;DatabaseName=hotemanaga";

	private String user = "sa";

	private String password = "123";

	private Connection conn;

	private Statement st;

	private ResultSet rs;

	// 构造方法中产生数据库连接对象conn
	
	public query() {
		try {
			Class.forName(dbDriver);
			conn = DriverManager.getConnection(url, user, password);
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

	//SQL查询方法,返回结果集
	
	public ResultSet executeQuery(String sql) {
		try {
			st = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
					ResultSet.CONCUR_UPDATABLE);
			rs = st.executeQuery(sql);
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return rs;
	}

	//SQL更新方法,返回更新的记录数
	
	public int executeUpdate(String sql) {
		int i = 0;
		try {
			st = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
					ResultSet.CONCUR_UPDATABLE);
			i = st.executeUpdate(sql);
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return i;

	}

}