原文链接:JavaWeb数据库学生宿舍图书管理系统+地图
- 登陆之后现实主页面,账号密码储存在数据库中。
- 实现对数据库的增删改查
java 9.0.4 + mysql 8.0.19 + Navicat 8 lite + eclipse 2019-12 + mysql-connector-java-8.0.19.jar
环境搭建:
安装jdk mysql Navicat
打开eclipse / window / Preferences / Server / Runtime Environments / Add
选择Apache版本9 → next 路径,jre 选择。
最后应用 Apply and Close
新建项目之后,连接数据库
直接将 mysql-connector-java-8.0.19.jar 粘贴进 WebContent 下 WEB-INF lib 下
项目开始:
数据库设计
代码:
text1.jsp
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>主页</title>
<link rel="stylesheet" href="css/stduent.css" type="text/css">
</head>
<body>
<div class="header">
<h1>花店会员管理系统</h1>
</div>
<div class="topnav">
<a href="text1.jsp">主页</a>
<a href="text2.jsp">插入会员信息</a>
<a href="text4.jsp">删除会员信息</a>
<a href="text6.jsp">修改会员信息</a>
<a href="text8.jsp">查询会员信息</a>
<a href="map.html">花店地址</a>
</div>
</body>
</html>
text2.jsp
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.Connection"%>
<%@page import="java.sql.Statement"%>
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>Insert title here</title>
<title>主页</title>
<link rel="stylesheet" href="css/stduent.css" type="text/css">
</head>
<body>
<div class="header">
<h1>花店会员管理系统</h1>
</div>
<div class="topnav">
<a href="text1.jsp">主页</a>
<a href="text2.jsp">插入会员信息</a>
<a href="text4.jsp">删除会员信息</a>
<a href="text6.jsp">修改会员信息</a>
<a href="text8.jsp">查询会员信息</a>
<a href="map.html">花店地址</a>
</div>
<div>
<p>添加会员到数据库</p>
<form action="text3.jsp">
新的会员编号:<input type="text" name="id"><br>
新的会员姓名:<input type="text" name="name"><br>
充值金额:<input type="text" name="math"><br>
购买次数:<input type="text" name="english"><br>
积分:<input type="text" name="physics"><br>
<input type="submit" name="submit" value="提交新的">
</form>
<p>提交想的数据之前的数据表内容</p>
<%
Connection conn=null;
Statement stm=null;
ResultSet rst=null;
try{
Class.forName("com.mysql.cj.jdbc.Driver");
conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/student?useSSL=true&serverTimezone=GMT","root","root");
stm=conn.createStatement();
//String sql="select * from score";
rst=stm.executeQuery("select * from score");
out.print("<table border='1'>");
out.print("<tr>");
out.print("<th>编号</th>");
out.print("<th>姓名</th>");
out.print("<th>充值金额</th>");
out.print("<th>购买次数</th>");
out.print("<th>积分</th>");
out.print("</tr>");
while(rst.next()){
out.print("<tr>");
out.print("<th>"+rst.getString("id")+"</th>");
out.print("<th>"+rst.getString(2)+"</th>");
out.print("<th>"+rst.getInt(3)+"</th>");
out.print("<th>"+rst.getInt(4)+"</th>");
out.print("<th>"+rst.getInt(5)+"</th>");
out.print("</tr>");
}
out.print("</table>");
conn.close();
}catch(Exception e){
e.printStackTrace();
}
%>
</div>
</body>
</html>
text3.jsp
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.Connection"%>
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>Insert title here</title>
<title>主页</title>
<link rel="stylesheet" href="css/stduent.css" type="text/css">
</head>
<body>
<div class="header">
<h1>花店会员管理系统</h1>
</div>
<div class="topnav">
<a href="text1.jsp">主页</a>
<a href="text2.jsp">插入会员信息</a>
<a href="text4.jsp">删除会员信息</a>
<a href="text6.jsp">修改会员信息</a>
<a href="text8.jsp">查询会员信息</a>
<a href="map.html">花店地址</a>
</div>
<div>
<p>插入新记录1条</p>
<%
String id=request.getParameter("id");
if(id==null){
id="0000";
}
String name=request.getParameter("name");
if(name==null){
name="无名氏";
}
String math=request.getParameter("math");
if(math==null){
math="0";
}
String english=request.getParameter("english");
if(english==null){
english="0";
}
String physics=request.getParameter("physics");
if(physics==null){
physics="0";
}
Connection conn=null;
Statement stm=null;
ResultSet rst=null;
try{
Class.forName("com.mysql.cj.jdbc.Driver");
conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/student?useSSL=true&serverTimezone=GMT","root","root");
stm=conn.createStatement();
String sql="insert into score values('"+id+"','"+name+"','"+math+"','"+english+"','"+physics+"')";
stm.executeUpdate(sql);
rst=stm.executeQuery("select * from score");
out.print("<table border='1'>");
out.print("<tr>");
out.print("<th>编号</th>");
out.print("<th>姓名</th>");
out.print("<th>充值金额</th>");
out.print("<th>购买次数</th>");
out.print("<th>积分</th>");
out.print("</tr>");
while(rst.next()){
out.print("<tr>");
out.print("<th>"+rst.getString("id")+"</th>");
out.print("<th>"+rst.getString(2)+"</th>");
out.print("<th>"+rst.getInt(3)+"</th>");
out.print("<th>"+rst.getInt(4)+"</th>");
out.print("<th>"+rst.getInt(5)+"</th>");
out.print("</tr>");
}
out.print("</table>");
conn.close();
}catch(Exception e){
e.printStackTrace();
}
%>
</div>
</body>
</html>
text4.jsp
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.Connection"%>
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>Insert title here</title>
<title>主页</title>
<link rel="stylesheet" href="css/stduent.css" type="text/css">
</head>
<body>
<div class="header">
<h1>花店会员管理系统</h1>
</div>
<div class="topnav">
<a href="text1.jsp">主页</a>
<a href="text2.jsp">插入会员信息</a>
<a href="text4.jsp">删除会员信息</a>
<a href="text6.jsp">修改会员信息</a>
<a href="text8.jsp">查询会员信息</a>
<a href="map.html">花店地址</a>
</div>
<div class="content">
<p>请输入删除会员的编号</p>
<form action="text5.jsp">
<input type="text" name="id">
<input type="submit" name="submit" value="提交编号">
</form>
<p>删除记录前的会员信息</p>
<%
Connection conn=null;
Statement stm=null;
ResultSet rst=null;
try{
Class.forName("com.mysql.cj.jdbc.Driver");
conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/student?useSSL=true&serverTimezone=GMT","root","root");
stm=conn.createStatement();
String sql="select * from score";
rst=stm.executeQuery(sql);
out.print("<table border='1'>");
out.print("<tr>");
out.print("<th width='100'>编号</th>");
out.print("<th width='100'>姓名</th>");
out.print("<th width='100'>充值金额</th>");
out.print("<th width='100'>购买次数</th>");
out.print("<th width='100'>积分</th>");
out.print("</tr>");
while(rst.next()){
out.print("<tr>");
out.print("<th>"+rst.getString("id")+"</th>");
out.print("<th>"+rst.getString(2)+"</th>");
out.print("<th>"+rst.getInt(3)+"</th>");
out.print("<th>"+rst.getInt(4)+"</th>");
out.print("<th>"+rst.getInt(5)+"</th>");
out.print("</tr>");
}
out.print("</table>");
conn.close();
}catch(Exception e){
e.printStackTrace();
}
%>
</div>
</body>
</html>
text5.jsp
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.Connection"%>
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>Insert title here</title>
<title>主页</title>
<link rel="stylesheet" href="css/stduent.css" type="text/css">
</head>
<body>
<div class="header">
<h1>花店会员管理系统</h1>
</div>
<div class="topnav">
<a href="text1.jsp">主页</a>
<a href="text2.jsp">插入会员信息</a>
<a href="text4.jsp">删除会员信息</a>
<a href="text6.jsp">修改会员信息</a>
<a href="text8.jsp">查询会员信息</a>
<a href="map.html">花店地址</a>
</div>
<div class="content">
<%
Connection conn=null;
Statement stm=null;
ResultSet rst=null;
String id=request.getParameter("id");
try{
Class.forName("com.mysql.cj.jdbc.Driver");
conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/student?useSSL=true&serverTimezone=GMT","root","root");
stm=conn.createStatement();
String str="delete from score where id='"+id+"'";
stm.executeUpdate(str);
out.print("删除记录后的会员信息");
String sql="select * from score";
rst=stm.executeQuery(sql);
out.print("<table border='1'>");
out.print("<tr>");
out.print("<th width='100'>编号</th>");
out.print("<th width='100'>姓名</th>");
out.print("<th width='100'>充值金额</th>");
out.print("<th width='100'>购买次数</th>");
out.print("<th width='100'>积分</th>");
out.print("</tr>");
while(rst.next()){
out.print("<tr>");
out.print("<th>"+rst.getString("id")+"</th>");
out.print("<th>"+rst.getString(2)+"</th>");
out.print("<th>"+rst.getInt(3)+"</th>");
out.print("<th>"+rst.getInt(4)+"</th>");
out.print("<th>"+rst.getInt(5)+"</th>");
out.print("</tr>");
}
out.print("</table>");
}catch(Exception e){
e.printStackTrace();
}finally{
if(conn!=null){
conn.close();
}
}
%>
</div>
</body>
</html>
text6.jsp
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.Connection"%>
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>Insert title here</title>
<title>主页</title>
<link rel="stylesheet" href="css/stduent.css" type="text/css">
</head>
<body>
<div class="header">
<h1>花店会员管理系统</h1>
</div>
<div class="topnav">
<a href="text1.jsp">主页</a>
<a href="text2.jsp">插入会员信息</a>
<a href="text4.jsp">删除会员信息</a>
<a href="text6.jsp">修改会员信息</a>
<a href="text8.jsp">查询会员信息</a>
<a href="map.html">花店地址</a>
</div>
<div class="content">
<p>请输入要修改的会员的姓名:</p>
<form action="text7.jsp">
要修改的会员的姓名:<input type="text" name="name"><br>
新的充值金额:<input type="text" name="math"><br>
新的购买次数:<input type="text" name="english"><br>
新的积分:<input type="text" name="physics"><br>
<input type="submit" name="submit" value="修改">
</form>
<p>修改记录前的会员信息</p>
<%
Connection conn=null;
Statement stm=null;
ResultSet rst=null;
try{
Class.forName("com.mysql.cj.jdbc.Driver");
conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/student?useSSL=true&serverTimezone=GMT","root","root");
stm=conn.createStatement();
String sql="select * from score";
rst=stm.executeQuery(sql);
out.print("<table border='1'>");
out.print("<tr>");
out.print("<th width='100'>编号</th>");
out.print("<th width='100'>姓名</th>");
out.print("<th width='100'>充值金额</th>");
out.print("<th width='100'>购买次数</th>");
out.print("<th width='100'>积分</th>");
out.print("</tr>");
while(rst.next()){
out.print("<tr>");
out.print("<th>"+rst.getString("id")+"</th>");
out.print("<th>"+rst.getString(2)+"</th>");
out.print("<th>"+rst.getInt(3)+"</th>");
out.print("<th>"+rst.getInt(4)+"</th>");
out.print("<th>"+rst.getInt(5)+"</th>");
out.print("</tr>");
}
out.print("</table>");
conn.close();
}catch(Exception e){
e.printStackTrace();
}finally{
if(conn!=null){
conn.close();
}
}
%>
</div>
</body>
</html>
text7.jsp
<%@page import="java.sql.PreparedStatement"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.Connection"%>
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>Insert title here</title>
<title>主页</title>
<link rel="stylesheet" href="css/stduent.css" type="text/css">
</head>
<body>
<div class="header">
<h1>花店会员管理系统</h1>
</div>
<div class="topnav">
<a href="text1.jsp">主页</a>
<a href="text2.jsp">插入会员信息</a>
<a href="text4.jsp">删除会员信息</a>
<a href="text6.jsp">修改会员信息</a>
<a href="text8.jsp">查询会员信息</a>
<a href="map.html">花店地址</a>
</div>
<div class="content">
<%
Connection conn=null;
Statement stm=null;
ResultSet rst=null;
PreparedStatement pstmt=null;
String n=request.getParameter("name");
String a=request.getParameter("math");
String b=request.getParameter("english");
String c=request.getParameter("physics");
try{
Class.forName("com.mysql.cj.jdbc.Driver");
conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/student?useSSL=true&serverTimezone=GMT","root","root");
String str="update score set math=?,english=?,physics=? where name=?";
pstmt=conn.prepareStatement(str);
pstmt.setString(1, a);
pstmt.setString(2, b);
pstmt.setString(3, c);
pstmt.setString(4, n);
pstmt.executeUpdate();
out.print("更新记录后的会员信息");
String sql="select * from score";
rst=pstmt.executeQuery(sql);
out.print("<table border='1'>");
out.print("<tr>");
out.print("<th width='100'>编号</th>");
out.print("<th width='100'>姓名</th>");
out.print("<th width='100'>充值金额</th>");
out.print("<th width='100'>购买次数</th>");
out.print("<th width='100'>积分</th>");
out.print("</tr>");
while(rst.next()){
out.print("<tr>");
out.print("<th>"+rst.getString(1)+"</th>");
out.print("<th>"+rst.getString(2)+"</th>");
out.print("<th>"+rst.getInt(3)+"</th>");
out.print("<th>"+rst.getInt(4)+"</th>");
out.print("<th>"+rst.getInt("physics")+"</th>");
out.print("</tr>");
}
out.print("</table>");
}catch(Exception e){
e.printStackTrace();
}finally{
if(conn!=null){
conn.close();
}
}
%>
</div>
</body>
</html>
</body>
</html>
text8.jsp
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.Connection"%>
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>Insert title here</title>
<title>查询</title>
<link rel="stylesheet" href="css/stduent.css" type="text/css">
</head>
<body>
<div class="header">
<h1>花店会员管理系统</h1>
</div>
<div class="topnav">
<a href="text1.jsp">主页</a>
<a href="text2.jsp">插入会员信息</a>
<a href="text4.jsp">删除会员信息</a>
<a href="text6.jsp">修改会员信息</a>
<a href="text8.jsp">查询会员信息</a>
<a href="map.html">花店地址</a>
</div>
<div class="content">
<%
Connection conn=null;
Statement stm=null;
ResultSet rst=null;
try{
Class.forName("com.mysql.cj.jdbc.Driver");
conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/student?useSSL=true&serverTimezone=GMT","root","root");
stm=conn.createStatement();
String sql="select * from score";
rst=stm.executeQuery(sql);
out.print("所有会员信息");
out.print("<table border='1'>");
out.print("<tr>");
out.print("<th width='100'>编号</th>");
out.print("<th width='100'>姓名</th>");
out.print("<th width='100'>充值金额</th>");
out.print("<th width='100'>购买次数</th>");
out.print("<th width='100'>积分</th>");
out.print("</tr>");
while(rst.next()){
out.print("<tr>");
out.print("<th>"+rst.getString(1)+"</th>");
out.print("<th>"+rst.getString(2)+"</th>");
out.print("<th>"+rst.getInt(3)+"</th>");
out.print("<th>"+rst.getInt(4)+"</th>");
out.print("<th>"+rst.getInt("physics")+"</th>");
out.print("</tr>");
}
out.print("</table>");
}catch(Exception e){
e.printStackTrace();
}finally{
if(conn!=null){
conn.close();
}
}
%>
</div>
</body>
</body>
</html>
login.jsp
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>Insert title here</title>
</head>
<body>
<form action="CheckUser">
用户名:<input type="text" name="username"><br>
密 码:<input type="password" name="pwd"><br>
<input type="submit" value="登录">
</form>
</body>
</html>
map.html
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>百度地图API自定义地图</title>
<!-- 引用百度地图api -->
<link rel="stylesheet" href="css/map.css">
<script type="text/javascript"
src="http://api.map.baidu.com/api?v=2.0&ak=申请的百度地图API"></script>
</head>
<body onload="display()">
<!-- 头部区域 -->
<div id="header">
<h1>我的导航地图</h1>
</div>
<!-- 内容区域 -->
<div class="row">
<div class="left">
<div class="map" id="mymap"></div>
</div>
<div class="right">
<div class="card">
<form action="#" onsubmit="return false">
<label>输入坐标</label>
<h5>经度</h5>
<input type="text" placeholder="请输入经度" id="longitute">
<h5>维度</h5>
<input type="text" placeholder="请输入维度" id="latitute">
<!-- submit提交 -->
<input type="submit"onclick ="display()">
</form>
</div>
</div>
</div>
<!-- 底部区域 -->
<div class="footer"><p>@ 2020 百度地图</p>
</div>
<script type="text/javascript">
function display() {
//GL版命名空间为BMap
var x = document.getElementById("longitute").value;//value表示文本框的值
var y = document.getElementById("latitute").value;
if (x == "" || y == "") {
x = 119.150;
y = 36.760;
}
var map = new BMap.Map("mymap");
map.centerAndZoom(new BMap.Point(x, y), 15);
map.enableScrollWheelZoom(true);
map.enableKeyboard();
map.enableDragging();
map.enableDoubleClick();
}
</script>
</body>
</html>
1.js
function display() {
var x = document.getElementById("x" ).value;
var y = document.getElementById("y").value;
if (x == "" || y== "") {
X = 119.184801;
y = 36.677454;
}
var map = new BMapGL.Map("allmap");
map.centerAndZoom(new BMapGL.Point(x,y), 14);
map.enableScrollWheelZoom(true);
}
map.css
*{
box-sizing: border-box;
}
body{
max-width: 1260px;
margin: auto;
}
#header{
background-color: #f1f1f1;
padding: 20px;
text-align: center;
/* 设置圆角 */
border-radius: 10px;
}
.row::after{
/* 浮动 */
content: "";
/* 显示方式 */
display: table;
/* 清除两边 */
clear: both;
}
.left{
width: 80%;
float:left;
}
.right{
width: 20%;
float: left;
}
.map {
width: 100%;
height: 800px;
margin-top:10px;
background-color: #ddd;
}
.card {
width:100%;
margin-top:10px;
background-color: #f1f1f1;
padding: 20px;
margin-left: 10px;
border-radius: 10px;
}
.footer{
background-color: #f1f1f1;
padding: 20px;
text-align: center;
margin-top: 10px;
border-radius: 10px;
}
input[type=text]{
border:1px solid green;
padding: 10px 12px;
resize: vertical;
width: 100%;
}
input[type=submit]{
border:1px solid green;
background-color:green;
padding: 12px;
margin: 20px auto;
color: white;
display: block;
}
student.css
*{
box-sizing: border-box;
}
body {
max-width: 1260px;
background-color: #f1f1f1;
margin: 0 auto;
}
.header{
background-color: #333;
text-align: center;
color: white;
padding: 30px;
}
.topnav{
background-color: green;
}
.topnav a{
text-decoration: name;
padding: 14px 20px;
display: inline-block;
font-size: 20px;
color: white;;
}
.tapnav a:hover {
background-color: #555;
}
web.xml
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://xmlns.jcp.org/xml/ns/javaee" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd" version="4.0">
<display-name>6.10_login</display-name>
<welcome-file-list>
<welcome-file>index.html</welcome-file>
<welcome-file>index.htm</welcome-file>
<welcome-file>index.jsp</welcome-file>
<welcome-file>default.html</welcome-file>
<welcome-file>default.htm</welcome-file>
<welcome-file>default.jsp</welcome-file>
</welcome-file-list>
<servlet>
<servlet-name>checkuser</servlet-name>
<servlet-class>com.servlet.CheckUser</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>checkuser</servlet-name>
<url-pattern>/com.servlet.CheckUser</url-pattern>
</servlet-mapping>
</web-app>
failure.jsp
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>Insert title here</title>
</head>
<body>
<h1>你的用户名或密码不正确!</h1>
</body>
</html>
CheckUser.java
package servlet;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
/**
* Servlet implementation class CheckUser
*/
@WebServlet("/CheckUser")
public class CheckUser extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
* @see HttpServlet#HttpServlet()
*/
public CheckUser() {
// TODO Auto-generated constructor stub
}
/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse
* response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
// TODO Auto-generated method stub
String username = request.getParameter("username");
String password = request.getParameter("pwd");
UserBean user = new UserBean();
user.setUsername(username);
user.setPassword(password);
HttpSession session = request.getSession();
Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;
final String Driver = "com.mysql.cj.jdbc.Driver";
final String URL = "jdbc:mysql://localhost:3306/student?userSSL=true&serverTimezone=GMT";
final String USERNAME = "root";
final String PASSWORD = "root";
try {
Class.forName(Driver);
conn = DriverManager.getConnection(URL, USERNAME, PASSWORD);
String sql = "select * from users where username=? and password=?";
ps = conn.prepareStatement(sql);
ps.setString(1, username);
ps.setString(2, password);
rs = ps.executeQuery();
if (rs.next()) {
session.setAttribute("user", user);
response.sendRedirect("text1.jsp");
} else {
response.sendRedirect("failure.jsp");
}
rs.close();
ps.close();
conn.close();
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}
}
/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse
* response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
// TODO Auto-generated method stub
doGet(request, response);
}
}
UserBean.java
package servlet;
public class UserBean {
private String username;
private String password;
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
}
效果图: