代码如下:package demo;import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;public class deom1 {
public static void main(String[] args) {
// TODO Auto-generated method stub
Connection con;
Statement stmt;
ResultSet rs;
try{
System.out.println("正在连接数据库.....");
//注册 SQL Server JDBC 驱动程序
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
DriverManager.registerDriver(new com.microsoft.sqlserver.jdbc.SQLServerDriver());
//创建新数据库连接
con=DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=student", "sa", "123456");
System.out.println("连接数据库成功.....");
stmt=con.createStatement();
String query="select * form student";
stmt.execute(query);
rs=stmt.getResultSet();
while(rs.next()){
int id=rs.getInt(1);
String name=rs.getString(2);
String sex=rs.getString(3);
String job=rs.getString(4);
System.out.println("编号"+"\t"+"姓名"+"\t"+"性别"+"\t"+"职业");
System.out.println(id+"\t"+name+"\t"+sex+"\t"+job);
}
}catch (ClassNotFoundException e1) {
e1.getMessage();
} catch (SQLException e2) {
e2.getMessage();
}
}}
运行输出如图:却不能打印出数据库中的数据!数据库中我添加了数据的!请教这是怎么回事?
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;public class deom1 {
public static void main(String[] args) {
// TODO Auto-generated method stub
Connection con;
Statement stmt;
ResultSet rs;
try{
System.out.println("正在连接数据库.....");
//注册 SQL Server JDBC 驱动程序
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
DriverManager.registerDriver(new com.microsoft.sqlserver.jdbc.SQLServerDriver());
//创建新数据库连接
con=DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=student", "sa", "123456");
System.out.println("连接数据库成功.....");
stmt=con.createStatement();
String query="select * form student";
stmt.execute(query);
rs=stmt.getResultSet();
while(rs.next()){
int id=rs.getInt(1);
String name=rs.getString(2);
String sex=rs.getString(3);
String job=rs.getString(4);
System.out.println("编号"+"\t"+"姓名"+"\t"+"性别"+"\t"+"职业");
System.out.println(id+"\t"+name+"\t"+sex+"\t"+job);
}
}catch (ClassNotFoundException e1) {
e1.getMessage();
} catch (SQLException e2) {
e2.getMessage();
}
}}
运行输出如图:却不能打印出数据库中的数据!数据库中我添加了数据的!请教这是怎么回事?
rs=stmt.getResultSet();改成rs=stmt.executeQuery(query);