刘阳java_person.java

package com.body;

import java.io.IOException;

import java.io.PrintWriter;

import java.sql.Connection;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import java.text.SimpleDateFormat;

import java.util.Date;

import javax.servlet.RequestDispatcher;

import javax.servlet.ServletException;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import javax.servlet.http.HttpSession;

import com.connect.connect;

public class person extends HttpServlet{

private String UserName; //密码

private String UserSex;

private String Birthdate,year,month,day; //邮箱

private String Zodiac; //手机

private String UserPhone;

private String UserEmail;

private String University;

private String Fication;

private String from;

private String UserNumber;

private String usernumber="";

private connect conn; // conn是自己写的类在Control.conn

private Connection con;

private PrintWriter out; //输出

private String mutex = ""; //为了达到线程同步

private Statement stmt;

private ResultSet rs;

private HttpSession session; // session

private int flag = 0;

public void doPost(HttpServletRequest req, HttpServletResponse resp)

throws ServletException, IOException {

synchronized (mutex){

UserName = new String(req.getParameter("name").getBytes("ISO8859_1"),"UTF-8");

UserSex = req.getParameter("zone");

year = req.getParameter("year");

month = req.getParameter("month");

day = req.getParameter("day");

Zodiac = new String(req.getParameter("zodiac").getBytes("ISO8859_1"),"UTF-8");

UserPhone = req.getParameter("userphone");

UserEmail = req.getParameter("useremail");

UserNumber = req.getParameter("number");

from = req.getParameter("from");

if(req.getParameter("usernumber") != null){

usernumber = req.getParameter("usernumber");

}

University = new String(req.getParameter("university").getBytes("ISO8859_1"),"UTF-8");

Fication = new String(req.getParameter("fication").getBytes("ISO8859_1"),"UTF-8");

session = req.getSession();

Birthdate="";

if(year.equals("")||month.equals("")||day.equals("")){

year="";

month="";

day="";

} else {

Birthdate=new String(year+"-"+month+"-"+day);

}

conn = new connect();

con = conn.con();

out = resp.getWriter();

resp.setHeader("Content-type", "text/html;charset=utf-8");

resp.setCharacterEncoding("utf-8");

try {

stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);

if(from.equals("0")){

stmt.executeUpdate("UPDATE person SET UserName='"+UserName+"',UserSex='"+UserSex+"',Birthdate='"+Birthdate+"',"

+ "Zodiac='"+Zodiac+"',UserPhone='"+UserPhone+"',UserEmail='"+UserEmail+"',University='"+University+"',"

+ "Fication='"+Fication+"' WHERE UserNumber='"+UserNumber+"'");

stmt.executeUpdate("UPDATE message SET UserName='"+UserName+"' WHERE UserNumber='"+UserNumber+"'");

stmt.executeUpdate("UPDATE message SET ToUserName='"+UserName+"' WHERE ToUserNumber='"+UserNumber+"'");

out.print("");

out.print("");

} else if(from.equals("1")){

rs = stmt.executeQuery("SELECT * FROM user WHERE UserNumber = '"+UserNumber+"'");

if(rs.next()){

if(usernumber.equals(UserNumber)){

flag = 1;

} else {

flag = 0;

}

} else {

flag = 1;

}

if(flag == 1){

stmt.executeUpdate("UPDATE person SET UserNumber='"+UserNumber+"',UserName='"+UserName+"',UserSex='"+UserSex+"',Birthdate='"+Birthdate+"',"

+ "Zodiac='"+Zodiac+"',UserPhone='"+UserPhone+"',UserEmail='"+UserEmail+"',University='"+University+"',"

+ "Fication='"+Fication+"' WHERE UserNumber='"+usernumber+"'");

stmt.executeUpdate("UPDATE message SET UserNumber='"+UserNumber+"',UserName='"+UserName+"' WHERE UserNumber='"+usernumber+"'");

stmt.executeUpdate("UPDATE message SET ToUserNumber='"+UserNumber+"',ToUserName='"+UserName+"' WHERE ToUserNumber='"+usernumber+"'");

stmt.executeUpdate("UPDATE user SET UserNumber='"+UserNumber+"' WHERE UserNumber='"+usernumber+"'");

out.print("");

out.print("");

} else if(flag == 0){

out.print("");

}

}

}catch(SQLException e){

out.print("");

}

try { // 关闭连接

con.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

}

@Override

public void doGet(HttpServletRequest req, HttpServletResponse resp)

throws ServletException, IOException {

// TODO Auto-generated method stub

doPost(req, resp);

}

}

一键复制

编辑

Web IDE

原始数据

按行查看

历史