java:jdk 1.7
sever:tomcat 7.0
MySql驱动:mysql-connector-java-5.1.22-bin.jar
运行环境eclipsejee
注意使用时别忘了将mysql-connector-java-5.1.22-bin.jar导入到你的Tomcat目录里的lib文件夹内,要不然会出现
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver 错误
<%@ page contentType="text/html" pageEncoding="utf-8" %>
<%@ page import="java.sql.*" %>
<html>
<head>
<title>jsp连接数据库案例</title>
<!-- CSS美化表格 -->
<style type="text/css">
table {
width: 90%;
background: #ccc;
margin: 10px auto;
border-collapse: collapse;
}
th, td {
height: 25px;
line-height: 25px;
text-align: center;
border: 1px solid #333333;
}
th {
background: #eee;
font-weight: normal;
}
tr {
background: #fff;
}
tr:hover {
background: #00CC33;
}
</style>
</head>
<body>
<%!public static final String db_Driver = "com.mysql.jdbc.Driver";
public static final String url = "jdbc:mysql://localhost:3306/mydatabase";
public static final String user = "root";
public static final String password = "root";%>
<%
Connection connection = null;
PreparedStatement pre = null;
ResultSet result = null;
%>
<%
try{
Class.forName(db_Driver);
connection = DriverManager.getConnection(url, user, password);
String sql = "select * from student";
pre = connection.prepareStatement(sql);
result = pre.executeQuery();
%>
<center>
<table border="1" width="80%">
<tr>
<td>name</td>
<td>age</td>
<td>num</td>
</tr>
<%
while(result.next()){
String name=result.getString(1);
String age=result.getString(2);
String num=result.getString(3);
%>
<tr>
<td><%=name%></td>
<td><%=age%></td>
<td><%=num%></td>
</tr>
<%
}
%>
</table>
</center>
<%
}catch(Exception e){
System.out.println(e);
}finally{
result.close();
pre.close();
connection.close();
}
%>
</body>
</html>