cardmgrdao.java

实现办公自动化系统

package com.oa.struts.perOffice.modle;

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 java.util.List;

import com.oa.struts.vo.CardSortInfo;
import com.oa.struts.vo.DeptInfo;
import com.oa.struts.vo.UserInfo;
import com.oa.util.DBConn;

public class CardMgrDAO {
	
	public Connection con;
	public PreparedStatement pstmt;
	public Statement stmt;
	public DBConn dbcon;
	public ResultSet rs;
	public List getCardFileList()
	{
		List<CardSortInfo> lt=new ArrayList<CardSortInfo>();
		dbcon=new DBConn();
		try
		{
			con=dbcon.getConnection();
			con.setAutoCommit(false);
			String sql="select * from tb_cardfile";
			stmt=con.createStatement();
			rs=stmt.executeQuery(sql);
			while(rs.next())
			{
				CardSortInfo csi=new CardSortInfo();
			
				csi.setId(rs.getInt("id"));
				csi.setCardfilename(rs.getString("Cardfilename"));
				csi.setIsshare(rs.getInt("Isshare"));
				csi.setFounder(rs.getInt("Founder"));
				
				lt.add(csi);
			}
			
		}
		catch(SQLException e)
		{
			e.printStackTrace();
		}
		return lt;
	}
}