mdatadaoimpl.java

来自「基本功能都实现了,对财务的增加,删除财务的信息,修改信息,查出财务的详细信息」· Java 代码 · 共 38 行

package com.cn.cms.dao.impl;
import java.util.List;
import com.cn.cms.dao.MdataDao;
import com.cn.cms.javabean.Mdatabean;
import java.sql.PreparedStatement;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import com.cn.cms.util.DBConnection;
public class MdataDaoImpl implements MdataDao {
  private PreparedStatement pstmt = null;
  private Statement stmt = null;
  private ResultSet rst = null;
  private DBConnection dbconnect = null;
  public MdataDaoImpl() {
     dbconnect = new DBConnection();
  }

  public List findAllMdata() {
   List mdatalist = new ArrayList();
    try{
    String sql ="select mId,mName from mData";
    //stmt = connect.getDBConnection().createStatement();
      stmt = dbconnect.getDBConnection().createStatement();
    rst = stmt.executeQuery(sql);
    while(rst.next()){
      Mdatabean mdatabean = new Mdatabean();
      mdatabean.setMId(rst.getString("mId"));
      mdatabean.setMName(rst.getString("mName"));
      mdatalist.add(mdatabean);
    }
  }catch(SQLException ex){
  ex.printStackTrace();
  }
  return mdatalist;
}
}