exam-master/src/org/mmxbb/exam/util/Selector.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

package org.mmxbb.exam.util;


import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;

import org.apache.struts.util.LabelValueBean;

public class Selector {
  private Connection conn = null;
  DBConn dbconn = null;

  private static final String SELECT_OPTIONS =
      "select b_id as id,b_value as name from ex_baseinfo where b_type = (select b_id from ex_baseinfo where b_value = ?) and b_id <> b_type";

  public Selector() {
    try {
      dbconn = new DBConn();
      conn = dbconn.getConnection();
    } catch (Exception ex) {
      ex.printStackTrace();
    }
  }

  public ArrayList getOptions(String lable) {
    ArrayList options = null;
    PreparedStatement pstmt = null;
    Statement stmt = null;
    ResultSet rs = null;
    options = new ArrayList();
    options.add(new LabelValueBean("-----请选择----", "%"));

    if (lable.equals("organization_id")) {
      try {
        stmt = conn.createStatement();
        rs = stmt.executeQuery(
            "SELECT organization_id AS id, org_name AS name FROM b_organization");
      } catch (SQLException ex2) {
        ex2.printStackTrace();
      }
    } else if (lable.equals("post_index")) {
      try {
        stmt = conn.createStatement();
        rs = stmt.executeQuery(
            "SELECT post_index AS id, post_name AS name FROM B_POST_TYPE");
      } catch (SQLException ex2) {
        ex2.printStackTrace();
      }
    } else if (lable.equals("education_index")) {
      try {
        stmt = conn.createStatement();
        rs = stmt.executeQuery(
            "SELECT education_index AS id, education_name AS name FROM b_education_type");
      } catch (SQLException ex2) {
        ex2.printStackTrace();
      }