目录

网页的注册连接数据库

目录

网页的注册(连接数据库)

https://i-blog.csdnimg.cn/blog_migrate/a052364c7a601f8baf4320834f058c8d.png

https://i-blog.csdnimg.cn/blog_migrate/af9e58cea2f2c1bc144f7df0e3834a00.png

https://i-blog.csdnimg.cn/blog_migrate/b072b995f25a26f431e7b39afb54fdae.png

实现注册的场景:

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”%>

Insert title here

用户名

密码

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);

}

}