Java_Web Project_jdbc数据库连接底层；

来源：互联网发布：淘宝优惠券转手机端编辑：程序博客网时间：2024/05/21 09:58

特别说明：如果能帮助到您，请您留下点滴痕迹，让我知道我的存在是有意义的；如果不能帮助到您，请接受我的歉意；

文章简介：介绍在Java Web Project项目中，如何通过jdbc连接数据库；

web.xml

<?xml version="1.0" encoding="GBK"?><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/javaeehttp://java.sun.com/xml/ns/javaee/web-app_3_0.xsd"version="3.0"><!-- 配置第一个参数：driver --><context-param><param-name>driver</param-name><param-value>com.mysql.jdbc.Driver</param-value></context-param><!-- 配置第二个参数：url --><context-param><param-name>url</param-name><param-value>jdbc:mysql://localhost:3306/javaee</param-value></context-param><!-- 配置第三个参数：user --><context-param><param-name>user</param-name><param-value>root</param-value></context-param><!-- 配置第四个参数：pass --><context-param><param-name>pass</param-name><param-value>32147</param-value></context-param><servlet><!-- 指定Servlet名字 --><servlet-name>config</servlet-name><!-- 指定将哪个JSP页面配置成Servlet --><jsp-file>/configTest2.jsp</jsp-file><!-- 配置名为name的参数，值为yeeku --><init-param><param-name>name</param-name><param-value>yeeku</param-value></init-param><!-- 配置名为age的参数，值为30 --><init-param><param-name>age</param-name><param-value>30</param-value></init-param></servlet><servlet-mapping><!-- 指定将config Servlet配置到/config URL--><servlet-name>config</servlet-name><url-pattern>/config</url-pattern></servlet-mapping></web-app>

java_jsp

<%@ page contentType="text/html; charset=GBK" language="java" errorPage="" %><%@ page import="java.sql.*" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN""http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><title>application测试</title><meta name="website" content="http://www.crazyit.org" /></head><body><%//从配置参数中获取驱动String driver = application.getInitParameter("driver");//从配置参数中获取数据库urlString 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 * from news_inf");%><table bgcolor="#9999dd" border="1" width="480"><%//遍历结果集while(rs.next()){%><tr><td><%=rs.getString(1)%></td><td><%=rs.getString(2)%></td></tr><%}%><table></body></html>

0 0