?? op_user.java
字號:
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() +"'";
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{
stmt.executeUpdate(sqlStr);
sqlStr = "select max(id) from shop_user where UserName = '" +
user.getUserName()+ "'";
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;
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 + "用戶名為空!";
}
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;
rscount = (int) recordCount % pageSize; // 最后一頁記錄數
//sql為倒序取值
sqlStr = "select * from shop_user ";
if (page == 1){
sqlStr = sqlStr + " order by Id desc limit 0,"+pageSize;
} else {
sqlStr = sqlStr + " order by Id desc limit "+(recordCount-pageSize*page) +","+(recordCount - pageSize * (page-1));
}
try{
DataBase db = new DataBase();
db.connect();
stmt = db.conn.createStatement ();
rs = stmt.executeQuery(sqlStr);
userlist = new Vector();
while (rs.next()){
user user = new user();
user.setId(rs.getLong("Id"));
user.setUserName(rs.getString("UserName"));
user.setPassWord(rs.getString("PassWord"));
user.setNames(rs.getString("Names"));
user.setSex(rs.getString("Sex"));
user.setAddress(rs.getString("Address"));
user.setPhone(rs.getString("Phone"));
user.setPost(rs.getString("Post"));
user.setEmail(rs.getString("Email"));
user.setRegTime(rs.getString("Regtime"));
user.setRegIpAddress(rs.getString("RegIpAddress"));
userlist.addElement(user);
}
rs.close();
return true;
}catch (SQLException e){
System.out.print(e.getMessage());
return false;
}
}
//修改用戶
public boolean update(HttpServletRequest req) throws Exception {
if (getRequest(req)){
sqlStr = "update shop_user set ";
sqlStr = sqlStr + "UserName = '" + dataFormat.toSql(user.getUserName()) + "',";
sqlStr = sqlStr + "PassWord = '" + dataFormat.toSql(user.getPassWord()) + "',";
sqlStr = sqlStr + "Names = '" + dataFormat.toSql(user.getNames()) + "',";
sqlStr = sqlStr + "Sex = '" + dataFormat.toSql(user.getSex()) + "',";
sqlStr = sqlStr + "Address = '" + dataFormat.toSql(user.getAddress()) + "',";
sqlStr = sqlStr + "Phone = '" + dataFormat.toSql(user.getPhone()) + "',";
sqlStr = sqlStr + "Post = '" + dataFormat.toSql(user.getPost()) + "',";
sqlStr = sqlStr + "Email = '" + dataFormat.toSql(user.getEmail()) + "' ";
sqlStr = sqlStr + " where Id = '" + user.getId() + "'";
try{
DataBase db = new DataBase();
db.connect();
stmt = db.conn.createStatement ();
stmt.execute(sqlStr);
return true;
} catch (SQLException e){
return false;
}
} else {
return false;
}
}
//刪除用戶
public boolean delete( long aid ) throws Exception {
sqlStr = "delete from shop_user where Id = " + aid ;
try{
DataBase db = new DataBase();
db.connect();
stmt = db.conn.createStatement ();
stmt.execute(sqlStr);
return true;
}catch (SQLException e){
System.out.println(e);
return false;
}
}
//查詢指定id的用戶，用于支持頁面的查看詳細資料請求
public boolean getUserinfo(long newid ) throws Exception {
try{
sqlStr="select * from shop_user where Id = " + newid ;
DataBase db = new DataBase();
db.connect();
stmt = db.conn.createStatement ();
rs = stmt.executeQuery(sqlStr);
userlist = new Vector();
while (rs.next()){
user.setId(rs.getLong("Id"));
System.out.print(rs.getLong("Id"));
user.setUserName(rs.getString("UserName"));
user.setPassWord(rs.getString("PassWord"));
user.setNames(rs.getString("Names"));
user.setSex(rs.getString("Sex"));
user.setAddress(rs.getString("Address"));
user.setPhone(rs.getString("Phone"));
user.setPost(rs.getString("Post"));
user.setEmail(rs.getString("Email"));
user.setRegTime(rs.getString("Regtime"));
user.setRegIpAddress(rs.getString("RegIpAddress"));
userlist.addElement(user);
}
rs.close();
return true;
}catch (Exception e){
System.out.print(e.getMessage());
return false;
}
}
public String getGbk( String str) {
try {
return new String(str.getBytes("ISO8859-1"));
}catch (Exception e){
return str;
}
}
public int getPage() { //顯示的頁碼
return page;
}
public void setPage(int newpage) {
page = newpage;
}
public int getPageSize(){ //每頁顯示的圖書數
return pageSize;
}
public void setPageSize(int newpsize) {
pageSize = newpsize;
}
public int getPageCount() { //頁面總數
return pageCount;
}
public void setPageCount(int newpcount) {
pageCount = newpcount;
}
public long getRecordCount() {
return recordCount;
}
public void setRecordCount(long newrcount) {
recordCount= newrcount;
}
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;
}
public Vector getUserlist() {
return userlist;
}
};
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -