dbconn.java

来自「遗传算法 JAVA SQL2000」· Java 代码 · 共 38 行

package com;

import java.sql.*;

public class DBConn {
	public DBConn() {
		try { // SQLSERVER的ODBC连接
			String strurl = "jdbc:odbc:questionLib";
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			conn = DriverManager.getConnection(strurl);
			stmt = conn.createStatement();
		} catch (Exception e) {
			System.out.println(e.toString());
		}
	}
	// 定义查找方法
	public int[] search(int id, String qType) throws Exception {
		int[] temp = new int[3];
		rs = stmt.executeQuery("select * from " + qType + " where QID = " + id);
		if(rs.next()){
			temp[0] = rs.getInt("QChapter");
			temp[1] = rs.getInt("QDifficulty");
			temp[2] = rs.getInt("QMark");
		}
		rs.close();
		return temp;
	}
	//定义数据库的关闭方法
	public void db_close() throws Exception {
		stmt.close();
		conn.close();
	}
	
	ResultSet rs;// 数据库操作结果集
	Statement stmt;// 数据操作表达式
	Connection conn;// 数据库连接
}