jsp MySql 配置

最新推荐文章于 2024-06-08 12:26:07 发布

chengest

最新推荐文章于 2024-06-08 12:26:07 发布

阅读量115

点赞数

分类专栏： JAVA 文章标签： MySQL JSP Java JDBC Tomcat

JAVA 专栏收录该内容

18 篇文章 0 订阅

订阅专栏

将mysql-connector-java-3.1.14-bin.jar copy到JAVA_HOME
在CLASSPATH追加


 %JAVA_HOME%\jdbc\mysql-connector-java-3.1.14-bin.jar

将mysql-connector-java-3.1.14-bin.jar copy到tomcat/lib目录下
重启tomcat


<%@ page contentType="text/html; charset=utf-8" language="java" import="java.sql.*,com.mysql.jdbc.Driver" errorPage="" %>
<!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>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>test of mysql</title>
</head>

<body>
<table width="300" border="1">
<tr>
<td>序号</td>
<td>姓名</td>
<td>年龄</td>
</tr>
<%
String driverName="org.gjt.mm.mysql.Driver";
String userName="root";
String userPasswd="pwd";
String dbName="test";
String tableName="people";
String url="jdbc:mysql://localhost:3306/"+dbName;

Class.forName(driverName).newInstance();

Connection conn=DriverManager.getConnection(url,userName,userPasswd);

Statement stmt = conn.createStatement();

String sql="SELECT * FROM "+tableName;

ResultSet rs = stmt.executeQuery(sql);

while(rs.next()) {%>
<tr>
<td><%= rs.getString("id") %></td>
<td><%= rs.getString("name") %></td>
<td><%= rs.getString("age") %></td>
</tr>
<%}  
out.print("数据库操作成功，恭喜你");
rs.close();  
stmt.close();  
conn.close();  
%>
</table>


</body>
</html>


String url="jdbc:mysql://"+server+":"+port+"/"+dbname+"?user="+user+"&password="+pass+"&useUnicode=true&characterEncoding=GB2312";

chengest

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
复制链接

分享到 QQ

分享到新浪微博

扫一扫

专栏目录