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

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

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

package org.mmxbb.exam.util;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class Transformer {

  private Connection conn = null;
  DBConn dbcon = null;
  Statement stmt = null;
  ResultSet set = null;

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

  public String idToValue(String input) {
    String output = null;
    try {
      stmt = conn.createStatement();
      stmt.setMaxRows(1);
      String sql = "select B_VALUE from ex_BASEINFO where B_ID='" + input + "'";
      set = stmt.executeQuery(sql);
      if (set.next()) {
        output = set.getString("B_VALUE");
      }
    } catch (SQLException sqle) {
      sqle.printStackTrace();
    } finally {
      close();
    }
    if (output == null) {
      return null;
    } else {
      return output;
    }
  }

  public String valueToId(String input) {
    String output = null;
    try {
      stmt = conn.createStatement();
      stmt.setMaxRows(1);
      String sql = "select B_ID from ex_BASEINFO where B_VALUE='" + input + "'";
      set = stmt.executeQuery(sql);
      if (set.next()) {
        output = set.getString("B_ID");
      }
    } catch (SQLException sqle) {
      sqle.printStackTrace();
    } finally {
      close();
    }