dbcolumnname.java

来自「实体对象javabean的自动生成工具。用于生成数据库表单的javabean程序」· Java 代码 · 共 26 行

/*
// header - edit "Data/yourJavaHeader" to customize
// contents - edit "EventHandlers/Java file/onCreate" to customize
//
*/
import java.sql.*;

public class DBColumnName{
  public String[] getColname(Connection con,String tablename)throws SQLException,Exception{
    Statement stmt=con.createStatement();
		boolean status=stmt.execute("select * from "+tablename);
		ResultSet rs=stmt.getResultSet();
		ResultSetMetaData rsmd=rs.getMetaData();
		int numberOfColumns=rsmd.getColumnCount();
    String[] ColumnName=new String[numberOfColumns+1];
		for(int i=1;i<=numberOfColumns;i++){
		  ColumnName[i]=rsmd.getColumnName(i);
		}
		return ColumnName;
  }



}