예제 #1
0
  // 将词性内容转换成map,以便快速查找
  public static Map<String, CxindexBean> selectCxIndexBeanToMap()
      throws ClassNotFoundException, SQLException {

    Map<String, CxindexBean> map = new HashMap<String, CxindexBean>();

    PreparedStatement pstmt = DbUtil.getJdbcConn().prepareStatement(SqlConst.SQL_S002);

    ResultSet rs = pstmt.executeQuery();

    while (rs.next()) {

      CxindexBean bean = new CxindexBean();

      bean.setColor(rs.getString("COLOR"));

      bean.setSize(rs.getString("SIZE"));

      bean.setCxsm(rs.getString("CXSM"));

      bean.setCxbz(rs.getString("CXBZ"));

      map.put(rs.getString("CXBZ"), bean);
    }
    return map;
  }
예제 #2
0
  // 向科学家表中增加科学家信息
  public static void insertContent(String name, String content)
      throws ClassNotFoundException, SQLException {

    PreparedStatement pstmt = DbUtil.getJdbcConn().prepareStatement(SqlConst.SQL_I001);

    pstmt.setString(1, name);

    pstmt.setString(2, content);

    pstmt.execute();
  }
예제 #3
0
  // 选择科学家姓名
  public static List<String> selectScientist() throws ClassNotFoundException, SQLException {

    List<String> scientists = new ArrayList();

    PreparedStatement pstmt = DbUtil.getJdbcConn().prepareStatement(SqlConst.SQL_S003);

    ResultSet rs = pstmt.executeQuery();

    while (rs.next()) scientists.add(rs.getString("name"));

    return scientists;
  }
예제 #4
0
  // 将词性转换成map,以便快速查找
  public static Map<String, String> selectCxIndexToMap()
      throws ClassNotFoundException, SQLException {

    Map<String, String> map = new HashMap();

    PreparedStatement pstmt = DbUtil.getJdbcConn().prepareStatement(SqlConst.SQL_S002);

    ResultSet rs = pstmt.executeQuery();

    while (rs.next()) map.put(rs.getString("CXBZ"), rs.getString("CXSM"));

    return map;
  }
예제 #5
0
  // 选择词性的详细说明
  public static String selectContent(String name) throws ClassNotFoundException, SQLException {

    String cxsm = "";

    PreparedStatement pstmt = DbUtil.getJdbcConn().prepareStatement(SqlConst.SQL_S001);

    pstmt.setString(1, name);

    ResultSet rs = pstmt.executeQuery();

    if (rs.next()) cxsm = rs.getString("CXSM");

    return cxsm;
  }