java怎么修改会员信息_JSP 修改会员信息的代码<请帮忙修改>

题目在http://zhidao.baidu.com/question/100003995.html声明：我不是一个学编程的，只是想自学一下，肯定有很多错误，请赐教，不甚感激。积分会在题目页面给，所以也请在题目页面留言...

题目在http://zhidao.baidu.com/question/100003995.html

声明：我不是一个学编程的，只是想自学一下，肯定有很多错误，请赐教，不甚感激。积分会在题目页面给，所以也请在题目页面留言！

public boolean modifyInfo(User user) {

boolean flag = false;

Connection conn;

Statement state;

ResultSet rs;

try {

Class.forName("com.mysql.jdbc.Driver");

conn = DriverManager.getConnection(

"jdbc:mysql://localhost:3306/bookstore", "root", "root");

state = conn.createStatement();

rs = state.executeQuery("update * from user where name='"

+ user.getName() + "'");

if (!rs.next()) {

int i = state

.executeUpdate("insert into user set name='"

+ user.getName() + "',address='"

+ user.getAddress() + "',email='"

+ user.getEmail() + "',realname='"

+ user.getRealname() + "',phoneNumber='"

+ user.getPhone() + "',creditcardNumber='"

+ user.getCreditNumber() + "'");

if (i == 1)

flag = true;

}

conn.close();

} catch (Exception e) {

e.printStackTrace();

}

return flag;

}

package servlets;

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 bo.User;

import db.DBAccess;

public class ModifyInfoServlet extends HttpServlet {

public void doGet(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

String name=request.getParameter("name");

String realname=request.getParameter("realname");

String address=request.getParameter("address");

String email=request.getParameter("email");

String phone=request.getParameter("phone");

String creditNumber=request.getParameter("creditNumber");

User newUser=new User(name,realname,address,email,phone,creditNumber);

boolean flag=new DBAccess().register(newUser);

if(flag){

request.getSession().setAttribute("user", newUser);

request.getRequestDispatcher("/home.jsp").forward(request, response);

}

else{

request.getRequestDispatcher("/ModifyInfo.jsp").forward(request, response);

}

}

public void doPost(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

doPost(request,response);

}

}

展开