import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.Statement;
public class Dataa {
public static void main(String args[]) throws Exception{
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Connection conn=DriverManager.getConnection("jdbc:sqlserver://localhost:1433; DatabaseName=first",
"sa", "123");
Statement st = conn.createStatement();
// 4.执行语句
ResultSet rs = st.executeQuery("select * from Course");
// 5.处理结果
/*while (rs.next()) {
System.out.println(rs.getObject(1) + "/t" + rs.getObject(2));
}
*/
StringBuffer results = new StringBuffer();
ResultSetMetaData metaData = rs.getMetaData();
int numberOfColumns = metaData.getColumnCount();
for( int i =1; i<= numberOfColumns; i++)
results.append(metaData.getColumnName(i) + "/t");
results.append("/n");
while(rs.next()){
for(int i = 1; i<= numberOfColumns; i++){
results.append(rs.getObject(i)+"/t");
results.append("/n");
}
}
// 6.释放资源
rs.close();
st.close();
conn.close();
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
编译没有错误,但是没有运行的结果,求各位老师帮忙,谢谢