如何动态的获取数据库里面的字段以…

来源：互联网发布：php 访问粘贴板编辑：程序博客网时间：2024/05/18 02:10

private String getResult(String sql){

  Connection conn=null;
  ResultSet rs=null;
  conn=DBConnection.getConnection(Constants.DATABASE_PATH_STYLE);

  PreparedStatement selectPS =conn.prepareStatement(sql);
  try {
   rs =selectPS.executeQuery();
  } catch (SQLException e1){
   // TODOAuto-generated catch block
   e1.printStackTrace();
  }
  ArrayList lstThemes=newArrayList();
  try {
   if(rs!=null){
    intcolCount=rs.getMetaData().getColumnCount();
    while(rs.next()){
     HashMaphm=new HashMap();
     for(inti=1;i<=rs.getMetaData().getColumnCount();i++){
      StringcolName=rs.getMetaData().getColumnName(i);
      if("getValidColumnIndex".equals(colName))
      {
       continue;
      }
      hm.put(colName,rs.getString(colName));
     }
     lstThemes.add(hm);
    }
   }
  } catch (SQLException e){
   // TODOAuto-generated catch block
   e.printStackTrace();
  }finally{
   DBConnection.closeConnection(conn);
  }
  JSONArray json =JSONArray.fromObject(lstThemes);
  return json.toString();
}

阅读全文

0 0