deleteaction.java

医院信息系统(Hospital Information System

package hospital.Controller.Actions.GeneralFunction;

import org.apache.struts.action.*;
import javax.servlet.http.*;
import java.sql.*;
import hospital.Controller.ActionForms.*;

public class DeleteAction extends Action {
    String keyNames = "";
    String keyValues = "";
    String baseTableName = "";
    String superTableName = "";
    String menuID = "";

    public ActionForward execute(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) {

        String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
        String dbURL = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=hospital";
        String userName = "sa";
        String userPwd = "";
        Connection dbConn;

        try {
            Class.forName(driverName);
            dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
            Statement stmt = dbConn.createStatement();

            //初始化页面的所有参数
            initPageParameters(form, request);

            String sql = "delete from " + baseTableName + " where " + keyNames + "='" + keyValues + "'";
            System.out.println(sql);
            stmt.executeUpdate(sql);

            stmt.close();
            dbConn.close();

        } catch (Exception ex) {
            ex.printStackTrace();
        }
        return mapping.findForward("showDataAction");
    }

    private void setPropertyToOrginate() {
        keyNames = "";
        keyValues = "";
        baseTableName = "";
        superTableName = "";
        menuID = "";
    }

    private void initPageParameters(ActionForm form, HttpServletRequest request) {
        setPropertyToOrginate();
        ParametersActionForm parametersActionForm = (ParametersActionForm) form;
        keyNames = parametersActionForm.getKeyNames();
        keyValues = parametersActionForm.getKeyValues();
        baseTableName = parametersActionForm.getBaseTableName();
        superTableName = parametersActionForm.getSuperTableName();
        menuID = parametersActionForm.getKeyValues();
    }
}