checkdatadaoimpl.java

基本功能都实现了,对财务的增加,删除财务的信息,修改信息,查出财务的详细信息

package com.cn.cms.dao.impl;

import com.cn.cms.dao.CheckdataDao;
import com.cn.cms.util.DBConnection;
import com.cn.cms.javabean.CheckdataBean;
import java.sql.PreparedStatement;
import java.sql.Statement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;
import java.sql.SQLException;

public class CheckdataDaoImpl
    implements CheckdataDao {
  private DBConnection connect = null;
  private PreparedStatement pstmt = null;
  private Statement stmt = null;
  private ResultSet rst = null;
  private CheckdataBean bean = null;
  private List listbean = new ArrayList();
  public CheckdataDaoImpl() {
    connect = new DBConnection();
  }

  /**
   * 查找最大的记录值
   */
  private int findBymaxId() {
    int recid = 0;
    try {
      String sql = "select IsNull(max(mId),0) from checkdata";
      stmt = connect.getDBConnection().createStatement();
      rst = stmt.executeQuery(sql);
      if (rst.next()) {
        recid = rst.getInt(1);
      }
    }
    catch (SQLException ex) {
      ex.printStackTrace();
    }
    finally {
      if (stmt != null) {
        connect.closeStatement(stmt);
      }
      if (rst != null) {
        connect.closeResultSet(rst);
      }
      connect.closeConnection();
    }
    return recid;
  }

  public boolean InsertCheckdata(CheckdataBean checkdatabean) {
    try {
      String sql = "insert into checkdata values(?,?,?,?,?,?,?,?,?)";
      pstmt = connect.getDBConnection().prepareStatement(sql);
      int iLoop = 1;
      int addId = findBymaxId();
      pstmt.setInt(iLoop++, ++addId);
      pstmt.setString(iLoop++, checkdatabean.getMMan());
      pstmt.setString(iLoop++, checkdatabean.getMAddr());
      pstmt.setString(iLoop++, checkdatabean.getMTel());
      pstmt.setInt(iLoop++, checkdatabean.getMKind().intValue());
      pstmt.setInt(iLoop++, checkdatabean.getMCount().intValue());
      pstmt.setString(iLoop++, checkdatabean.getMOperator());
      pstmt.setString(iLoop++, checkdatabean.getMEmp());
      pstmt.setString(iLoop++, checkdatabean.getMDate());
      int Result = 0;
      Result = pstmt.executeUpdate();
      if (Result != 0) {
        return true;
      }
      else {
        return false;
      }
    }
    catch (SQLException ex) {
      ex.printStackTrace();
    }
    finally {
      if (connect != null) {
        connect.closeStatement(pstmt);
      }
      if (connect != null) {
        connect.closeConnection();
      }
    }
    return false;
  }

  public List findByAll() {
    try {
      String sql =
          "select mId,mMan,mAddr,mTel,mKind,mCount,mOperator,mEmp,mDate from checkdata";
      stmt = connect.getDBConnection().createStatement();
      rst = stmt.executeQuery(sql);
      while (rst.next()) {
        bean = new CheckdataBean();
        bean.setMId(rst.getString("mId"));
        bean.setMMan(rst.getString("mMan"));
        bean.setMAddr(rst.getString("mAddr"));
        bean.setMTel(rst.getString("mTel"));
        bean.setMKind(new Integer(rst.getInt("mKind")));
        bean.setMCount(new Integer(rst.getInt("mCount")));
        bean.setMOperator(rst.getString("mOperator"));
        bean.setMEmp(rst.getString("mEmp"));
        bean.setMDate(rst.getString("mDate"));
        listbean.add(bean);
      }
    }
    catch (SQLException ex) {
      ex.printStackTrace();
    }
    return listbean;
  }

  public boolean deleteById(String mid) {
    try{
     String sql ="delete  from checkdata where mId='"+mid+"'";
     stmt = connect.getDBConnection().createStatement();
     int result = 0;
     result = stmt.executeUpdate(sql);
     if(result!=1)return false;
     else return true;
    }catch(SQLException ex){
     ex.printStackTrace();
     return false;
    }
  }

  public CheckdataBean findById(String mid) {
    try{
      String sql = "select mId,mMan,mAddr,mTel,mKind,mCount,mOperator,mEmp,mDate from checkdata where mId='";
      sql +=mid+"'";
      stmt = connect.getDBConnection().createStatement();
     rst = stmt.executeQuery(sql);
     while (rst.next()) {
       bean = new CheckdataBean();
       bean.setMId(rst.getString("mId"));
       bean.setMMan(rst.getString("mMan"));
       bean.setMAddr(rst.getString("mAddr"));
       bean.setMTel(rst.getString("mTel"));
       bean.setMKind(new Integer(rst.getInt("mKind")));
       bean.setMCount(new Integer(rst.getString("mCount")));
       bean.setMOperator(rst.getString("mOperator"));
       bean.setMEmp(rst.getString("mEmp"));
       bean.setMDate(rst.getString("mDate"));
    }
    }catch(SQLException ex){
      ex.printStackTrace();
    }
    return bean;
  }
}