


javaBean的代码
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
{
/**
* 插入数据
*/
boolean insert(T entity);
/**
* 根据实体删除数据
*/
boolean delete(T entity);
/**
* 根据ID删除数据
*/
boolean deleteById(PK id);
/**
* 修改数据
*/
boolean update(T entity);
/**
* 查询所有数据
*/
List
findAll(); /** * 根据ID查询数据 */ T findById(PK id); /** * 根据当前页查询数据 */ List
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 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
findAll() {
// TODO Auto-generated method stub
return null;
}
@Override
public Admin findById(Integer id) {
// TODO Auto-generated method stub
return null;
}
@Override
public List
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(); t