-
Notifications
You must be signed in to change notification settings - Fork 0
/
Userinfo.java
205 lines (178 loc) · 5.1 KB
/
Userinfo.java
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
package likinsDatabase;
import java.sql.ResultSet;
import java.sql.SQLException;
/** the class process the user information */
public class Userinfo extends Access_db{
private String userID;
private String username;
private String password;
private String signature; //signature path
private String portrait; //portrait path
private String sql; //sql statement to perform various operations
/** constructor */
public Userinfo(){
userID="";
username="";
password="";
signature="";
portrait="";
}
/** constructor */
public Userinfo(String userid,String name,String pass,String signaturePath,String portraitPath){
userID=userid;
username=name;
password=pass;
signature=signaturePath;
portrait=portraitPath;
}
/** set user ID */
public void setUserID(String id){
this.userID=id;
}
/** set user name */
public void setUserName(String name){
this.username=name;
}
/** set user password */
public void setPassword(String pass){
this.password=pass;
}
/** set user signature path */
public void setSignature(String sig){
this.signature=sig;
}
/** set user portrait path */
public void setPortrait(String path){
this.portrait=path;
}
/** get user ID */
public String getUserID(){
return userID;
}
/** get user name */
public String getUsername(){
return username;
}
/** get password */
public String getPassword(){
return password;
}
/** get signature path */
public String getSignature(){
return signature;
}
/** get portrait path */
public String getPortrait(){
return portrait;
}
/** set user's information parameter are username,signature path,portrait path
* according to the userID */
public boolean setUserInfo(){
boolean is_set_success=false;
//insert username,signature,portrait into userinfo
sql=" update userinfo set username="+ "'" +getUsername()+ "'," ;
sql=sql+"signature=" + "'" + getSignature() + "',";
sql=sql+"portrait=" + "'" + getPortrait() + "'";
sql=sql+"where userID=" + "'" + getUserID() + "';" ;
is_set_success=super.exeSQL(sql);
return is_set_success;
}
//the function modifying information
/** modify the user name */
public boolean modifyUsername() {
boolean is_modify_success=false;
sql="update userinfo set username=" + "'"+getUsername()+ "'";
sql=sql+" where userID=" +"'" + getUserID()+ "';";
is_modify_success=super.exeSQL(sql);
return is_modify_success;
}
/** modify the user password */
public boolean modifyPassword(){
boolean is_modify_success=false;
sql="update userinfo set password=" + "'"+getPassword()+ "'";
sql=sql+" where userID=" +"'" + getUserID()+ "';";
is_modify_success=super.exeSQL(sql);
return is_modify_success;
}
/** modify the user signature */
public boolean modifySignature(){
boolean is_modify_success=false;
sql="update userinfo set signature=" + "'"+getSignature()+ "'";
sql=sql+" where userID=" +"'" + getUserID()+ "';";
is_modify_success=super.exeSQL(sql);
return is_modify_success;
}
/** modify the user portrait */
public boolean modifyPortrait(){
boolean is_modify_success=false;
sql="update userinfo set portrait=" + "'"+getPortrait()+ "'";
sql=sql+" where userID=" +"'" + getUserID()+ "';";
is_modify_success=super.exeSQL(sql);
return is_modify_success;
}
//the function for getting information from database
/** get user name from database */
public String getUserNameFromDb(){
ResultSet rs=null;
String userName="";
sql="select username from userinfo where userID="; //select username
sql=sql+ "'" + getUserID() + "';";
rs=exeSqlQuery(sql);
try {
rs.next();
userName=rs.getString("username"); //read the user name
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return userName;
}
/** get signature from database */
public String getSignatureFromDb(){
ResultSet rs=null;
String signaturePath="";
sql="select signature from userinfo where userID=";
sql=sql+ "'" + getUserID() + "';";
rs=exeSqlQuery(sql);
try {
rs.next();
signaturePath=rs.getString("signature"); //read the signaturePath
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return signaturePath;
}
/** get portrait from database */
public String getPortraitFromDb(){
ResultSet rs=null;
String portraitPath="";
sql="select portrait from userinfo where userID=";
sql=sql+ "'" + getUserID() + "';";
rs=exeSqlQuery(sql);
try {
rs.next();
portraitPath=rs.getString("portrait"); //read the portrait
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return portraitPath;
}
/** Determine whether the username is exist */
public boolean isUserNameExist(){
ResultSet rs=null;
//query the username on table userinfo
sql="select * from userinfo where username='"+getUsername()+"';";
boolean is_exist=false; //do not exist
try{
rs=super.exeSqlQuery(sql);
if(rs.next()){
is_exist=true; //username is exist, return true
}
}catch (Exception e) {
System.out.println(e.toString());// TODO: handle exception
}
return is_exist;
}
}