dbcolumntype.java

实体对象javabean的自动生成工具。用于生成数据库表单的javabean程序

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

public class DBColumnType{
  public String[] getColtype(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[] ColumnType=new String[numberOfColumns+1];
		for(int i=1;i<=numberOfColumns;i++){
			ColumnType[i]=rsmd.getColumnTypeName(i);
		}
		return ColumnType;
  }



}