selectaction.java

javascript-----入门到精通的电子书

package com.zhuyang.ajax.action;

import java.sql.*;
import java.util.ArrayList;
import java.util.List;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;

import connectFactory.conFactory;

public class SelectAction extends Action {

	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		String sql = "select a.name,a.id from optionTable a where a.leveltype = '0'";
		Connection con = conFactory.con();
		Statement stmt = null;
		ResultSet rs  = null;
		try {
			stmt = con.createStatement();
			rs = stmt.executeQuery(sql);
			List list = new ArrayList();
			while(rs.next())
			{
				list.add(rs.getObject(1));
			}
			request.setAttribute("list",list);
		} catch (SQLException e) {
			e.printStackTrace();
		}
		finally
		{
			try {
				rs.close();
				stmt.close();
				con.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		return mapping.findForward("success");
	}
}