【Java开源代码栏目提醒】:文章导读:在新的一年中,各位网友都进入紧张的学习或是工作阶段。网学会员整理了Java开源代码-bbsuser.java的相关内容供大家参考,祝大家在新的一年里工作和学习顺利!
/**
* 锟斤拷锟斤拷锟斤拷锟揭拷嵌锟斤拷没锟斤拷锟揭恍╋拷锟较拷牟锟斤拷锟?
*
*/
package twm;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Date;
public class bbsuser
{
bbsreg dbconn;//锟斤拷锟斤拷
bbsreg锟斤拷锟斤拷唷?
ResultSet rs;
String strSQL;
int i;
boolean isUser;
/**
* 锟斤拷锟矫猴拷锟斤拷荼锟絬ser锟斤拷锟接︼拷锟斤拷侄伪锟?锟斤拷
*/
int userid;
int userclass;
String username;
String userpassword;
String useremail;
String userhomepage;
String hpname;
String usersex;
String comefrom;
String usersign;
Date userbirthday;
Date dateandtime;
public bbsuser()
{
dbconn = new bbsreg();//锟斤拷锟斤拷锟斤拷bbsreg锟斤拷锟斤拷锟斤拷
rs = null;
userid = 0;
username = null;
userpassword = null;
useremail = null;
userhomepage = null;
hpname = null;
usersex = null;
comefrom = null;
usersign = null;
userclass = 0;
userbirthday = new Date();
dateandtime = new Date();
}
public void changeUserClass(String s, int j)
{
strSQL = "update user set userclass=userclass+" + j + " where username='" + s + "'";
dbconn.executeUpdate(strSQL);
}
public void checkUser(String s, String s1){
}
public void changeUserPassword(String s, String s1)
{
strSQL = "update user set userpassword='" + s1 + "' where username='" + s + "'";
dbconn.executeUpdate(strSQL);
}
public boolean checkUserPassword(String s, String s1)
{
rs = null;
strSQL = "select * from user where username='" + s + "' and userpassword='" + s1 + "'";
try
{
rs = dbconn.executeQuery(strSQL);
if(rs.next())
{
isUser = true;
getUserInfo(s);
} else
{
isUser = false;
}
rs.close();
}
catch(SQLException sqlexception)
{
System.err.println("aq.executeQuery: " + sqlexception.getMessage());
System.err.println("checkuserpassword.STRSQL:: " + strSQL);
}
return isUser;
}
public int countUser()
{
strSQL = "SELECT COUNT(*) AS aa FROM user";
i = 0;
try
{
rs = dbconn.executeQuery(strSQL);
if(rs.next())
i = rs.getInt("aa");
rs.close();
}
catch(SQLException
sqlexception)
{
System.err.println("aq.executeQuery: " + sqlexception.getMessage());
System.err.println("countUser.STRSQL:: " + strSQL);
}
return i;
}
public void delUser(String s)
{
strSQL = "delete from user where username='" + s + "'";
dbconn.executeUpdate(strSQL);
}
public Date getUserBirthday()
{
return userbirthday;
}
public void registryNewUser()//录锟斤拷一锟斤拷锟斤拷锟矫伙拷锟斤拷
{
strSQL = "INSERT INTO USER(username,userpass
word,useremail,userhomepage,hpname,usersex,comefrom,userclass,usersign) values('" + username + "','" + userpassword + "','" + useremail + "','" + userhomepage + "','" + hpname + "','" + usersex + "','" + comefrom + "','" + userclass + "','" + usersign + "')";
dbconn.executeUpdate(strSQL);
}
public ResultSet listUser(int j)
{
rs = null;
switch(j)
{
case 1: // '\001'
strSQL = "select * from user order by userid desc";
break;
case 2: // '\002'
strSQL = "select * from user order by username desc";
break;
case 3: // '\003'
strSQL = "select * from user order by userclass desc";
break;
default:
strSQL = "select * from user order by userid desc";
break;
}
rs = dbconn.executeQuery(strSQL);
return rs;
}
public void updateUserInfo(String s)
{
strSQL = "update user set useremail='" + useremail + "',userhomepage='" + userhomepage + "',hpname='" + hpname + "',usersex='" + usersex + "',comefrom='" + comefrom + "',usersign='" + usersign + "' where username='" + s + "'";
dbconn.executeUpdate(strSQL);
}
//锟斤拷user锟斤拷锟斤拷锟絞eter,seter锟斤拷锟斤拷锟斤拷锟皆便传锟斤拷值锟斤拷锟斤拷
public int getUserClass()
{
return userclass;
}
public String getUserComefrom()
{
return comefrom;
}
public Date getUserDateandtime()
{
return dateandtime;
}
public String getUserEmail()
{
return useremail;
}
public String getUserHomepage()
{
return userhomepage;
}
public String getUserHomepagename()
{
return hpname;
}
public int getUserId()
{
return userid;
}
public boolean getUserInfo(String s)
{
rs = null;
strSQL = "select * from user where username='" + s + "'";
try
{
rs = dbconn.executeQuery(strSQL);
if(rs.next())
{
isUser = true;
userid = rs.getInt("userid");
username = rs.getString("username");
userpassword = rs.getString("userpassword");
useremail = rs.getString("useremail");
userhomepage = rs.getString("userhomepage");
hpname = rs.getString("hpname");
userbirthday = rs.getDate("userbirt