javaBean的代码:更多Java学习教程薇老师:hua2021ei
package bean;
import java.io.Serializable;
public class Admin implements Serializable{
/**
*
*/
private static final long serialVersionUID = 1L;
private Integer id;
private String name;
private String pass;
public Admin() {
super();
// TODO Auto-generated constructor stub
}
public Admin(Integer id, String name, String pass) {
super();
this.id = id;
this.name = name;
this.pass = pass;
}
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getPass() {
return pass;
}
public void setPass(String pass) {
this.pass = pass;
}
@Override
public String toString() {
return "AdminBean [id=" + id + ", name=" + name + ", pass=" + pass
+ "]";
}
}
dao的基础接口类
package dao;
import java.util.List;
public interface BaseDao<T, PK> {
/**
* 插入数据
*/
boolean insert(T entity);
/**
* 根据实体删除数据
*/
boolean delete(T entity);
/**
* 根据ID删除数据
*/
boolean deleteById(PK id);
/**
* 修改数据
*/
boolean update(T entity);
/**
* 查询所有数据
*/
List<T> findAll();
/**
* 根据ID查询数据
*/
T findById(PK id);
/**
* 根据当前页查询数据
*/
List<T> findNowPageInfo(int nowpage, int pagesize,String sortName,String sortOrder);
/**
* 返回总页数
*/
Integer getCountPage(int pagesize);
/**
* 批量删除
*/
boolean deletes(Object ids[]);
}
对admin操作的接口类,继承自basedao
package dao;
import bean.Admin;
public interface AdminDao extends BaseDao<Admin, Integer> {
Admin checkLogin(String name,String pass);
Admin checkLogin(String name);
}
dao操作实体的实现类
package daoImpl;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;
import util.JdbcUtil;
import bean.Admin;
import dao.AdminDao;
public class AdminDaoImpl implements AdminDao {
private Connection conn;
private PreparedStatement pstmt;
private ResultSet rs;
@Override
public boolean insert(Admin entity) {
return JdbcUtil.upDate("insert into admin (name,pass) values (?,?)",
new Object[] { entity.getName(), entity.getPass() });
}
@Override
public boolean delete(Admin entity) {
// TODO Auto-generated method stub
return deleteById(entity.getId());
}
@Override
public boolean deleteById(Integer id) {
// TODO Auto-generated method stub
return JdbcUtil.upDate("delete from admin where id=?",
new Object[] { id });
}
@Override
public boolean update(Admin entity) {
// TODO Auto-generated method stub
return JdbcUtil.upDate(
"update admin set name=?,pass=? where id=?",
new Object[] { entity.getName(), entity.getPass(),
entity.getId() });
}
@Override
public List<Admin> findAll() {
// TODO Auto-generated method stub
return null;
}
@Override
public Admin findById(Integer id) {
// TODO Auto-generated method stub
return null;
}
@Override
public List<Admin> findNowPageInfo(int nowpage, int pagesize,
String sortName, String sortOrder) {
// TODO Auto-generated method stub
return null;
}
@Override
public Integer getCountPage(int pagesize) {
// TODO Auto-generated method stub
return null;
}
@Override
public boolean deletes(Object[] ids) {
// TODO Auto-generated method stub
return false;
}
@Override
public Admin checkLogin(String name, String pass) {
// TODO Auto-generated method stub
Admin entity = null;
String sql = "select * from admin where name=? and pass=?";
conn = JdbcUtil.getConn();
try {
pstmt = conn.prepareStatement(sql);
int index = 1;
pstmt.setString(index++, name);
pstmt.setString(index++, pass);
rs = pstmt.executeQuery();
if (rs.next()) {
entity = new Admin();
entity.setId(rs.getInt("id"));
entity.setName(rs.getString("name"));