folder.java

实现办公自动化系统

package com.oa.struts.perOffice.modle;
import com.oa.util.*;
import java.sql.*;
import java.util.ArrayList;
import java.util.List;

public class Folder {

	
	private Connection conn=null;
	

	public List getAllFolder()
	{
		DBConn db=new DBConn();
		ResultSet rs=null;
		conn=db.getConnection();
		List<FolderVo> list=new ArrayList<FolderVo>();
		try {
			conn.setAutoCommit(false);
			PreparedStatement pstmt=conn.prepareStatement("select * from tb_userfold");
			rs=pstmt.executeQuery();
			while(rs.next())
			{
				FolderVo fv=new FolderVo();
				fv.setFoldid(rs.getInt("foldid"));
				fv.setUserid(rs.getInt("userid"));
				fv.setFilename(rs.getString("filename"));
				fv.setIsshare(rs.getInt("isshare"));
				
				list.add(fv);
			}
			conn.commit();
		} catch (SQLException e) {
			// TODO Auto-generated catch block

			try {
				if(conn!=null)
				{
					conn.rollback();//事务回滚
				}
			} catch (SQLException e1) {
				
				e1.printStackTrace();
			}
			e.printStackTrace();
			e.printStackTrace();
		}
		
		return list;
	}
	
}