try {
// 1.注册驱动 构造驱动实例
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
// new oracle.jdbc.driver.OracleDriver();
// 2.指定连接字符串 @机器IP 端口号 数据库名称
String url ="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs";
// 3.打开数据库联接
Connection conn = DriverManager
.getConnection(url, "sa", "111111");
// 4.构造查询语句对象
Statement stme = conn.createStatement();
// 5.提交查询语句并获得结果集
ResultSet rs = stme.executeQuery("select * from person");
// 6.遍历结果集
while (rs.next()) {
out.print(rs.getString(1));
out.print(rs.getString(2));
}
rs.close();
stme.close();
conn.close();
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
%>
取消
评论
