userinfoaction.java~6~

来自「《struts 应用开发完全手册》中的源代码第一到第五章。」· JAVA~6~ 代码 · 共 66 行

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 = "com.mysql.jdbc.Driver"; //连接sql数据库的方法
 private final String url =
     "jdbc:mysql://127.0.0.1:3306/db_mysql";
 private final String userName = "root";
 private final String password = "mrsoft";
 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) throws
     SQLException {
   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="添加用户成功！！！";
   }
   request.setAttribute("messger",messger);
   con.close();
   return mapping.findForward("insertUserInfo");
 }

}