package com.chao.daoimpl;
import com.chao.bean.User;
import com.chao.dao.UserDao;
import com.chao.utils.C3P0Util;
import com.chao.utils.DBCPUtil;
import com.chao.utils.DBUtils;
import org.apache.commons.dbcp.BasicDataSourceFactory;
import javax.sql.DataSource;
import java.io.FileInputStream;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.text.SimpleDateFormat;
import java.util.Properties;
/**
* Created by Chao on 2016/12/11.
*/
public class UserDaoImpl implements UserDao {
/**
* 添加用户
*
* @param user
*/
@Override
public void addUser(User user) throws Exception {
Connection conn = null;
PreparedStatement ps = null;
try {
conn = DBUtils.getConnection();
ps = conn.prepareStatement("INSERT INTO users(name,pwd,phone,DATE) VALUES(?,?,?,?)");
ps.setString(1, user.getName());
ps.setString(2, user.getPwd());
ps.setString(3, user.getPhone());
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String date = sdf.format(user.getDate());
ps.setString(4, date);
int i = ps.executeUpdate();
} catch (Exception e) {
e.printStackTrace();
throw new RuntimeException("添加失败!");
} finally {
DBUtils.closeAll(null, ps, conn);
}
}
/**
* 查询用户账号密码是否有效
*
* @param user
* @return
* @throws Exception
*/
public User findUser(User user) throws Exception {
Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;
User u = null;
try {
conn = C3P0Util.getConnection();
ps = conn.prepareStatement("select * from users where name=? and pwd=?");
ps.setString(1, user.getName());
ps.setString(2, user.getPwd());
rs = ps.executeQuery();
if (rs.next()) {
u = new User();
u.setId(rs.getInt(1));
u.setName(rs.getString(2));
u.setPwd(rs.getString(3));
u.setPhone(rs.getString(4));
u.setDate(rs.getTimestamp(5));
}
} catch (Exception e) {
e.printStackTrace();
} finally {
C3P0Util.closeAll(rs, ps, conn);
}
return u;
}
/**
* 查询用户名是否已经存在
*
* @param name
* @return
*/
public boolean findUserByName(String name) {
Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;
try {
conn = DBCPUtil.getConnection();
ps = conn.prepareStatement("select * from users where name=?");
ps.setString(1, name);
rs = ps.executeQuery();
if (rs.next()) {//如果账号存在
return true;
}
} catch (Exception e) {
e.printStackTrace();
} finally {
DBCPUtil.closeAll(rs, ps, conn);
}
return false;
}
}
没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
收起资源包目录
FishermanServlet.zip (92个子文件)
FishermanServlet
src
dbinfo.properties 107B
dbcpconfig.properties 1KB
com
chao
dao
UserDao.java 637B
exception
UserExistException.java 548B
UsersException.java 590B
webservlet
LoginServlet.java 2KB
RegServlet.java 3KB
bean
User.java 1KB
UserForm.java 3KB
servletimpl
UserServiceImpl.java 918B
servlet
UserServlet.java 749B
daoimpl
UserDaoImpl.java 3KB
utils
DBUtils.java 2KB
C3P0Util.java 2KB
DBCPUtil.java 3KB
BaseHttpServlet.java 2KB
c3p0-config.xml 1KB
c.tld 16KB
.idea
uiDesigner.xml 9KB
misc.xml 1018B
.name 16B
copyright
profiles_settings.xml 76B
modules.xml 272B
encodings.xml 159B
compiler.xml 686B
workspace.xml 71KB
artifacts
FishermanServlet_war_exploded.xml 539B
out
artifacts
FishermanServlet_war_exploded
META-INF
TomcatXml.xml 2KB
context.xml 534B
WEB-INF
web.xml 864B
classes
dbinfo.properties 107B
dbcpconfig.properties 1KB
com
chao
dao
UserDao.class 323B
exception
UsersException.class 740B
UserExistException.class 752B
webservlet
LoginServlet.class 2KB
RegServlet.class 3KB
bean
User.class 1KB
UserForm.class 3KB
servletimpl
UserServiceImpl.class 1KB
servlet
UserServlet.class 425B
daoimpl
UserDaoImpl.class 3KB
utils
DBCPUtil.class 3KB
DBUtils.class 2KB
BaseHttpServlet.class 2KB
C3P0Util.class 1KB
c3p0-config.xml 1KB
c.tld 16KB
lib
c3p0-0.9.1.2.jar 596KB
standard.jar 384KB
commons-beanutils-1.8.3.jar 227KB
commons-logging-1.1.1.jar 59KB
mysql-connector-java-5.0.8-bin.jar 528KB
jstl.jar 20KB
commons-pool.jar 61KB
commons-dbcp.jar 119KB
login.jsp 563B
index.jsp 2KB
register.jsp 675B
web
META-INF
TomcatXml.xml 2KB
context.xml 534B
WEB-INF
web.xml 864B
classes
dbinfo.properties 107B
dbcpconfig.properties 1KB
com
chao
dao
UserDao.class 323B
exception
UsersException.class 740B
UserExistException.class 752B
webservlet
LoginServlet.class 2KB
RegServlet.class 3KB
bean
User.class 1KB
UserForm.class 3KB
servletimpl
UserServiceImpl.class 1KB
servlet
UserServlet.class 425B
daoimpl
UserDaoImpl.class 3KB
utils
DBCPUtil.class 3KB
DBUtils.class 2KB
BaseHttpServlet.class 2KB
C3P0Util.class 1KB
c3p0-config.xml 1KB
c.tld 16KB
lib
c3p0-0.9.1.2.jar 596KB
standard.jar 384KB
commons-beanutils-1.8.3.jar 227KB
commons-logging-1.1.1.jar 59KB
mysql-connector-java-5.0.8-bin.jar 528KB
jstl.jar 20KB
commons-pool.jar 61KB
commons-dbcp.jar 119KB
login.jsp 563B
index.jsp 2KB
register.jsp 675B
FishermanServlet.iml 2KB
共 92 条
- 1
资源评论
peakchao
- 粉丝: 339
- 资源: 11
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功