servlet增删改查
写IUserDao接口
package com.zhongruan.dao;
import com.zhongruan.model.User;
import java.util.List;
public interface IUserDao {
User findPassword(String username);
List<User> findAll();
User findOne(int id);
void Deleted(int id);
void Insert(String username,String password);
void Updata(int id,String username,String password);
List findByPage(String username, int start, int size);
int selectCount(String searchname);
}
写UserDaoImpl类
package com.zhongruan.dao.impl;
import com.zhongruan.dao.IUserDao;
import com.zhongruan.model.User;
import com.zhongruan.util.Dbutil;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;
public class UserDaolmpl implements IUserDao {
@Override
public User findPassword(String username){
User user=null;
Connection connection=null;
PreparedStatement statement=null;
ResultSet resultSet=null;
try {
connection= Dbutil.getConnection();
String sql="select * from denglu where username=?";
statement=connection.prepareStatement(sql);
statement.setString(1,username);
resultSet=statement.executeQuery();
while (resultSet.next()){
user=new User();
user.setUsername(resultSet.getString(2));
user.setPassword(resultSet.getString(3));
user.setType(resultSet.getInt(4));
}
}catch (Exception e){
e.printStackTrace();
}finally {
Dbutil.Closeall(resultSet,statement,connection);
}
return user;
}
@Override
public List<User> findAll() {
List<User> users=new ArrayList<>();
Connection connection=null;
PreparedStatement statement=null;
ResultSet resultSet=null;
try {
connection=Dbutil.getConnection();
String sql="select * from denglu";
statement=connection.prepareStatement(sql);
resultSet=statement.executeQuery();
while (resultSet.next()){
User user=new User();
user.setId(resultSet.getInt(1));
user.setUsername(resultSet.getString(2));
user.setPassword(resultSet.getString(3));
users.add(user);
}
} catch (Exception e) {
e.printStackTrace();
}finally {
Dbutil.Closeall(resultSet,statement,connection);
}
return users;
}
@Override
public User findOne(int id) {
User user=null;
Connection connection=null;
PreparedStatement statement=null;
ResultSet resultSet=null;
try {
connection= D