sql2kconn.java

求职招聘：企业 个人用户注册 信息发布 信息检索

package com.hd.dbcon;

import java.sql.*;

public class SQL2kConn {

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

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

	private String user = "sa";

	private String password = "";

	private Connection conn;

	private Statement st;

	private ResultSet rs;

	// 构造方法中产生数据库连接对象conn
	
	public SQL2kConn() {
		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;

	}

}