SQL 2005 和 eclipse 的问题

来源：百度知道 编辑：UC知道 时间：2024/06/10 20:14:15
public class mySQL {

private final String DRIVER = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
private final String URL = "jdbc:sqlserver://localhost:1433;DatabaseName=Grade1";
private String sql = "select name,age from student";

public Connection con;
public Statement stmt;
public ResultSet rs;

public mySQL() {
try {
Class.forName(DRIVER); // 加载驱动器
con = DriverManager.getConnection(URL, "sa", "123456"); // 连接数据库
stmt = con.createStatement();
rs = stmt.executeQuery(sql);
while (rs.next()) {
System.out.println("用户名为" + rs.getString(1) + "密码为"
+ rs.getString(2));
}
rs.close();
stmt.close();
con.close();
} catch (ClassNotFoundException ex) { // 因类不存在,加载失败
ex.printStackTrace();
} catch (SQLException ex) {
ex.printStackTrace();

public class mySQL {

private final String DRIVER = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
private final String URL = "jdbc:sqlserver://localhost:1433;DatabaseName=Grade1";
private String sql = "select name,age from student";

public Connection con;
public Statement stmt;
public ResultSet rs;

try {
Class.forName(DRIVER); // 加载驱动器
con = DriverManager.getConnection(URL, "sa", "123456"); // 连接数据库
stmt = con.createStatement();
rs = stmt.executeQuery(sql);
while (rs.next()) {
System.out.println("用户名为" + rs.getString(1) + "密码为"
+ rs.getString(2));
}
rs.close();
stmt.close();
con.close();
} catch (ClassNotFoundException ex) { // 因类不存在,加载失败
ex.printStackTrace();
}
}

把它改为这样 直接运行试试！