Tomcat+Jsp访问mysql5.*数据库

最新推荐文章于 2024-09-26 15:33:22 发布

aoyo

最新推荐文章于 2024-09-26 15:33:22 发布

阅读量1.1k

点赞数

文章标签： import jsp Jsp JSP mysql MySQL Mysql MYSQL string String tomcat Tomcat

本文链接：https://blog.csdn.net/aoyo/article/details/826050

版权

Tomcat+Jsp来访问mysql数据库：

1、安装好 tomcat和mysqlshuu下载mysql-connector-java.zip，然后解压缩出两个文件，我下载的是mysql-connector-java-5.0.0-beta，所以两个文件是mysql-connector-java-5.0.0-beta-bin.jar和mysql-connector-java-5.0.0-beta-bin-g.jar；

2、将mysql-connector-java-5.0.0-beta-bin.jar拷贝到apache-tomcat/common/lib目录下，重新启动tomcat；

3、写个jsp文件，如test.jsp：

<%@ page import="java.io.*" %>
<%@ page import="java.util.*" %>
<%@ page import="java.sql.*" %>
<%@ page contentType="text/html;charset=gb2312" %>

<html>
<head>
<title>DbJsp.jsp</title>
</head>
<body>
<%
Connection con;
Statement stmt;
ResultSet rs;

Class.forName("com.mysql.jdbc.Driver");
//Class.forName("org.gjt.mm.mysql.Driver").newInstance();

DriverManager.registerDriver(new com.mysql.jdbc.Driver());
String dbUrl = "jdbc:mysql://localhost:3306/BookDB?userUnicode=true&characterEncoding=GB2312";
String dbUser="user";
String dbPwd="123456";
con = java.sql.DriverManager.getConnection(dbUrl,dbUser,dbPwd);
stmt = con.createStatement();
rs = stmt.executeQuery("select id,name,title,price from books");
out.println("<table border width=400>");
while(rs.next())
{
  String col1 = rs.getString(1);
  String col2 = rs.getString("name");
  String col3 = rs.getString(3);
  String col4 = rs.getString(4);

out.println("<tr><td>"+ col1 +"</td><td>"+ col2 +"</td><td>"+ col3 +"</td><td>"+ col4 +"</td></tr>");
}
out.println("</table>");

rs.close();
stmt.close();
con.close();
%>
</body>
</html>

4、在apache-tomcat/webapps/目录建立myapp,将jsp文件存放在myapp目录下；用IE访问localhost:8080/myapp/test.jsp，信息显示，ok。