数据访问

来源:互联网 发布:js 时间控件选择周 编辑:程序博客网 时间:2024/05/17 06:19
 public static void main(String[] args) {
  String sql = "select * from gb_keireki_idx";
  try {
   Connection m = DataConn.getConnection();
   Statement s = m.createStatement();
   ResultSet jie = s.executeQuery(sql);
   // jie.
   ResultSetMetaData rsmd = jie.getMetaData();
   while (jie.next()) {
    HashMap rsMap = new HashMap<String, String>();
    for (int i = 1; i <= rsmd.getColumnCount(); i++) {
     rsMap.put(rsmd.getColumnName(i), jie.getString(i));

    }
    System.out.println(rsMap.get("OKURI_NUM_JOIN"));
    // System.out.println(rsMap);

   }

   // System.out.println("ok");
   m.close();

  } catch (Exception e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }

 }
}
原创粉丝点击