当前位置: 技术问答>java相关
Better way to get columns info in a table?
来源: 互联网 发布时间:2015-06-15
本文导语: I am using the following code to get the column information of a table, wondering why the speed is relating to the number of rows of the table. By right it shouldn't, as I did not make use of its data. I am using SQLservrer2000. It should...
I am using the following code to get the column information of a table, wondering why the speed is relating to the number of rows of the table. By right it shouldn't, as I did not make use of its data.
I am using SQLservrer2000. It should be faster if I make use of some sytemtables to get these informations However, if I am not using the API of JDBC, do I need make changes when switch to another database?
Please suggest a faster way to get the table columns information and make use of the JDBC API?
public HashMap getAllColumnsNameInTable(String tableName){
HashMap tableColumnMap = new HashMap();
ArrayList columnNameList = new ArrayList();
ArrayList columnTypeList =new ArrayList();
try{
//DataSource ds = getDBDataSource();
Connection con = getConnection();
Statement statmt = con.createStatement();
ResultSet rs;
String queryString = "Select * from " + tableName;
//System.out.println(systemQueryString);
try{
rs = statmt.executeQuery(queryString);
ResultSetMetaData rsMeta = rs.getMetaData();
for(int i =1; i
I am using SQLservrer2000. It should be faster if I make use of some sytemtables to get these informations However, if I am not using the API of JDBC, do I need make changes when switch to another database?
Please suggest a faster way to get the table columns information and make use of the JDBC API?
public HashMap getAllColumnsNameInTable(String tableName){
HashMap tableColumnMap = new HashMap();
ArrayList columnNameList = new ArrayList();
ArrayList columnTypeList =new ArrayList();
try{
//DataSource ds = getDBDataSource();
Connection con = getConnection();
Statement statmt = con.createStatement();
ResultSet rs;
String queryString = "Select * from " + tableName;
//System.out.println(systemQueryString);
try{
rs = statmt.executeQuery(queryString);
ResultSetMetaData rsMeta = rs.getMetaData();
for(int i =1; i
您可能感兴趣的文章:
本站(WWW.)旨在分享和传播互联网科技相关的资讯和技术,将尽最大努力为读者提供更好的信息聚合和浏览方式。
本站(WWW.)站内文章除注明原创外,均为转载、整理或搜集自网络。欢迎任何形式的转载,转载请注明出处。
本站(WWW.)站内文章除注明原创外,均为转载、整理或搜集自网络。欢迎任何形式的转载,转载请注明出处。
站内导航:
特别声明:169IT网站部分信息来自互联网,如果侵犯您的权利,请及时告知,本站将立即删除!