packagedaoImpl;importjava.sql.Connection;importjava.sql.PreparedStatement;importjava.sql.ResultSet;importjava.util.ArrayList;importjava.util.Date;importjava.util.List;importjdbcutil.JdbcUtil;importdao.UserDao;importentity.User;public class UserDaoImpl implementsUserDao {
@Overridepublic voidadd(User u) {
Connection con= null;
PreparedStatement stmt= null;
ResultSet rs= null;try{
con=JdbcUtil.getConnection();
String sql= "insert into [user](username,password,createtime) values(?,?,?)";
stmt=con.prepareStatement(sql);
stmt.setString(1, "test");
stmt.setString(2,"123456");
stmt.setDate(3, newjava.sql.Date(u.getCreatetime().getTime()));
stmt.executeUpdate();
}catch(Exception e) {
e.printStackTrace();
}finally{
JdbcUtil.close(rs, stmt, con);
}
}
@OverridepublicUser getByUsername(String username) {
Connection con= null;
PreparedStatement stmt= null;
ResultSet rs= null;try{
con=JdbcUtil.getConnection();
String sql= "select * from [user] where username=?";
stmt=con.prepareStatement(sql);
stmt.setString(1, username);
rs=stmt.executeQuery();while(rs.next())
{int id = rs.getInt("id");
String name= rs.getString("username");
String password= rs.getString("password");
Date time= rs.getDate("createtime");
User u= newUser(id,username,password,time);returnu;
}
}catch(Exception e) {
e.printStackTrace();
}finally{
JdbcUtil.close(rs, stmt, con);
}return null;
}
@Overridepublic voidupdate(User u) {
Connection con= null;
PreparedStatement stmt= null;
ResultSet rs= null;try{
con=JdbcUtil.getConnection();
String sql= "update [user] set password=? where username=?";
stmt=con.prepareStatement(sql);
stmt.setString(1, u.getPassword());
stmt.setString(2, u.getUsername());
stmt.executeUpdate();
}catch(Exception e) {
e.printStackTrace();
}finally{
JdbcUtil.close(rs, stmt, con);
}
}
@Overridepublic voiddelete(String username) {
Connection con= null;
PreparedStatement stmt= null;
ResultSet rs= null;try{
con=JdbcUtil.getConnection();
String sql= "delete from [user] where username=?";
stmt=con.prepareStatement(sql);
stmt.setString(1,username);
stmt.executeUpdate();
}catch(Exception e) {
e.printStackTrace();
}finally{
JdbcUtil.close(rs, stmt, con);
}
}
@Overridepublic ListfindAll() {
List list = new ArrayList();
Connection con= null;
PreparedStatement stmt= null;
ResultSet rs= null;try{
con=JdbcUtil.getConnection();
String sql= "select * from [user]";
stmt=con.prepareStatement(sql);
rs=stmt.executeQuery();while(rs.next())
{
User u= new User(rs.getInt("id"), rs.getString("username"),rs.getString("password"),rs.getDate("createtime"));
list.add(u);
}returnlist;
}catch(Exception e) {
e.printStackTrace();
}finally{
JdbcUtil.close(rs, stmt, con);
}return null;
}
}