userinfoaction.java~25~

《struts 应用开发完全手册》中的源代码第一到第五章。

package com.action;

import org.apache.struts.action.*;
import javax.servlet.http.*;
import com.actionForm.UserInfoActionForm;
import com.dao.Chin;
import java.util.*;
import java.sql.*;

public class UserInfoAction
    extends Action {
  private final String dbDriver = "net.sourceforge.jtds.jdbc.Driver"; //连接sql数据库的方法
  private final String url =
      "jdbc:jtds:sqlserver://localhost:1433/db_userInfo01";
  private final String userName = "sa";
  private final String password = "";
  private Connection con = null;

  public UserInfoAction() {
    try {
      Class.forName(dbDriver).newInstance(); //加载数据库驱动
      con = DriverManager.getConnection(url, userName, password);
      con.setAutoCommit(true);
    }
    catch (Exception ex) {
      System.out.println("数据库加载失败");
    }
  }

//对数据库的增加、修改和删除的操作
  public boolean executeUpdate(UserInfoActionForm form) {
    String sql = "insert into tb_user01 values ('" + form.getName() + "','" +
        form.getAge() + "','" + form.getSex() + "','" + form.getProfession() +
        "')";
    try {
      Statement stmt = con.createStatement();
      int iCount = stmt.executeUpdate(sql);
      System.out.println("操作成功，所影响的记录数为" + String.valueOf(iCount));
    }
    catch (SQLException e) {

    }
    return true;
  }

  public ActionForward execute(ActionMapping mapping, ActionForm form,
                               HttpServletRequest request,
                               HttpServletResponse response) {
    UserInfoActionForm userInfoActionForm = (UserInfoActionForm) form;
    userInfoActionForm.setName(Chin.toChinese(userInfoActionForm.getName()));
    userInfoActionForm.setAge(Chin.toChinese(userInfoActionForm.getAge()));
    userInfoActionForm.setSex(Chin.toChinese(userInfoActionForm.getSex()));
    userInfoActionForm.setProfession(Chin.toChinese(userInfoActionForm.
        getProfession()));
    String messger = "添加用户失败！！！";
    if (executeUpdate(userInfoActionForm)) {
      messger="添加用户成功！！！";
    }
    return mapping.findForward("insertUserInfo");
  }
}