JSP中连接数据库
必须在WebCotent中的lib下导入mysql连接包，然后bulid path。
<%@ page language="java" contentType="text/html; charset=gb2312" %>
<%@ page import="java.sql.*" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<html>
<head>
<title>I查询数据库</title>
</head>
<body>
<%
String driver = "com.mysql.jdbc.Driver"; //驱动程序cims_manage
String url = "jdbc:mysql://localhost:2222/manage";
//String url = "jdbc:mysql://localhost:2222/manage?"
// + "user=root&password=xu199312&useUnicode=true&characterEncoding=utf-8&useSSL=false";
Class.forName(driver);
System.out.println("成功加载MySQL驱动程序");
Connection conn = DriverManager.getConnection(url,"root","xu199312");
System.out.println("连接成功");
//创建SQL语句对象
Statement sql=conn.createStatement();
//执行sql查询
String sqlStr="select*from 用户表";
ResultSet rs=sql.executeQuery(sqlStr);
%>
<table border="1" cellpadding="0" cellspacing="0">
<tr><td colspan="3" align="center">
用户表中的用户</td></tr>
<tr><td>用户ID</td><td>用户姓名</td><td>密码</td>
<%while(rs.next()){ %>
<tr>
<td><%=rs.getInt(1) %></td>
<td><%=rs.getString(2) %></td>
<td><%=rs.getString(3) %></td>
</tr>
<%} %>
</table>
</body>
</html>
若表格中无法显示，Debug as Sever 调试
浙公网安备 33010602011771号