web.xml数据源配置

最新推荐文章于 2023-11-15 18:33:15 发布

Niuzx

最新推荐文章于 2023-11-15 18:33:15 发布

阅读量1.2k

点赞数

文章标签： web.xml 数据源配置

本文链接：https://blog.csdn.net/niu_zhixin/article/details/38096969

版权

在web应用中可以将数据源配置写在web.xml文件中,通过jsp访问数据库代码如下:

web.xml
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns="http://java.sun.com/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" version="3.0">
<!-- 配置weib应用的首页列表-->
<welcome-file-list>
	<welcome-file>index.jsp</welcome-file>
</welcome-file-list>
<!-- 配置第一个参数:driver -->
<context-param>
	<param-name>driver</param-name>
	<param-value>net.sourceforge.jtds.jdbc.Driver</param-value>
</context-param>
<!-- 配置第二参数:url -->
<context-param>
	<param-name>url</param-name>
	<param-value>jdbc:jtds:sqlserver://localhost:1433;DatabaseName=kydb</param-value>
</context-param>
<!-- 配置第三参数:user -->
<context-param>
	<param-name>user</param-name>
	<param-value>sa</param-value>
</context-param>
<!-- 配置第四个参数:password -->
<context-param>
	<param-name>pass</param-name>
	<param-value>qwe123</param-value>
</context-param>
</web-app>

jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    errorPage=""%>
<%@ page import ="java.sql.*" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>application测试</title>
</head>
<body>
<%
//从配置参数中获取驱动
String driver=application.getInitParameter("driver");
//从配置参数中获取数据库URL
String url=application.getInitParameter("url");
//从配置参数中获取用户名
String user=application.getInitParameter("user");
//从配置参数中获取密码
String pass=application.getInitParameter("pass");
//注册驱动
Class.forName(driver);
//获取数据库连接
Connection conn=DriverManager.getConnection(url,user,pass);
//创建Statement对象
Statement stmt=conn.createStatement();
//执行查询
ResultSet rs=stmt.executeQuery("select top(10)* from fin_voucher_detail");
%>
<table bgcolor="#9999dd" border="1" width="480px">
<%
while(rs.next()){
%>
	<tr>
		<td><%=rs.getString(1) %></td>
		<td><%=rs.getString(2) %></td>
	</tr>
<%		
}
%>
</body>
</html>