test1.java

jsp编程jsp工程项目与实践 jsp源代码

package com.proreg;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.Collection;
import javax.servlet.RequestDispatcher;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class Test1 extends HttpServlet{

	private RequestDispatcher dispatcher;
	private ResultSet rs;
	private Statement stmt;
	private Connection db;
	private PrintWriter out;
	
	public Test1(){
		rs=null;
		stmt=null;
		db=null;
		out=null;
	}

	public void doPost(HttpServletRequest request,HttpServletResponse response)
				throws IOException{
		out=response.getWriter();
		Collection coll=new ArrayList();
		try {
			db=dbcon.getCon();
			stmt=db.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
			rs=stmt.executeQuery("SELECT * FROM Test2 ORDER BY ID DESC");
			while(rs.next()){
				Mas mas=new Mas();
				mas.setTitle(rs.getString(2));
				mas.setName(rs.getString(3));
				mas.setMtime(rs.getString(4));
				mas.setContent(rs.getString(5));
				coll.add(mas);
			}
			db.close();
			request.setAttribute("msg",coll);
			dispatcher=request.getRequestDispatcher("Test1.jsp");
			dispatcher.forward(request,response);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	public void doGet(HttpServletRequest request,HttpServletResponse response)
				throws IOException{
		doPost(request,response);
	}
}