storedaoimpl.java

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

package com.cn.cms.dao.impl;

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

  public List findAllStore() {
    List storelist = new ArrayList();
    try{
    String sql ="select sId,sName from Store";
    stmt = dbconnect.getDBConnection().createStatement();
    rst = stmt.executeQuery(sql);
    while(rst.next()){
      StoreBean storebean = new StoreBean();
      storebean.setSId(rst.getString("sId"));
      storebean.setSName(rst.getString("sName"));
      storelist.add(storebean);
    }
  }catch(SQLException ex){
  ex.printStackTrace();
  }
  return storelist;

  }
}