jsp页面:
<%
//从配置中获取数据库驱动
String driver=application.getInitParameter("driver");
//从数据库中得到数据URL
String url=application.getInitParameter("url");
//从配置中得到用户名
String user=application.getInitParameter("username");
//从配置中得到密码
String pass=application.getInitParameter("password");
//注册驱动
Class.forName(driver); /
/获取数据库连接
Connection con=DriverManager.getConnection(url,user,pass);
//执行pr对象
PreparedStatement prs=con.prepareStatement("select * from stu");
//Statement prs=con.createStatement();
//执行查询
ResultSet rs=prs.executeQuery(); %> <table> <%
//遍历查询 while(rs.next()) {%>
<tr> <td><%=rs.getString(1) %></td>
<td><%=rs.getString(2)%></td> <%
} %>
web.xml配置
- <!-- 配置第一个参数数据库驱动 -->
- <context-param>
- <param-name>driver</param-name>
- <param-value>com.microsoft.sqlserver.jdbc.SQLServerDriver</param-value>
- </context-param>
- <!-- 配置第二个参数:url -->
- <context-param>
- <param-name>url</param-name>
- <param-value>jdbc:sqlserver://localhost:1433;databaseName=aa</param-value>
- </context-param>
- <!-- 配置第三个参数:数据库用户-->
- <context-param>
- <param-name>username</param-name>
- <param-value>sa</param-value>
- </context-param>
- <!-- 配置第四个参数:数据库密码 -->
- <context-param>
- <param-name>password</param-name>
- <param-value>sa</param-value>
- </context-param>