chakan.java

个人办公平台,用JAVA开发的TOMCAT的服务器

/*
 * Created on 2006-10-6
 *
 * TODO To change the template for this generated file go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
package com.skyhawk.selffile;


import java.io.IOException;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;


import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.skyhawk.db.ConnectionFactory;

/**
 * @author Administrator
 *
 * TODO To change the template for this generated type comment go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
public class ChaKan {
	public void execute(HttpServletRequest request,HttpServletResponse response){
		
		 Connection conn=ConnectionFactory.getConnection();
		 Statement stmt=null;
		 ResultSet rs=null;
		 System.out.println("++++++++++++++++++++++++++++++++++");
         String sql="select * from O_file where sh=1";
         try {
			stmt=conn.createStatement() ;
			rs=stmt.executeQuery(sql);
		System.out.println("++++++++++++++++++++++++++++++++++");
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		ArrayList list=new ArrayList();
		System.out.println("---------------------------------------");
		try {
			while(rs.next()){
				System.out.println(rs.getString(1));
				String filename=rs.getString(1);
				System.out.println(filename +"=++++++++++++++++++++++++");
				String  id=rs.getString(4);
				String lujing=rs.getString(3);
				File file=new File();
				file.setFileName(filename);
			    file.setUserId(id);
			    file.setLuJing(lujing);
				list.add(file);
					}
		} catch (SQLException e1) {
			// TODO Auto-generated catch block
			e1.printStackTrace();
		}
			request.setAttribute("list",list);
		   try {
			request.getRequestDispatcher("/select.jsp").forward(request,response);
		} catch (ServletException e2) {
			// TODO Auto-generated catch block
			e2.printStackTrace();
		} catch (IOException e2) {
			// TODO Auto-generated catch block
			e2.printStackTrace();
		}
		
        
	}
}