insertaction.java

来自「javascript-----入门到精通的电子书」· Java 代码 · 共 44 行

package com.zhuyang.ajax.action;

import java.sql.*;
import java.util.*;
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 InsertAction extends Action {

	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		String id = "";
		String name= "";
		String leveltype = "";
		String parentid ="";
		
		id = request.getParameter("id");
		name = request.getParameter("name");
		leveltype = request.getParameter("leveltype");
		parentid = request.getParameter("parentid");
		String sql = "insert into OPTIONTABLE(id,name,leveltype,parentid)values(?,?,?,?)";
		Connection con = conFactory.con();
		try {
			PreparedStatement pstmt = con.prepareStatement(sql);
			pstmt.setString(1,id);
			pstmt.setString(2,name);
			pstmt.setString(3,leveltype);
			pstmt.setString(4,parentid);
			pstmt.execute();
			System.out.println("insert ok!!");
		} catch (SQLException e) {
			e.printStackTrace();
		}
		
		return mapping.findForward(null);
	}
}