package com.dao;
import java.sql.*;
import java.util.Collection;
import java.util.ArrayList;
import javax.servlet.http.HttpServletRequest;
import com.core.Database;
import com.core.FinalConstants;
import com.core.ParamUtils;
import com.model.User;
/**
* <p>Title: </p>
* <p>Description: </p>
* <p>Copyright: Copyright (c) 2004</p>
* <p>Company: MR</p>
* @author BWM
* @version 1.0
*/
public class Dbuser extends User {
private User u = new User();
//不使初始化select
public Dbuser(){}
//使用数据库始化update
public Dbuser(String sql) {
Connection con = null;
PreparedStatement ps = null;
ResultSet rs = null;
try {
con = Database.getConnection();
ps = con.prepareStatement(FinalConstants.SELECT_USER+sql,ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs = ps.executeQuery();
if (rs.next()) {
u.setUid(ParamUtils.getSqlString(rs.getString("uid")));
u.setPassword(ParamUtils.getSqlString(rs.getString("password")));
u.setName(ParamUtils.getSqlString(rs.getString("name")));
u.setRegqu(ParamUtils.getSqlString(rs.getString("regqu")));
u.setReganswer(ParamUtils.getSqlString(rs.getString("reganswer")));
u.setIid(ParamUtils.getSqlString(rs.getString("iid")));
u.setSex(rs.getInt("sex"));
u.setAge(rs.getInt("age"));
u.setTel(ParamUtils.getSqlString(rs.getString("tel")));
u.setEmail(ParamUtils.getSqlString(rs.getString("email")));
u.setQq(ParamUtils.getSqlString(rs.getString("qq")));
u.setRegtime(ParamUtils.getSqlString(rs.getString("regtime")));
u.setAddress(ParamUtils.getSqlString(rs.getString("address")));
u.setHttp(ParamUtils.getSqlString(rs.getString("http")));
u.setStatus(rs.getInt("status"));
u.setState(rs.getInt("state"));
u.setResume(ParamUtils.getSqlString(rs.getString("resume")));
}
} catch (SQLException e) {
System.out.println(e.getMessage());
e.printStackTrace();
} finally {
System.out.println(ps+" Dbuser(String sql) "+u.getUid());
try {
if (ps != null) {
ps.close();
ps = null;
}
} catch (SQLException e) {
ps = null;
}
try {
if (con != null) {
con.close();
con = null;
}
} catch (SQLException e) {
con = null;
}
}
}
//使用内建对像初始化insert
public Dbuser(HttpServletRequest request) {
u.setUid(ParamUtils.getRequestString(request, "uid"));
u.setPassword(ParamUtils.getRequestString(request, "password"));
u.setName(ParamUtils.getRequestString(request, "name"));
u.setRegqu(ParamUtils.getRequestString(request, "regqu"));
u.setReganswer(ParamUtils.getRequestString(request, "reganswer"));
u.setSex(ParamUtils.getIntParameter(request, "sex"));
u.setAge(ParamUtils.getIntParameter(request, "age"));
u.setIid(ParamUtils.getRequestString(request, "iid"));
u.setTel(ParamUtils.getRequestString(request, "tel"));
u.setEmail(ParamUtils.getRequestString(request, "email"));
u.setQq(ParamUtils.getRequestString(request, "qq"));
u.setAddress(ParamUtils.getRequestString(request, "address"));
u.setHttp(ParamUtils.getRequestString(request, "http"));
u.setStatus(ParamUtils.getIntParameter(request, "status"));
u.setState(ParamUtils.getIntParameter(request, "state"));
u.setResume(ParamUtils.getRequestString(request, "resume"));
}
//注册时间插入系统时间
public boolean Insert() {
boolean b = false;
Connection con = null;
PreparedStatement ps = null;
try {
con = Database.getConnection();
ps = con.prepareStatement(FinalConstants.INSERT_USER);
System.out.println("Dbuser.java中:"+FinalConstants.INSERT_USER+"结束");
ps.setString(1, u.getUid());
ps.setString(2, u.getPassword());
ps.setString(3, u.getName());
ps.setString(4, u.getRegqu());
ps.setString(5, u.getReganswer());
ps.setString(6, u.getIid());
ps.setInt(7, u.getSex());
ps.setInt(8, u.getAge());
ps.setString(9, u.getTel());
ps.setString(10, u.getEmail());
ps.setString(11, u.getQq());
ps.setString(12, u.getAddress());
ps.setString(13, u.getHttp());
ps.setInt(14, u.getStatus());
ps.setInt(15, u.getState());
ps.setString(16, u.getResume());
if (ps.executeUpdate() > 0) {
b = true;
} else {
b = false;
}
} catch (SQLException e) {
b = false;
System.out.println(e.getMessage());
e.printStackTrace();
} finally {
System.out.println(ps+" Dbuser.Insert()");
try {
if (ps != null) {
ps.close();
}
} catch (SQLException e) {
ps = null;
}
try {
if (con != null) {
con.close();
}
} catch (SQLException e) {
con = null;
}
}
return b;
}
private boolean Update() {
boolean b = false;
Connection con = null;
PreparedStatement ps = null;
try {
con = Database.getConnection();
ps = con.prepareStatement(FinalConstants.UPDATE_USER);
ps.setString(1, u.getPassword());
ps.setString(2, u.getName());
ps.setString(3, u.getIid());
ps.setInt(4, u.getSex());
ps.setInt(5, u.getAge());
ps.setString(6, u.getTel());
ps.setString(7, u.getEmail());
ps.setString(8, u.getQq());
ps.setString(9, u.getAddress());
ps.setString(10, u.getHttp());
ps.setInt(11, u.getStatus());
ps.setInt(12, u.getState());
ps.setString(13, u.getResume());
ps.setString(14, u.getUid());
if (ps.executeUpdate() > 0) {
b = true;
} else {
b = false;
}
} catch (SQLException e) {
b = false;
e.printStackTrace();
} finally {
System.out.println(ps+" Dbuser.Update() ");
try {
if (ps != null) {
ps.close();
}
} catch (SQLException e) {
ps = null;
}
try {
if (con != null) {
con.close();
}
} catch (SQLException e) {
con = null;
}
}
return b;
}
private boolean Update_m() {
boolean b = false;
Connection con = null;
PreparedStatement ps = null;
try {
con = Database.getConnection();
ps = con.prepareStatement(FinalConstants.UPDATE_USER_M);
ps.setInt(1, u.getStatus());
ps.setInt(2, u.getState());
ps.setString(3, u.getUid());
if (ps.executeUpdate() > 0) {
b = true;
} else {
b = false;
}
} catch (SQLException e) {
没有合适的资源?快使用搜索试试~ 我知道了~
真实的项目源码!
共678个文件
jsp:235个
gif:176个
java:65个
需积分: 10 19 下载量 134 浏览量
2012-02-22
11:38:58
上传
评论 2
收藏 4.34MB ZIP 举报
温馨提示
java项目源码,部署说明,代码注释!绝对详细,一看就懂!
资源推荐
资源详情
资源评论
收起资源包目录
真实的项目源码! (678个子文件)
牙刷.bmp 64KB
zwtp.bmp 58KB
水杯.bmp 21KB
speaker.bmp 202B
Dbuser.class 13KB
Dbsoft.class 13KB
Dbmend.class 11KB
QuestString.class 10KB
Dbresolvent.class 9KB
Dbguestboard.class 9KB
Dbaffiche.class 8KB
Dblink.class 8KB
DbBasetableFactory.class 8KB
Dbquestion.class 8KB
Dbssort.class 8KB
Dbnew.class 8KB
Dbhead.class 7KB
BasetableFactoryProxy.class 7KB
FinalConstants.class 5KB
Database.class 4KB
ConnDB.class 4KB
Quest.class 4KB
User.class 3KB
MemberDaoImpl.class 3KB
StringUtils.class 3KB
Soft.class 3KB
ParamUtils.class 3KB
CalendarBean.class 3KB
BasetableFactory.class 3KB
Member.class 3KB
GoodsDaoImpl.class 3KB
SpRegist.class 2KB
Goods.class 2KB
HtmlUtils.class 2KB
KhinfoBean.class 2KB
Mend.class 2KB
GysinfoBean.class 2KB
Line.class 2KB
SpinfoBean.class 2KB
DBResult.class 2KB
Guestboard.class 2KB
Resolvent.class 2KB
KhRegist.class 2KB
GysRegist.class 2KB
SetCharacterEncoding.class 2KB
Fsort.class 2KB
FileUtils.class 2KB
New.class 1KB
ShowTime.class 1KB
SubtypeDaoImpl.class 1KB
PlacardDaoImpl.class 1KB
Affiche.class 1KB
SuperTypeDaoImpl.class 1KB
ChStr.class 1KB
Crazyadept.class 1KB
Head.class 1KB
Link.class 1KB
ToChinese.class 955B
Question.class 919B
Ssort.class 917B
SubType.class 832B
Placard.class 807B
SuperType.class 623B
Goodselement.class 338B
MemberDao.class 261B
GoodsDao.class 179B
SupertypeDao.class 157B
PlacardDao.class 151B
SubtypeDao.class 151B
css.css 7KB
style.css 3KB
style.css 2KB
style.css 1KB
admin.css 1KB
Thumbs.db 164KB
Thumbs.db 142KB
Thumbs.db 7KB
Thumbs.db 6KB
Thumbs.db 6KB
Thumbs.db 6KB
Thumbs.db 6KB
程序使用说明.doc 748KB
程序使用说明.doc 49KB
程序使用说明.doc 48KB
user.frm 9KB
soft.frm 9KB
mend.frm 9KB
guestboard.frm 9KB
resolvent.frm 9KB
new.frm 9KB
affiche.frm 8KB
ico.frm 8KB
link.frm 8KB
question.frm 8KB
ssort.frm 8KB
admin_top1.gif 112KB
admin_top.gif 78KB
manage_03.gif 24KB
download.gif 22KB
manage_center_goodsdetail.gif 19KB
共 678 条
- 1
- 2
- 3
- 4
- 5
- 6
- 7
资源评论
weicy_逆风
- 粉丝: 24
- 资源: 14
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功