ry { 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")); entity.setPass(rs.getString("pass")); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { JdbcUtil.release(rs, pstmt); } return entity; } @Override public Admin checkLogin(String name) { Admin entity = null; String sql = "select * from admin where name= "; conn = JdbcUtil.getConn(); try { pstmt = conn.prepareStatement(sql); int index = 1; pstmt.setString(index++, name); rs = pstmt.executeQuery(); if (rs.next()) { entity = new Admin(); entity.setId(rs.getInt("id")); entity.setName(rs.getString("name")); entity.setPass(rs.getString("pass")); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { JdbcUtil.release(rs, pstmt); } return entity; } }
服务器接口类,用来将操作数据库的方法与记录历史的方法或其他的方法分离开,作用是增强代码的可读性以及条理性,
package service;
import java.util.List;
public interface BaseService
{
/**
* 插入数据
*/
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[]); } package service; import bean.Admin; public interface AdminService extends BaseService
{ Admin checkLogin(String name,String pass); Admin checkLogin(String name); }
实现服务器接口方法的实现类
package serviceImpl;
import java.util.List;
import dao.AdminDao;
import daoImpl.AdminDaoImpl;
import bean.Admin;
import service.AdminService;
public class AdminServiceImpl implements AdminService {
AdminDao adminDao = new AdminDaoImpl();
@Override
public boolean insert(Admin entity) {
return adminDao.insert(entity);
}
@Override
public boolean delete(Admin entity) {
return false;
}
@Override
public boolean deleteById(Integer id) {
return false;
}
@Override
public boolean update(Admin entity) {
return false;
}
@Override
public List
findAll() {
return null;
}
@Override
public Admin findById(Integer id) {
return null;
}
@Override
public List
findNowPageInfo(int nowpage, int pagesize, String sortName, String sortOrder) { return null; } @Override public Integer getCountPage(int pagesize) { return null; } @Override public boolean deletes(Object[] ids) { return false; } @Override public Admin checkLogin(String name, String pass) { Admin entity = adminDao.checkLogin(name, pass); return entity; } @Override public Admin checkLogin(String name) { Admin entity = adminDao.checkLogin(name); return entity; } }
用来将页面传入的信息进行分析处理的服务器类,
package servlet;
import java.io.IOException;
import java.net.URLEncoder;
import java.security.MessageDigest;
import java.security.NoSuchAlgorithmException;
import javax.jms.Message;
import javax.servlet.ServletException;
import javax.servlet.http.Cookie;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;