package check;import java.sql.*;import java.util.Vector;import check.dbconn;import check.strformat;import javax.servlet.http.HttpServletRequest;import check.shopuser;import java.util.*;public class usermn extends database {    private shopuser user = new shopuser();	//創(chuàng)建新的用戶對象    private javax.servlet.http.HttpServletRequest request; //建立頁面請求    private String message = "";			//聲明出錯信息提示    private String username = "";			//聲明注冊后返回的用戶名    private long userid = 0;				//注冊后返回的用戶ID    public usermn() throws Exception{        super();    }    public String getGbk( String str) {        try {            return new String(str.getBytes("ISO8859-1"));        } catch (Exception e) {            return str;        }    }    //將頁面表單傳來的資料分解           public boolean getRequest(javax.servlet.http.HttpServletRequest newrequest) {        boolean flag = false;        try {            request = newrequest;            String ID = request.getParameter("userid");//獲取userid參數(shù)            if (ID!=null ) {                userid = 0;                try {                    userid = Long.parseLong(ID);                    user.setId(userid);                } catch (Exception e) {                    message = message + "你要修改的用戶號出錯！";                }            }            username = request.getParameter("username");//獲取username參數(shù)            if (username==null || username.equals("")) {                username = "";                message = message + "用戶名為空!";            }            user.setUserName(getGbk(username));            String password = request.getParameter("passwd");//獲取passwd參數(shù)            if (password==null || password.equals("")) {                password = "";                message = message + "密碼為空!";            }            String pwdconfirm = request.getParameter("passconfirm");//獲取passconfirm參數(shù)            if (!password.equals(pwdconfirm)) {                message = message + "確認(rèn)密碼不相同!";            }            user.setPassWord(getGbk(password));            String names = request.getParameter("names");;//獲取names參數(shù)            if (names==null) {                names = "";            }            user.setNames(getGbk(names));//轉(zhuǎn)化格式            String sex = request.getParameter("sex");            user.setSex(getGbk(sex));            String address = request.getParameter("address");//獲取address參數(shù)            if (address == null) {                address = "";            }            user.setAddress(getGbk(address));            String post = request.getParameter("post");//獲取post參數(shù)            if (post == null) {                post = "";            }            user.setPost(getGbk(post));            String phone = request.getParameter("phone");//獲取phone參數(shù)            if (phone== null) {                phone = "";            }            user.setPhone(phone);            String email = request.getParameter("email");//獲取email參數(shù)            if (email == null) {                email = "";            }            user.setEmail(getGbk(email));//轉(zhuǎn)化格式            String IP = request.getRemoteAddr();//利用getRemoteAddr()函數(shù)取得用戶IP            user.setRegIpAddress(IP);            if (message.equals("")) {                flag = true;            }            return flag;        } catch (Exception e) {            return flag;        }    }    public boolean insert(HttpServletRequest req) throws Exception {        if (getRequest(req)) {            sqlStr = "select * from My_Users where username = '" + user.getUserName() +"'";//取出符合username字段要求的記錄            rs = stmt.executeQuery(sqlStr);//執(zhí)行SQL語句            if (rs.next()) {                message = message + "該用戶名已存在!";                rs.close();                return false;            }            sqlStr = "insert into My_Users (username,password,Names,sex,Address,Phone,Post,Email,RegTime,RegIpaddress) values ('";            sqlStr = sqlStr + strformat.toSql(user.getUserName()) + "','";            sqlStr = sqlStr + strformat.toSql(user.getPassWord()) + "','";            sqlStr = sqlStr + strformat.toSql(user.getNames()) + "','";            sqlStr = sqlStr + strformat.toSql(user.getSex()) + "','";            sqlStr = sqlStr + strformat.toSql(user.getAddress()) + "','";            sqlStr = sqlStr + strformat.toSql(user.getPhone()) + "','";            sqlStr = sqlStr + strformat.toSql(user.getPost()) + "','";            sqlStr = sqlStr + strformat.toSql(user.getEmail()) + "',getdate(),'";//使用getdate()函數(shù)獲取系統(tǒng)當(dāng)前時間            sqlStr = sqlStr + user.getRegIpAddress() + "')";            try {                stmt.execute(sqlStr);                sqlStr = "select max(id) from My_Users where username = '" +user.getUserName()+ "'";                rs = stmt.executeQuery(sqlStr);                while (rs.next()) {                    userid = rs.getLong(1);                }                rs.close();                return true;            } catch (SQLException sqle) {                System.out.println(sqle.toString());                return false;            }        } else	{            return false;        }    }    public String getMessage() {        return message;    }    public void setMessage(String msg) {        message = msg;    }    public void setUserid(long uid) {        userid = uid;    }    public long getUserid() {        return userid;    }    public void setUserName(String uName) {        username = uName;    }    public String getUserName() {        return username;    }};