jsp中连接MySQL数据库

来源：互联网发布：mysql 保持数据一致性编辑：程序博客网时间：2024/04/29 23:06

将MySQL驱动放在tomcat的common目录下的lib目录下，

<%@page import="java.sql.ResultSet"%><%@page import="java.sql.DriverManager"%><!-- 代替下面两个包 --><%@page import="java.sql.Connection"%><%@page import="java.sql.Statement"%><!-- 包导错了，需要用上面的代替，否则出错 --><%-- <%@page import="com.mysql.jdbc.Statement"%> --%> <%-- <%@page import="com.mysql.jdbc.Connection"%>  --%>   <%@page import="com.mysql.*" %><%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html>  <head>    <h2>连接MySQL数据库</h2>  </head>    <body>     <%Class.forName("com.mysql.jdbc.Driver").newInstance();//加载驱动       Connection conn = DriverManager.getConnection("jdbc:mysql://localhost/mysql123","root","");       Statement stmt = conn.createStatement();       ResultSet rs = stmt.executeQuery("select * from student");       while(rs.next())       { %>       <%=rs.getString("username") %>       <%=rs.getString("password") %><br>       <%}        rs.close();       conn.close();       %>         </body></html>

0 0