网页的注册连接数据库
网页的注册(连接数据库)
实现注册的场景:
1、创建注册页面
2、在接口中定义注册的方法
3、在接口的实现类中,实现注册的方法
4、在注册的接口中,处理注册的业务逻辑
(设置编码格式
获取账号和密码
日期由于格式的问题需要处理,进行日期格式化按照yyyy-MM-dd hh:mm:ss处理
判断是否注册成功
注册成功跳转到登录页面,进行登录
注册失败跳转到注册页面)
package org.cs.servlet;
import java.io.IOException;
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 org.cs.dao.UserInfoDao;
import org.cs.dao.impl.UserInfoDaoImpl;
import org.cs.pojo.UserInfo;
/**
- Servlet implementation class LoginServlet
*/
@WebServlet("/login")
public class LoginServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
- @see HttpServlet#HttpServlet()
*/
public LoginServlet() {
super();
// 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
response.getWriter().append(“Served at: “).append(request.getContextPath());
}
/**
- @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);
request.setCharacterEncoding(“utf-8”);
response.setCharacterEncoding(“utf-8”);
String name=request.getParameter(“userName”);
String pwd=request.getParameter(“pwd”);
UserInfoDao uid=new UserInfoDaoImpl();
UserInfo ui=uid.login(name,pwd);
if(ui!=null){
response.sendRedirect(“index.html”);
}else{
response.sendRedirect(“login.jsp”);
}
}
}
<%@ page language=“java” contentType=“text/html; charset=UTF-8”
pageEncoding=“UTF-8”%>
package org.cs.servlet;
import java.io.IOException;
import java.text.SimpleDateFormat;
import java.util.Date;
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 org.cs.dao.UserInfoDao;
import org.cs.dao.impl.UserInfoDaoImpl;
import org.cs.pojo.UserInfo;
/**
- Servlet implementation class RegisterServlet
*/
@WebServlet("/register”)
public class RegisterServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
- @see HttpServlet#HttpServlet()
*/
public RegisterServlet() {
super();
// 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
response.getWriter().append(“Served at: “).append(request.getContextPath());
}
/**
- @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);
request.setCharacterEncoding(“utf-8”);
response.setCharacterEncoding(“utf-8”);
String username=request.getParameter(“userName”);
String pwd=request.getParameter(“pwd”);
UserInfoDao uid=new UserInfoDaoImpl();
int result=uid.register(new UserInfo(username, pwd,formate(new Date())));
}
/**
日期格式转化
@param date 日期
@return 字符串日期年月日小时分钟秒这样的格式
*/
public static String formate(Date date){
SimpleDateFormat sdf=new SimpleDateFormat(“yyyy-MM-dd hh:mm:ss”);
return sdf.format(date);
}
}