1.登录页面
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<font color="red"><%=request.getAttribute("message")==null? "":request.getAttribute("message") %></font>
<form action="LoginServlet" method="post">
UserName:<input type="text" name="username" /><br><br>
Password:<input type="password" name="password" />
<input type="submit" value="登录" />
<a href="register.jsp">注册</a>
</form>
</body>
</html>
2.注册页面
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<font color="red"><%=request.getAttribute("message")==null? "":request.getAttribute("message") %></font>
<form action="LoginServlet" method="post">
UserName:<input type="text" name="username" /><br><br>
Password:<input type="password" name="password" />
<input type="submit" value="登录" />
<a href="register.jsp">注册</a>
</form>
</body>
</html>
3.成功登录页面
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<center>
<h4>Success Page</h4>
</center>
</body>
</html>
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" id="WebApp_ID" version="3.0">
<display-name>MyServlet2</display-name>
<!-- SERVLET 注册映射 -->
<servlet>
<servlet-name>MyServlet</servlet-name>
<servlet-class>cn.edu.hpu.servlet.MyServletClass</servlet-class>
</servlet>
<servlet>
<description>This is the description of my J2EE component</description>
<display-name>This is the display name of my J2EE component</display-name>
<servlet-name>NewServlet</servlet-name>
<servlet-class>cn.edu.hpu.servlet.NewServlet</servlet-class>
</servlet>
<servlet>
<description>This is the description of my J2EE component</description>
<display-name>This is the display name of my J2EE component</display-name>
<servlet-name>RegisterServlet</servlet-name>
<servlet-class>cn.edu.hpu.servlet.RegisterServlet</servlet-class>
</servlet>
<servlet>
<description>This is the description of my J2EE component</description>
<display-name>This is the display name of my J2EE component</display-name>
<servlet-name>LoginServlet</servlet-name>
<servlet-class>cn.edu.hpu.servlet.LoginServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>MyServlet</servlet-name>
<url-pattern>/MyServlet</url-pattern>
</servlet-mapping>
<servlet-mapping>
<servlet-name>NewServlet</servlet-name>
<url-pattern>/NewServlet</url-pattern>
</servlet-mapping>
<servlet-mapping>
<servlet-name>RegisterServlet</servlet-name>
<url-pattern>/RegisterServlet</url-pattern>
</servlet-mapping>
<servlet-mapping>
<servlet-name>LoginServlet</servlet-name>
<url-pattern>/LoginServlet</url-pattern>
</servlet-mapping>
<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>
</web-app>
index
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>My JSP 'index.jsp' starting page</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</head>
<body>
<a href="login.jsp">Login Page</a>
</body>
</html>
5.LoginServlet.java用户登录
package cn.edu.hpu.servlet;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.an.manager.dao.DAO;
import com.an.manager.dao.UserDAOImpl;
public class LoginServlet extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doPost(request, response);
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String username = request.getParameter("username");
String password = request.getParameter("password");
boolean flag = false;
DAO dao = new UserDAOImpl();
flag = dao.queryUser(username, password);
if(flag==true){
System.out.println("Login Success");
request.getRequestDispatcher("success.jsp").forward(request, response);
//response.sendRedirect("success.jsp");
}else{
System.out.println("用户名或者密码错误");
request.setAttribute("message", "用户名或者密码错误");
request.getRequestDispatcher("login.jsp").forward(request, response);
//response.sendRedirect("login.jsp");
}
}
}
6.MySerletClass.java
package cn.edu.hpu.servlet;
import java.io.IOException;
import javax.servlet.Servlet;
import javax.servlet.ServletConfig;
import javax.servlet.ServletException;
import javax.servlet.ServletRequest;
import javax.servlet.ServletResponse;
public class MyServletClass implements Servlet {
@Override
public void destroy() {
// TODO Auto-generated method stub
System.out.println("destory...");
}
@Override
public ServletConfig getServletConfig() {
// TODO Auto-generated method stub
System.out.println("getServletConfig...");
return null;
}
@Override
public String getServletInfo() {
System.out.println("getServletInfo...");
return null;
}
@Override
public void init(ServletConfig config) throws ServletException {
// TODO Auto-generated method stub
System.out.println("init...");
}
@Override
public void service(ServletRequest req, ServletResponse res)
throws ServletException, IOException {
System.out.println("service...");
}
}
7.NewServlet.java
package cn.edu.hpu.servlet;
import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class NewServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doPost(request, response);
}
/**
* 1.表单,username password
* 2.获取请求参数
* 3.zhangsan,123456
* 4.失败JSP 成功JSP
*/
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.setCharacterEncoding("UTF-8");
String username = request.getParameter("username");
String password = request.getParameter("password");
//逻辑代码
if (username.equals("zhangsan") && password.equals("123456")){
request.setAttribute("message", "登陆成功!");
// response.sendRedirect("success.jsp");
// request.getRequestDispatcher("success.jsp").forward(request, response);
//请求转发
}else {
request.setAttribute("message", "登陆失败!");
// response.sendRedirect("error.jsp");//重定向
// request.getRequestDispatcher("error.jsp").forward(request, response);
}
request.getRequestDispatcher("main.jsp").forward(request, response);
}
}
8.RegisterServlet.java
package cn.edu.hpu.servlet;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.an.manager.dao.DAO;
import com.an.manager.dao.UserDAOImpl;
public class RegisterServlet extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doPost(request, response);
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
//得到账号密码的信息
String user = request.getParameter("username");
String password = request.getParameter("password");
boolean flag = false;
DAO dao = new UserDAOImpl();
int count = dao.getCountWithUsername(user);
if(count>0){
request.setAttribute("message", "用户名已经存在");
request.getRequestDispatcher("register.jsp").forward(request, response);
return;
}
System.out.println("username:"+user+",password:"+password);
DAO userDAOImpl = new UserDAOImpl();
System.out.println("DAO:"+userDAOImpl);
flag = userDAOImpl.addUser(user, password);
System.out.println("flag:"+flag);
if(flag==true){
System.out.println("Register Success");
//request.getRequestDispatcher("login.jsp").forward(request, response);
response.sendRedirect("login.jsp");
}
}
}
9.Text.java
package cn.edu.hpu.servlet;
import com.an.manager.dao.DAO;
import com.an.manager.dao.UserDAOImpl;
public class Test {
public static void main(String[] args) {
DAO dao = new UserDAOImpl();
int result = dao.getCountWithUsername("12");
System.out.println(result);
}
}
10.DAO.java
package com.an.manager.dao;
public interface DAO {
public boolean addUser(String username,String password);
public boolean queryUser(String username,String password);
public int getCountWithUsername(String username);
}
11.UserDAOImpl.java
package com.an.manager.dao;
import java.sql.Connection;
import java.sql.SQLException;
import com.an.manager.db.DBOperator;
import com.mysql.jdbc.PreparedStatement;
import com.mysql.jdbc.ResultSet;
import com.mysql.jdbc.Statement;
public class UserDAOImpl implements DAO{
private Connection conn = null;
private boolean flag = false;
@Override
public boolean addUser(String username, String password) {
// TODO Auto-generated method stub
DBOperator db = new DBOperator();
conn = db.getConn();
String sql = "insert into user(username,password) value(?,?)";
try {
PreparedStatement ps = (PreparedStatement) conn.prepareStatement(sql);
ps.setString(1, username);
ps.setString(2, password);
int rows = ps.executeUpdate();
if(rows>0){
flag = true;
}
} catch (SQLException e) {
e.printStackTrace();
}
return flag;
}
@Override
public boolean queryUser(String username, String password) {
// TODO Auto-generated method stub
String sql = "select * from user WHERE username=? and password=?";
Connection conn = null;
DBOperator db = new DBOperator();
conn = db.getConn();
try {
PreparedStatement ps = (PreparedStatement) conn.prepareStatement(sql);
ps.setString(1, username);
ps.setString(2, password);
ResultSet rs = (ResultSet) ps.executeQuery();
if(rs.next()){
flag = true;
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return flag;
}
//返回在数据库中查找到的条数
@Override
public int getCountWithUsername(String username) {
// TODO Auto-generated method stub
String sql = "select count(id) from user WHERE username="+username;
Connection conn = null;
DBOperator db = new DBOperator();
conn = db.getConn();
int rows = 0;
try {
Statement st = (Statement) conn.createStatement();
ResultSet rs = (ResultSet) st.executeQuery(sql);
if(rs.next()){
rows = rs.getInt(1);
}
System.out.println("rows:"+rows);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return rows;
}
}
12.数据库连接
package com.an.manager.db;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class DBOperator {
private String username="root";
private String password="1234";
private String url="jdbc:mysql://localhost:3306/yc1";
private Connection conn = null;
public Connection getConn(){
try {
Class.forName("org.gjt.mm.mysql.Driver");
conn = DriverManager.getConnection(url, username, password);
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return conn;
}
}
13.
package com.an.manager.db;
import java.sql.Connection;
public class DBTest {
public static void main(String[] args) {
DBOperator db = new DBOperator();
Connection conn = db.getConn();
if(conn!=null){
System.out.println("Success");
}else{
System.out.println("Failure");
}
}
}