package StudyBbs;
import java.util.*;
import java.sql.Connection;
import java.sql.ResultSet;
public class User {
private String username = null;
private String password = null;
private String nickname = null;
private String sex = null;
private String birthyear = null;
private String birthmonth = null;
private String birthday = null;
private String email = null;
private String mobile = null;
private String signiture = null;
private String grade = null;
private int score = 0;
public User(){}
public void setUsername(String username) {
this.username = username;
}
public String getUsername() {
return username;
}
public void setPassword(String password) {
this.password = password;
}
public String getPassword() {
return password;
}
public void setNickname(String nickname) {
this.nickname = nickname;
}
public String getNickname() {
return nickname;
}
public void setSex(String sex) {
this.sex = sex;
}
public String getSex() {
return sex;
}
public void setBirthyear(String birthyear) {
this.birthyear = birthyear;
}
public String getBirthyear() {
return birthyear;
}
public void setBirthmonth(String birthmonth) {
this.birthmonth = birthmonth;
}
public String getBirthmonth() {
return birthmonth;
}
public void setBirthday(String birthday) {
this.birthday = birthday;
}
public String getBirthday() {
return birthday;
}
public void setEmail(String email) {
this.email = email;
}
public String getEmail() {
return email;
}
public void setMobile(String mobile) {
this.mobile = mobile;
}
public String getMobile() {
return mobile;
}
public void setSigniture(String signiture) {
this.signiture = signiture;
}
public String getSigniture() {
return signiture;
}
public void setGrade(String grade) {
this.grade = grade;
}
public String getGrade() {
return grade;
}
public void setScore(int score) {
this.score = score;
}
public int getScore() {
return score;
}
public static boolean checkUser(DB db,String name,String psw) throws Exception{
String strSql;
ResultSet rs;
strSql = "select * from bbsuser where username='"
+ name + "' and password='" + psw + "'";
rs = db.OpenSql(strSql);
if ( rs.next()) {
return true;
}
else{
return false;
}
}
public boolean Insert(DB db) throws Exception{
String strSql;
strSql = "insert into bbsuser values('"
+ username +"','"
+ password +"','"
+ nickname +"','"
+ sex +"','"
+ birthyear +"','"
+ birthmonth+"','"
+ birthday +"','"
+ email +"','"
+ mobile +"','"
+ signiture +"','普通用户',10)";
if ( db.ExecSql(strSql)==0) {
return false;
}
else{
return true;
}
}
public static String getUserGrade(DB db,String name) throws Exception{
String strSql;
ResultSet rs;
strSql = "select * from bbsuser where username='"
+ name + "'";
rs = db.OpenSql(strSql);
if ( rs.next()) {
return rs.getString("usergrade");
}
else{
return null;
}
}
public static Vector Search(DB db ,String username) throws Exception{
Vector Users = new Vector();
ResultSet rs,rsNest;
String strSql=null;
strSql = "select * from bbsuser where username like '%" + username + "%'";
rs = db.OpenSql(strSql);
while (rs.next()){
User user = new User();
user.setUsername(rs.getString("username")) ;
user.setGrade(rs.getString("usergrade")) ;
Users.add(user);
}
return Users;
}
public static Vector SearchMaster(DB db) throws Exception{
Vector Users = new Vector();
ResultSet rs,rsNest;
String strSql=null;
strSql = "select * from bbsuser where usergrade = '斑竹'";
rs = db.OpenSql(strSql);
while (rs.next()){
User user = new User();
user.setUsername(rs.getString("username")) ;
user.setGrade(rs.getString("usergrade")) ;
Users.add(user);
}
return Users;
}
public static boolean Delete(DB db,String username) throws Exception{
String strSql;
strSql = "delete from bbsuser where username='"+username+"'";
if ( db.ExecSql(strSql)==0) {
return false;
}
else{
return true;
}
}
public static boolean Edit(DB db,String username,String grade,String sort) throws Exception{
String strSql;
strSql = "update bbsuser set usergrade='"+grade+"' where username='"+username+"'";
if ( db.ExecSql(strSql)==0) {
return false;
}
else{
if (!grade.equals("斑竹")){
strSql = "update sort set master='' where master='"+username+"'";
db.ExecSql(strSql);
}
return true;
}
}
}
bbs.rar_bbs_系统 （218个子文件） 
User.class 4KB Respond.class 3KB NewTopicSubmitAction.class 3KB Sort.class 3KB TopicAction.class 2KB SignAction.class 2KB Topic.class 2KB ActionSortInsert.class 2KB ActionUserEdit.class 2KB LoginAction.class 2KB ActionSortEditSubmit.class 2KB TopicDisp.class 2KB ActionTopicDel.class 2KB ActionAdminLogin.class 2KB ActionUserDel.class 2KB ActionSortDel.class 2KB UserForm.class 2KB ActionUserAdmin.class 2KB ActionSortAdmin.class 2KB ActionSortEdit.class 2KB NewTopicAction.class 2KB ActionTopicSearch.class 2KB ContentAction.class 2KB ActionUserSearch.class 2KB DB.class 1KB Constants.class 1011B SortForm.class 766B ActionSortPreInsert.class 765B PreSignAction.class 749B MyRequestProcessor.class 707B LoginUserForm.class 614B TopicForm.class 395B style.css 2KB style.css 2KB Thumbs.db 96KB Thumbs.db 96KB
btn_28.gif 1KB btn_28.gif 1KB btn_30.gif 1KB btn_30.gif 1KB btn_32.gif 1KB btn_32.gif 1KB bg_01.gif 1KB bg_01.gif 1KB b012.gif 942B b012.gif 942B btn_10.gif 882B btn_10.gif 882B btn_07.gif 843B btn_07.gif 843B b022.gif 799B b022.gif 799B btn_18.gif 722B btn_18.gif 722B btn_24.gif 642B btn_24.gif 642B icon_15.gif 601B icon_15.gif 601B btn_01.gif 560B btn_01.gif 560B btn_05.gif 545B btn_05.gif 545B btn_09.gif 533B btn_02.gif 533B btn_09.gif 533B btn_02.gif 533B btn_08.gif 523B btn_08.gif 523B part1_38.gif 522B part1_38.gif 522B icon_04.gif 475B icon_04.gif 475B icon_36.gif 470B icon_36.gif 470B icon_37.gif 334B icon_37.gif 334B female_2.gif 327B female_2.gif 327B male_2.gif 324B male_2.gif 324B icon_27.gif 267B icon_27.gif 267B icon_5.gif 264B 201.gif 264B icon_5.gif 264B 201.gif 264B icon_29.gif 263B icon_29.gif 263B icon_25.gif 262B icon_7.gif 262B icon_25.gif 262B icon_7.gif 262B icon_10.gif 261B icon_24.gif 261B icon_10.gif 261B icon_24.gif 261B icon_26.gif 259B icon_9.gif 259B icon_26.gif 259B icon_9.gif 259B共 218 条
- 1
- 2
- 3
资源评论
