java 如何查询列名_java查询数据库列名，输出需要编写的代码

* 此方法是按照查询的结果集分离表名，所以是按顺序显示的

*@paramtableName 数据库表名字

*@authortxf*/

public voidgetAllUsers( String tableName){

Connection conn=DbConnection.getConn();

String sql="select * from "+tableName+" where rownum=1 ";

PreparedStatement stmt=null;

ResultSet rs=null;

String name="";try{

stmt=conn.prepareStatement(sql);

rs=stmt.executeQuery();

ResultSetMetaData rsmd=rs.getMetaData() ;for (int i=1;i<=rsmd.getColumnCount() ;i++){

name=rsmd.getColumnName(i);//if(s.get("memo")==null)pstmt.setString(13, ""); else pstmt.setString(13, s.get("memo").toString());

System.out.println("if(s.get(\""+name.toLowerCase()+"\")==null) pstmt.setString("+i+",