代码如下。importjava.sql.*;publicclassselection_all{publicstaticvoidmain(String[]srg){StringdriverName="com.microsoft.sqlserver.jdbc.SQLServerDriver";//加载JDBC驱动String...
代码如下。
import java.sql.*;
public class selection_all {
public static void main(String[] srg) {
String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; // 加载JDBC驱动
String dbURL = "jdbc:sqlserver://localhost:1433; DatabaseName=Test1"; // 连接服务器和数据库test
String userName = "sa";
String userPwd = "123";
Connection dbConn = null;
try {
Class.forName(driverName);
dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
Statement s = dbConn.createStatement();
ResultSet rs=s.executeQuery("Select * from student");
while(rs.next()){
System.out.println(rs.getString("name")+"\t"+rs.getString("no")+"\t");
}
s.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
现在是输出在窗口之外,我想在新建窗口输出或者对话框输出要如何实现,在线等,谢谢了
展开