servlet----注册页面----一个有冗余代码的注册页面

最新推荐文章于 2023-09-07 00:23:20 发布

Jack_Skipper

最新推荐文章于 2023-09-07 00:23:20 发布

阅读量952

点赞数

分类专栏： Servlet 代码片段文章标签： email exception string import 数据库 insert

本文链接：https://blog.csdn.net/flfna/article/details/5579791

版权

Servlet 同时被 2 个专栏收录

6 篇文章 0 订阅

订阅专栏

代码片段

5 篇文章 0 订阅

订阅专栏

package com.adverties.servlet;

import java.io.*;

import javax.servlet.*;
import javax.servlet.http.*;

import com.adverties.bean.Login;
import com.adverties.bean.Register;
import com.mysql.jdbc.PreparedStatement;

import java.sql.*;

public class HandleRegister extends HttpServlet {
Register register = new Register();

public void init(ServletConfig config) throws ServletException {
  super.init(config);
  try {
   Class.forName("com.mysql.jdbc.Driver");
  } catch (Exception e) {
   System.out.println("数据库未连接！" + e);
  }
}

public String registerInfo(String s) {
  try {
   byte[] bb = s.getBytes("gbk");
   s = new String(bb);
  } catch (Exception ee) {
   ee.printStackTrace();
  }
  return s;
}

public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doPost(request, response);
}

public void doPost(HttpServletRequest request, HttpServletResponse response)
   throws ServletException, IOException {
  request.setCharacterEncoding("gbk");
  response.setCharacterEncoding("gbk");
  response.setContentType("text/html;charset=gbk");

  HttpSession session = request.getSession(true);

  //----------------
          request.setAttribute("register",register);
  String url = "jdbc:mysql://localhost:3306/adv";
  // -----------
  register = (Register) session.getAttribute("logname");
  register = (Register) session.getAttribute("password");
  register = (Register) session.getAttribute("advertiseTitle");
  register = (Register) session.getAttribute("email");
  register = (Register) session.getAttribute("phone");
  register = (Register) session.getAttribute("message");

  try {
   register =(Register) session.getAttribute("logname");
   register =(Register) session.getAttribute("password");

   if(register==null){
    register = new Register();
    session.setAttribute("register", register);


   }
  }catch(Exception ee){
   register = new Register();
   session.setAttribute("register", register);
  }

  String logname = request.getParameter("logname").trim(), password = request
    .getParameter("password").trim(), advertiseTitle = request
    .getParameter("advertiseTitle").trim(), email = request
    .getParameter("email").trim(), phone = request
    .getParameter("phone").trim(), message = request
    .getParameter("message").trim();
  //backNews=request.getParameter("backNews").trim()

//  logname = registerInfo(logname);
//  password = registerInfo(password);
//  password = registerInfo(advertiseTitle);
//  password = registerInfo(phone);
//  password = registerInfo(email);
//  password = registerInfo(message);

   // -------------------------
   Connection conn = null;
   PreparedStatement pstmt = null;
   String backNews = "";

boolean isLD = true;

    for (int i = 0; i < logname.length(); i++) {
     char c = logname.charAt(i);
     if (!((c <= 'z' && c >= 'a') || (c <= 'Z' && c >= 'A') || (c <= '9' && c >= '0')))
      isLD = false;
    }
    boolean boo = logname.length() > 0 && password.length() > 0
      && isLD;

    try {
     conn = DriverManager.getConnection(url, "root", "root");
     String sql = "insert into member value(?,?,?,?,?,?,?)";
     pstmt = (PreparedStatement) conn.prepareStatement(sql);
     if (boo) {
      pstmt.setString(1, registerInfo(logname));
      pstmt.setString(2, registerInfo(password));
      pstmt.setString(3, registerInfo(advertiseTitle));
      pstmt.setString(4, registerInfo(phone));
      pstmt.setString(5, registerInfo(email));
      pstmt.setString(6, registerInfo(message));
      pstmt.setString(7, "public.jpg");
      int m = pstmt.executeUpdate();

      if (m != 0) {
       backNews = "注册成功，信息已经插入数据库,数据如下";
       register.setBackNews(backNews);

//       register.setLogname(logname);
//       register.setPassword(password);
//       register.setEmail(email);

//        logname=request.getParameter("logname").trim();
//        advertiseTitle=request.getParameter("advertiseTitle").trim();
//        phone=request.getParameter("phone").trim();
//            message=request.getParameter("message").trim();
//           email=request.getParameter("email").trim();



//       register.setLogname(registerInfo(logname));
//       register.setPassword(registerInfo(password));
//       register
//         .setAdvertiseTitle(registerInfo(advertiseTitle));
//       register.setPhone(registerInfo(phone));
//       register.setMessage(registerInfo(message));
//       register.setEmail(registerInfo(email));

       // register = (Register)
       // request.getAttribute(logname);
       // register = (Register)
       // request.getAttribute(password);
       // register = (Register) request
       // .getAttribute(advertiseTitle);
       // register = (Register)
       // request.getAttribute(email);
       // register = (Register)
       // request.getAttribute(phone);
       // register = (Register)
       // request.getAttribute(message);
      }
      } else {
       backNews = "信息填写不完整或名字中有非法字符";
       register.setBackNews(backNews);
      }
      pstmt.close();
      conn.close();

    } catch (SQLException exp) {
     backNews = "该会员已被使用，请您更换名字" + exp;
     register.setBackNews(backNews);
    }
    RequestDispatcher dispatcher = request
      .getRequestDispatcher("showRegisterMess.jsp");
    dispatcher.forward(request, response);

  }
}