package sqldemo;
import java.sql.*;
import java.util.*;
public class Datas {
private Connection conn = null;
private java.sql.PreparedStatement pstam = null;
private ResultSet rs = null;
public Hashtable Datass(){
Hashtable ht = new Hashtable();
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
conn = DriverManager.getConnection(
"jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs",
"sa", "sa");
pstam = conn.prepareStatement("select * from jobs");
rs = pstam.executeQuery();
Vector al = new Vector();
for(int i = 1;i <= rs.getMetaData().getColumnCount();i++){
al.add(rs.getMetaData().getTableName(i));
}
ht.put(ht.size(),al);
while(rs.next()){
al = new Vector();
for(int i = 1;i <= rs.getMetaData().getColumnCount();i++){
al.add(rs.getString(i));
}
ht.put(ht.size(),al);
}
conn.close();
return ht;
} catch (ClassNotFoundException ex) {
} catch (SQLException ex) {
ex.printStackTrace();
}
return ht;
}
}package sqldemo;
import java.sql.*;
import java.util.*;
public class Mean {
public static void main(String[] args) throws SQLException {
Datas ds = new Datas();
Hashtable ht = ds.Datass();
Enumeration en = ht.elements();
while (en.hasMoreElements()) {
Vector al = (Vector) en.nextElement();
for(int i = 0;i < al.size();i++){
System.out.print(al.get(i));
}
System.out.println();
}
}
}1.我想把程序弄简单点实现功能,需要怎么改呢
2.现在的表的列名显示不出来,应该怎么写谢谢
import java.sql.*;
import java.util.*;
public class Datas {
private Connection conn = null;
private java.sql.PreparedStatement pstam = null;
private ResultSet rs = null;
public Hashtable Datass(){
Hashtable ht = new Hashtable();
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
conn = DriverManager.getConnection(
"jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs",
"sa", "sa");
pstam = conn.prepareStatement("select * from jobs");
rs = pstam.executeQuery();
Vector al = new Vector();
for(int i = 1;i <= rs.getMetaData().getColumnCount();i++){
al.add(rs.getMetaData().getTableName(i));
}
ht.put(ht.size(),al);
while(rs.next()){
al = new Vector();
for(int i = 1;i <= rs.getMetaData().getColumnCount();i++){
al.add(rs.getString(i));
}
ht.put(ht.size(),al);
}
conn.close();
return ht;
} catch (ClassNotFoundException ex) {
} catch (SQLException ex) {
ex.printStackTrace();
}
return ht;
}
}package sqldemo;
import java.sql.*;
import java.util.*;
public class Mean {
public static void main(String[] args) throws SQLException {
Datas ds = new Datas();
Hashtable ht = ds.Datass();
Enumeration en = ht.elements();
while (en.hasMoreElements()) {
Vector al = (Vector) en.nextElement();
for(int i = 0;i < al.size();i++){
System.out.print(al.get(i));
}
System.out.println();
}
}
}1.我想把程序弄简单点实现功能,需要怎么改呢
2.现在的表的列名显示不出来,应该怎么写谢谢
2、取表列名,我以前取过,但现在记不住了,如果确实需要的话我去找一下以前的代码。
2.得到的ResultSet,然后调用resultSet.getMetaData().getColumnName(1)得到第一列字段名,以此类推
//----------------送个笑话-------------------儿子问爸爸,欲火焚身是什么意思,爸爸便委婉地告诉他是某人想要什么东西的意思。 语文课上没有粉笔,年轻的女老师刚好自己要去取时,儿子就立刻站起来说;“老师,我知道你是欲火焚身,还是让我满足你吧~” www.xiaohua007.com