// 将词性内容转换成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; }
// 向科学家表中增加科学家信息 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(); }
// 选择科学家姓名 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; }
// 将词性转换成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; }
// 选择词性的详细说明 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; }