【Java开源代码栏目提醒】:网学会员,鉴于大家对Java开源代码十分关注,论文会员在此为大家搜集整理了“usermn.java”一文,供大家参考学习!
package org.pan.web;
import java.sql.*;
import java.util.Vector;
import org.pan.util.*;
import javax.servlet.http.HttpServletRequest;
import org.pan.
web.book.shopuser;
import org.pan.web.book.books;
/**
* Title: 网站用户类列表
* Description:
* Copyright: Copyright (c) 2003
* Company: 多智能
网络有限公司
* @author: siny pan
* @version 1.0
*/
public class usermn extends DataBase {
private shopuser user = new shopuser(); //新的用户对象
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 usermn() throws Exception{
super();
}
public Vector getUserlist() {
return userlist;
}
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");
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(pass
word));
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 String getSql() {
sqlStr = "select * from my_users order by id";
return sqlStr;
}
public boolean execute() throws Exception {
sqlStr = "select count(*) from my_users"; //取出记录数
int rscount = pageSize;
try
{
ResultSet rs1 = stmt.executeQuery(sqlStr);
if (rs1.next()) recordCount = rs1.getInt(1);
rs1.close();
}
catch (SQLException e)
{
close();
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 Top " + pageSize + " * from My_users ";
if (page =