opendb.java

基本分数查询功能,自己的毕业设计作品!希望能给大家一点帮助!

package org.xk.dbutil;

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

public class Opendb {

	Connection conn = null;
	ResultSet rs = null;
	String dbUser = "sa";
	String dbPass = "";
	String str = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=checkScoreSystem;SelectMethod=cursor";

	public Opendb() {
		try {
			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
		} catch (ClassNotFoundException e) {
			System.err.println("opendb():" + e.getMessage());
		}
	}

	public ResultSet executeQuery(String sql) {
		try {

			conn = DriverManager.getConnection(str, dbUser, dbPass);
			PreparedStatement stmt = conn.prepareStatement(sql);
			rs = stmt.executeQuery();
		} catch (SQLException ex) {
			System.err.println("aq.executeQuery:" + ex.getMessage());
		}
		return rs;
	}

	public ResultSet executeQuery(String sql, String[] obj) {
		try {
			conn = DriverManager.getConnection(str, dbUser, dbPass);
			PreparedStatement stmt = conn.prepareStatement(sql);
			if (obj != null) {
				for (int i = 0; i < obj.length; i++) {
					stmt.setString(i + 1, obj[i]);
				}
			}
			rs = stmt.executeQuery();
		} catch (SQLException ex) {
			System.err.println("aq.executeQuery:" + ex.getMessage());
		}
		return rs;
	}

	public int executeUpdate(String sql, Object[] obj) {
		int r = 0;
		try {
			conn = DriverManager.getConnection(str, dbUser, dbPass);
			PreparedStatement stmt = conn.prepareStatement(sql);
			if (obj != null) {
				for (int i = 0; i < obj.length; i++) {
					stmt.setObject(i + 1, obj[i]);
				}
			}
			r = stmt.executeUpdate();
		} catch (SQLException ex) {
			System.err.println("aq.executeQuery:" + ex.getMessage());
		}
		return r;
	}

	public int executeDel(String sql, Object[] obj) {
		int r = 0;
		try {
			conn = DriverManager.getConnection(str, dbUser, dbPass);
			PreparedStatement stmt = conn.prepareStatement(sql);
			if (obj != null) {
				for (int i = 0; i < obj.length; i++) {
					stmt.setObject(i + 1, obj[i]);
				}
			}
			r = stmt.executeUpdate();
		} catch (SQLException ex) {
			System.err.println("aq.executeQuery:" + ex.getMessage());
		}
		return r;
	}

	public int executeUpdate(String sql) {
		int x = 0;
		try {
			conn = DriverManager.getConnection(str, dbUser, dbPass);
			PreparedStatement stmt = conn.prepareStatement(sql);
			x = stmt.executeUpdate();
		} catch (SQLException e) {
			System.err.println("aq.executeQuery:" + e.getMessage());
		}
		return x;
	}

	public int executeUpdate(String sql, String content) {
		int x = 0;
		try {
			conn = DriverManager.getConnection(str, dbUser, dbPass);
			PreparedStatement stmt = conn.prepareStatement(sql);
			stmt.setString(1, content);
			x = stmt.executeUpdate();
		} catch (SQLException e) {
			System.err.println("aq.executeQuery:" + e.getMessage());
		}
		return x;
	}

	public void Close() {
		try {

			conn.close();

		} catch (Exception end) {
			System.err.print("end.getMessage()");
		}
	}

}