userdatadaoimpl.java

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

package com.cn.cms.dao.impl;

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

  }

  public List findByuserId() {
    usedatalist = new ArrayList();
    try{
      String sql ="select userId,userTypeName from userType";
      stmt = dbconnect.getDBConnection().createStatement();
      rst = stmt.executeQuery(sql);
      while(rst.next()){
        UseData userdao = new UseData();
        userdao.setUserId(new Integer(rst.getInt("userId")));
        userdao.setUserTypeName(rst.getString("userTypeName"));
       // String a = rst.getString("userTypeName");
        usedatalist.add(userdao);
      }

    }catch(SQLException ex){
      ex.printStackTrace();
    }finally{
    if(dbconnect!=null)dbconnect.closeStatement(stmt);
    if(dbconnect!=null)dbconnect.closeResultSet(rst);
    if(dbconnect!=null)dbconnect.closeConnection();

    }
    return usedatalist;
  }
}