package bookshop.run;/** * <p>Title: </p> * <p>Description: </p> * <p>Copyright: Copyright (c) 2004</p> * <p>Company: </p> * @author not attributable * @version 1.0 */import java.sql.*;import java.util.Vector;import javax.servlet.http.HttpServletRequest;import bookshop.util.*;import bookshop.book.*;public class op_user extends DataBase{        private user user = new user();	                        //新的用戶對象        private javax.servlet.http.HttpServletRequest request;  //建立頁面請求        private Vector userlist;				//顯示用戶列表向量數組        private int page = 1;					//顯示的頁碼        private int pageSize=8;					//每頁顯示的圖書數        private int pageCount =0;				//頁面總數        private long recordCount =0;			        //查詢的記錄總數        private String message = "";			        //出錯信息提示        private String username = "";			        //注冊后返回的用戶名        private long userid = 0;				//注冊后返回的用戶ID  public op_user() {  }  public boolean add(HttpServletRequest req) throws Exception {                  if (getRequest(req)) {                    DataBase db = new DataBase();                    db.connect();                    stmt = db.conn.createStatement ();                          sqlStr = "select * from shop_user where username = '" + user.getUserName() +"'";                          System.out.print("2222222222222");                           System.out.print(sqlStr);                          //rs = stmt.executeQuery(sqlStr);                          System.out.print("333333333333");                          /*if (rs.next())                          {                                  message = message + "該用戶名已存在!";                                  rs.close();                                  return false;                          }*/                          sqlStr = "insert into shop_user (username,password,Names,sex,Address,Phone,Post,Email,RegTime,RegIpaddress) values ('";                          sqlStr = sqlStr + dataFormat.toSql(user.getUserName()) + "','";                          sqlStr = sqlStr + dataFormat.toSql(user.getPassWord()) + "','";                          sqlStr = sqlStr + dataFormat.toSql(user.getNames()) + "','";                          sqlStr = sqlStr + dataFormat.toSql(user.getSex()) + "','";                          sqlStr = sqlStr + dataFormat.toSql(user.getAddress()) + "','";                          sqlStr = sqlStr + dataFormat.toSql(user.getPhone()) + "','";                          sqlStr = sqlStr + dataFormat.toSql(user.getPost()) + "','";                          sqlStr = sqlStr + dataFormat.toSql(user.getEmail()) + "',now(),'";                          sqlStr = sqlStr + user.getRegIpAddress() + "')";                          try                          {       System.out.print(sqlStr);                                  stmt.executeUpdate(sqlStr);                                  sqlStr = "select max(id) from shop_user where username = '" +user.getUserName()+ "'";                                  System.out.print(sqlStr);                                  rs = stmt.executeQuery(sqlStr);                                  while (rs.next())                                  {                                          userid = rs.getLong(1);                                  }                                  rs.close();                                  return true;                          }                          catch (Exception sqle)                          {System.out.print(sqle.getMessage());                                  return false;                          }                  } else	{                          return false;                  }          }          public boolean getRequest(javax.servlet.http.HttpServletRequest newrequest) {                          boolean flag = false;                          System.out.print("11111111");                          try                          {                                  request = newrequest;                                  String ID = request.getParameter("userid");                                  if (ID!=null )                                  {                                          userid = 0;                                          try                                          {                                                  userid = Long.parseLong(ID);                                                  user.setId(userid);                                          }                                          catch (Exception e)                                          {                                                  message = message + "你要修改的用戶號出錯！";                                          }                                  }                                  username = request.getParameter("username");                                  if (username==null || username.equals(""))                                  {                                          username = "";                                          message = message + "用戶名為空!";                                  }                                  System.out.print(username);                                  user.setUserName(getGbk(username));                                  String password = request.getParameter("passwd");                                  if (password==null || password.equals(""))                                  {                                          password = "";                                          message = message + "密碼為空!";                                  }                                  String pwdconfirm = request.getParameter("passconfirm");                                  if (!password.equals(pwdconfirm))                                  {                                          message = message + "確認密碼不相同!";                                  }                                  user.setPassWord(getGbk(password));                                  String names = request.getParameter("names");;                                  if (names==null)                                  {                                          names = "";                                  }                                  user.setNames(getGbk(names));                                  String sex = request.getParameter("sex");                                  user.setSex(getGbk(sex));                                  String address = request.getParameter("address");                                  if (address == null)                                  {                                          address = "";                                  }                                  user.setAddress(getGbk(address));                                  String post = request.getParameter("post");                                  if (post == null)                                  {                                          post = "";                                  }                                  user.setPost(getGbk(post));                                  String phone = request.getParameter("phone");                                  if (phone== null)                                  {                                          phone = "";                                  }                                  user.setPhone(phone);                                  String email = request.getParameter("email");                                  if (email == null)                                  {                                          email = "";                                  }                                  user.setEmail(getGbk(email));                                  String IP = request.getRemoteAddr();                                  user.setRegIpAddress(IP);                                  if (message.equals(""))                                  {                                          flag = true;                                  }                                  return flag;                          }                          catch (Exception e)                          {                                  return flag;                          }                  }              public boolean get_alluser() throws Exception {                   sqlStr = "select count(*) from shop_user";    //取出記錄數                                int rscount = pageSize;                                try                                {DataBase db = new DataBase();                                db.connect();                                stmt = db.conn.createStatement ();                                        ResultSet rs1 = stmt.executeQuery(sqlStr);                                        if (rs1.next()) recordCount = rs1.getInt(1);                                        rs1.close();                                }                                catch (SQLException e)                                {        System.out.print("count:"+e.getMessage());                                        return false;                                }                                //設定有多少pageCount                                if (recordCount < 1)                            pageCount = 0;                        else                            pageCount = (int)(recordCount - 1) / pageSize + 1;                                //檢查查看的頁面數是否在范圍內                                if (page < 1)                            page = 1;                        else if (page > pageCount)                            page = pageCount;