📄 user_op.java~26~
字号:
package bookmanager;
import java.sql.ResultSet;
import java.sql.SQLException;
/**
* <p>Title: 图书管理</p>
*
* <p>Description: 大型软件实习项目</p>
*
* <p>Copyright: Copyright (c) 2005</p>
*
* <p>Company: 武汉大学计算机学院</p>
*
* @author 王佳
* @version 1.0
*/
public class user_op {
private String outHtml="";
private String tp="";
private String username="";
private String sql="";
private ResultSet rs1;
private String uid="";
private String hold="";
private String authority="";
private String email="";
private String address="";
private String regtime="";
private String sex="";
private String bclass="";
private String password="";
private String name="";
private String phone="";
private int allow=1;
public user_op() {
}
public String show_modi(){
outHtml="";
dbconnBean dbconn=new dbconnBean();
sql="select * from bookuser where username="+"'"+username+"'";
rs1=dbconn.executeQuery(sql);
try {
while (rs1.next()) {
username = rs1.getString("username");
uid = rs1.getString("uid");
password = rs1.getString("password");
name = rs1.getString("name");
sex = rs1.getString("sex");
email = rs1.getString("email");
phone = rs1.getString("phone");
address = rs1.getString("address");
authority = rs1.getString("authority");
hold = rs1.getString("hold");
bclass = rs1.getString("bclass");
regtime = rs1.getString("regtime");
}
} catch (SQLException ex1) {
outHtml="Sorry!^_^<br>你要查找的信息不存在!!";
}
if(tp.trim().equals("userinfo")){
this.allow++;
outHtml += "<tr bgcolor=#FFFFFF>"
+ "<td width=33% > </td>"
+ "<td align=left> ID: " + uid + "</td>"
+ "<td width=33% > </td>"
+ "</tr>";
outHtml += "<tr bgcolor=#FFFFFF>"
+ "<td width=33% > </td>"
+ "<td align=left> 用户名: " + username + "</td>"
+ "<td width=33% > </td>"
+ "</tr>";
outHtml += "<tr bgcolor=#FFFFFF>"
+ "<td width=33% > </td>"
+ "<td align=left> 密码: " + password + "</td>"
+ "<td width=33% > </td>"
+ "</tr>";
outHtml += "<tr bgcolor=#FFFFFF>"
+ "<td width=33% > </td>"
+ "<td align=left> 真实姓名: " + name + "</td>"
+ "<td width=33% > </td>"
+ "</tr>";
outHtml += "<tr bgcolor=#FFFFFF>"
+ "<td width=33% > </td>"
+ "<td align=left> 性别: " + sex + "</td>"
+ "<td width=33% > </td>"
+ "</tr>";
outHtml += "<tr bgcolor=#FFFFFF>"
+ "<td width=33% > </td>"
+ "<td align=left> E-mail: " + email + "</td>"
+ "<td width=33% > </td>"
+ "</tr>";
outHtml += "<tr bgcolor=#FFFFFF>"
+ "<td width=33% > </td>"
+ "<td align=left> 电话: " + phone + "</td>"
+ "<td width=33% > </td>"
+ "</tr>";
outHtml += "<tr bgcolor=#FFFFFF>"
+ "<td width=33% > </td>"
+ "<td align=left> 联系地址: " + address + "</td>"
+ "<td width=33% > </td>"
+ "</tr>";
outHtml += "<tr bgcolor=#FFFFFF>"
+ "<td width=33% > </td>"
+ "<td align=left> 系别: " + bclass + "</td>"
+ "<td width=33% > </td>"
+ "</tr>";
outHtml += "<tr bgcolor=#FFFFFF>"
+ "<td width=33% > </td>"
+ "<td align=left> 注册时间: " + regtime + "</td>"
+ "<td width=33% > </td>"
+ "</tr>";
outHtml += "<tr bgcolor=#FFFFFF>"
+ "<td width=33% > </td>"
+ "<td align=left> 借书数量: " + hold + "</td>"
+ "<td width=33% > </td>"
+ "</tr>";
outHtml += "<tr bgcolor=#FFFFFF>"
+ "<td width=33% > </td>"
+ "<td align=left> 权限: " + authority + "</td>"
+ "<td width=33% > </td>"
+ "</tr>";
}
if (tp.trim().equals("usermodi")) {
this.allow++;
//else{
outHtml = "";
outHtml += " <tr>"
+
" <td bgcolor=#FFFFFF><form name=form1 method=post action=user_op.jsp>"
+ " <table width=100% border=0 cellspacing=0 cellpadding=0>"
+ " <tr align=center>"
+ " <td colspan=4><span class=style12>__________________________________________________________________________________________________________________________________</span></td>"
+ " </tr>"
+ " <tr>"
+ " <td width=25%> </td>"
+ " <td width=15%>用户名 :</td>"
+
" <td><input name=username type=text size=40 maxlength=50 value=" +
username + "></td>"
+ " <td width=25%> </td>"
+ " </tr>"
;
outHtml +=
" <tr align=center>"
+ " <td colspan=4><span class=style12>__________________________________________________________________________________________________________________________________</span></td>"
+ " </tr>"
+ " <tr>"
+ " <td width=25%> </td>"
+ " <td width=15%>密码 :</td>"
+
" <td><input name=password type=text size=40 maxlength=50 value=" +
password + "></td>"
+ " <td width=25%> </td>"
+ " </tr>";
outHtml +=
" <tr align=center>"
+ " <td colspan=4><span class=style12>__________________________________________________________________________________________________________________________________</span></td>"
+ " </tr>"
+ " <tr>"
+ " <td width=25%> </td>"
+ " <td width=15%>性别 :</td>"
+
" <td><input name=sex type=text size=40 maxlength=50 value=" +
sex + "></td>"
+ " <td width=25%> </td>"
+ " </tr>";
outHtml +=
" <tr align=center>"
+ " <td colspan=4><span class=style12>__________________________________________________________________________________________________________________________________</span></td>"
+ " </tr>"
+ " <tr>"
+ " <td width=25%> </td>"
+ " <td width=15%>真实姓名:</td>"
+
" <td><input name=\"name\" type=text size=40 maxlength=50 value=" +
name + "></td>"
+ " <td width=25%> </td>"
+ " </tr>";
outHtml +=
" <tr align=center>"
+ " <td colspan=4><span class=style12>__________________________________________________________________________________________________________________________________</span></td>"
+ " </tr>"
+ " <tr>"
+ " <td width=25%> </td>"
+ " <td width=15%>email:</td>"
+
" <td><input name=email type=text size=40 maxlength=50 value=" +
email + "></td>"
+ " <td width=25%> </td>"
+ " </tr>";
outHtml +=
" <tr align=center>"
+ " <td colspan=4><span class=style12>__________________________________________________________________________________________________________________________________</span></td>"
+ " </tr>"
+ " <tr>"
+ " <td width=25%> </td>"
+ " <td width=15%>电话 :</td>"
+
" <td><input name=phone type=text size=40 maxlength=50 value=" +
phone + "></td>"
+ " <td width=25%> </td>"
+ " </tr>";
outHtml +=
" <tr align=center>"
+ " <td colspan=4><span class=style12>__________________________________________________________________________________________________________________________________</span></td>"
+ " </tr>"
+ " <tr>"
+ " <td width=25%> </td>"
+ " <td width=15%>地址 :</td>"
+
" <td><input name=address type=text size=40 maxlength=50 value=" +
address + "></td>"
+ " <td width=25%> </td>"
+ " </tr>";
outHtml +=
" <tr align=center>"
+ " <td colspan=4><span class=style12>__________________________________________________________________________________________________________________________________</span></td>"
+ " </tr>"
+ " <tr>"
+ " <td width=25%> </td>"
+ " <td width=15%>系别 :</td>"
+
" <td><input name=bclass type=text size=40 maxlength=50 value=" +
bclass + "></td>"
+ " <td width=25%> </td>"
+ " </tr>";
outHtml += " <tr align=center>"
+ " <td colspan=4><span class=style12>__________________________________________________________________________________________________________________________________</span></td>"
+ " </tr>" +
"<tr align=center>"
+ " <td colspan=4><input type=submit name=Submit value=提交> "
+ " <input type=reset name=Submit value=重置></td>"
+ " </tr>"
+ " </table>"
+ " </form></td>"
+ " </tr>";
//this.allow="allow";
}
return outHtml;
}
public boolean modifyuser(){
boolean result=false;
String sql = "UPDATE bookuser "
+ "SET name = '" + name + "', password ='" + password +
"', sex ='" + sex + "', email ='" + email + "', phone ='" +
phone + "', address ='" + address + "', bclass ='" + bclass
+ "' WHERE (username = 'a')";
System.out.println(sql);
dbconnBean dbconn=new dbconnBean();
result=dbconn.executeUpdate(sql);
return result;
}
public static void main(String[] args) {
user_op user_op = new user_op();
}
public void setTp(String tp) {
this.tp = tp;
}
public void setUsername(String username) {
this.username = username;
}
public void setAddress(String address) {
this.address = address;
}
public void setBclass(String bclass) {
this.bclass = bclass;
}
public void setEmail(String email) {
this.email = email;
}
public void setName(String name) {
this.name = name;
}
public void setPassword(String password) {
this.password = password;
}
public void setPhone(String phone) {
this.phone = phone;
}
public void setSex(String sex) {
this.sex = sex;
}
public void setAllow(int allow) {
this.allow = allow;
}
public String getUsername() {
return username;
}
public String getAddress() {
return address;
}
public String getBclass() {
return bclass;
}
public String getEmail() {
return email;
}
public String getName() {
return name;
}
public String getPassword() {
return password;
}
public String getPhone() {
return phone;
}
public String getSex() {
return sex;
}
public String getUid() {
return uid;
}
public int getAllow() {
return allow;
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -