📄 testsql2000.jsp
字号:
<%@ page info="database handler" %>
<%@ page import="java.io.*" %>
<%@ page import="java.util.*" %>
<%@ page import="java.sql.*" %>
<%@ page import="javax.servlet.*" %>
<%@ page import="javax.servlet.http.*" %>
<%@ page contentType="text/html;charset=gb2312" language="java"%>
<%
//声明
String url = "jdbc:microsoft:sqlserver://";
String serverName= "localhost";
String portNumber = "1433";
String databaseName= "Stuinfor";
String userName="guohai";
String userPasswd="12345";
java.sql.Connection sqlConn;//数据库连接对象
java.sql.Statement sqlStmt;//语句对象
java.sql.ResultSet sqlRst;//结果对象集
//登记JDBC驱动程序
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
//连接数据库
sqlConn=java.sql.DriverManager.getConnection(url+serverName+":"+portNumber+";databaseName="+databaseName,
userName,userPasswd);
//创建语句对象
sqlStmt=sqlConn.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,
java.sql.ResultSet.CONCUR_READ_ONLY);
//执行SQL语句
sqlRst=sqlStmt.executeQuery("SELECT NAME,ID from student");
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312 ">
<title>JSP连接SQL2000测试</title>
</head>
<body>
<table border="1" cellspacing="0" cellpadding="0" align="center">
<tr>
<th>姓名</th>
<th>学号</th>
</tr>
<%while(sqlRst.next()) {%>
<tr>
<td><%=sqlRst.getString(1)%></td>
<td><%=sqlRst.getLong(2)%></td>
</tr>
<%}%>
</table>
</body>
</html>
<%
//关闭结果对象集
sqlRst.close();
//关闭语句对象
sqlStmt.close();
//关闭数据库连接
sqlConn.close();
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -