src/com/tjzhic/dao/impl/RecordDaoImpl.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

package com.tjzhic.dao.impl;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;

import com.tjzhic.dao.RecordDao;
import com.tjzhic.db.ConnectionFactory;
import com.tjzhic.entity.Grade;
import com.tjzhic.entity.Record;
import com.tjzhic.entity.Reginfo;
import com.tjzhic.entity.SupGrade;
import com.tjzhic.util.PageModel;

public class RecordDaoImpl implements RecordDao{

  //添加登录记录
  public int add(Record record) {
    int rows = 0;
    Connection con = ConnectionFactory.getConnection();
    PreparedStatement pre = null;
    try {
        String sql = "insert into record(logname,usergroup,logtime,logip) values(?,?,NOW(),?)";
        pre = con.prepareStatement(sql);
        pre.setString(1, record.getLogname());
        pre.setString(2, record.getUsergroup());
        pre.setString(3, record.getLogip());
        rows = pre.executeUpdate();
    } catch (SQLException e) {
        e.printStackTrace();
    } finally {
        try{
            if (pre!=null)
                pre.close();
            if (con != null)
                con.close();
        }catch (SQLException e) {
            e.printStackTrace();
        }
    }
    return rows;
  }

  //分页查询记录
  public PageModel<Record> pageByLogname(String logname, 
      String usergroup,int pageSize, int pageNo) {
    String sql = "select logname,usergroup,logtime,logip "
          + "from record where logname='" 
          + logname + "' and usergroup='" + usergroup + "' order by rid desc";
    ArrayList<Record> records = new ArrayList<Record>();
    PageModel<Record> pm = new PageModel<Record>(pageSize, pageNo, total(sql));
    Connection con = ConnectionFactory.getConnection();
    PreparedStatement pre = null;
    ResultSet rs = null;
    try{
      pre = con.prepareStatement(sql+" limit " 
          + (pm.getPageNo() - 1) * pm.getPageSize() + "," + pm.getPageSize());