import java.sql.*;public class sqljdbc {
public static void main(String[] ares) {
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String sourceURL =
"jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=csdn0710";
Connection databaseConnection = DriverManager.getConnection(sourceURL,
"sa", "sa");
System.out.println("Connection established successfully!");
Statement stmt = databaseConnection.createStatement();
ResultSet rs = stmt.executeQuery("select * from employee");
ResultSetMetaData rsm = rs.getMetaData();
int columnCount = rsm.getColumnCount();
while (rs.next())
{
for (int i = 0; i < columnCount; i++)
{
{
System.out.print(rs.getString(i+1)+",");
}
}
System.out.println();
} databaseConnection.close();
}
catch (ClassNotFoundException cnfe) {
System.err.println(cnfe);
}
catch (SQLException sqle) {
System.err.println(sqle);
}
}
}
public static void main(String[] ares) {
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String sourceURL =
"jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=csdn0710";
Connection databaseConnection = DriverManager.getConnection(sourceURL,
"sa", "sa");
System.out.println("Connection established successfully!");
Statement stmt = databaseConnection.createStatement();
ResultSet rs = stmt.executeQuery("select * from employee");
ResultSetMetaData rsm = rs.getMetaData();
int columnCount = rsm.getColumnCount();
while (rs.next())
{
for (int i = 0; i < columnCount; i++)
{
{
System.out.print(rs.getString(i+1)+",");
}
}
System.out.println();
} databaseConnection.close();
}
catch (ClassNotFoundException cnfe) {
System.err.println(cnfe);
}
catch (SQLException sqle) {
System.err.println(sqle);
}
}
}
以索引来得到值,索引以1开头!
循环从0到1两次!
for (int i = 0; i < columnCount; i++)
{
{
System.out.print(rs.getString(i+1)+",");
}
}
for (int i = 1; i < =columnCount; i++)
System.out.println(rs.getString(i));
改成
System.out.println(rs.getString(0));//或者直接用名称代替
System.out.println(rs.getString(1));
{
System.out.println(rs.getString("name"));
System.out.println(rs.getInt("age"));
}
for (int i = 1; i < columnCount; i++) { while (rs.next()) {
System.out.println(rs.getString(i));
}
}以上代码只能显示出Name column下的所有数据,可我要是显示Age column下的数据该怎么写?
ResultSetMetaData rsm = RS.getMetaData();
int columnCount = rsm.getColumnCount();
while (RS.next()) {
for(int i=0; i<columnCount; i++){
out.print("<h1>" + RS.getString(i+1)
+"</h1>");
}
}
RS.close();我测试了,,都正常啊 全部字段及全部数据都出来了
我以为这是ultraedit的bug,但后来找了个长名的java文件编译执行都正常.费解!!!