itemlibrary.java

一个简单的测试系统

package olts;

import java.sql.*;
import java.util.*;

/**
 * @author [e-mail]
 * @version 2.0
 */
public class ItemLibrary {
    public List ItemList;		//数据库中所有试题的ID列表
    
    public ItemLibrary(String queType){
        this.ItemList = new ArrayList();
        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        } catch (ClassNotFoundException e) {
           
            e.printStackTrace();
        }
        String url = "jdbc:odbc:a";
        Connection conn;
        try {
            String sql = "SELECT id FROM ";
            sql = sql + queType;
            conn = DriverManager.getConnection(url,"","");
            PreparedStatement ps = conn.prepareStatement(sql,ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
            ResultSet rs = ps.executeQuery();
            while(rs.next()){
                String itemID = "" + rs.getInt("id");
                this.ItemList.add(new Integer(itemID));
                }
            conn.close();
        } catch (SQLException e1) {
            
            e1.printStackTrace();
        }
       }
}