MyEclipse 6.0开发实例

package com.ssit.Servlet; import java.io.IOException; import java.io.PrintWriter; import java.sql.ResultSet; import java.sql.SQLException; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import com.ssit.DB.DB_Handle; import com.ssit.Handle.String_Handle; /** * 中科盛世 * 创建日期： Dec 10, 200710:43:01 AM * 外层包：com.ssit.Servlet * @author 易纲 */ public class UserGroupInfo extends HttpServlet { /** * Constructor of the object. */ public UserGroupInfo() { super(); } /** * Destruction of the servlet. <br> */ public void destroy() { super.destroy(); // Just puts "destroy" string in log // Put your code here } /** * The doGet method of the servlet. <br> * * This method is called when a form has its tag value method equals to get. * * @param request the request send by the client to the server * @param response the response send by the server to the client * @throws ServletException if an error occurred * @throws IOException if an error occurred */ public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doPost(request, response); } /** * The doPost method of the servlet. <br> * * This method is called when a form has its tag value method equals to post. * * @param request the request send by the client to the server * @param response the response send by the server to the client * @throws ServletException if an error occurred * @throws IOException if an error occurred */ public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String actionType = request.getParameter("actionType"); if (actionType.equals("del")) { doDel(request, response); } else if (actionType.equals("new")) { try { doNew(request, response); } catch (SQLException e) { e.getStackTrace(); } } else if (actionType.equals("update")) { doUpdate(request, response); } } /** * 返回权限编号 * @param SECURITY_NAME 权限名称 * @return */ String getSecurityId(String SECURITY_NAME) throws SQLException { String securityId = ""; DB_Handle dbHandle = new DB_Handle(); dbHandle.connectionDatabase(); ResultSet rs = dbHandle .execQuerySQL("select * from privilegetable where priv= '" + SECURITY_NAME + "'"); if (rs.next()) { securityId = rs.getString("id"); } dbHandle.freeConnection(); return securityId; } void doNew(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException, SQLException { ResultSet rs; String ID; String userGroupName = String_Handle.unescape_GB2312(request .getParameter("userGroupName")); String admin = request.getParameter("admin"); String isAuditing = request.getParameter("isAuditing"); String expert_new = request.getParameter("expert_new"); String expert_update = request.getParameter("expert_update"); String expert_del = request.getParameter("expert_del"); String project_new = request.getParameter("project_new"); String project_update = request.getParameter("project_update"); String project_del = request.getParameter("project_del"); String expert_query = request.getParameter("expert_query"); String expert_auditing = request.getParameter("expert_auditing"); DB_Handle dbHandle = new DB_Handle(); dbHandle.connectionDatabase(); rs = dbHandle .execQuerySQL("select * from usergroup where groupname = '" + userGroupName + "'"); if (rs.next()) { dbHandle.freeConnection(); response.sendRedirect("../SystemSet/UserGroupManage/warning.jsp"); } else { ID = String_Handle.getCurrDateTimeStr(false, true); dbHandle .execUpdateSQL("insert into usergroup(id,groupname)values('" + ID + "','" + userGroupName + "')"); if ((admin!=null) && admin.equals("1")) { dbHandle.execUpdateSQL("insert into role(groupid,privid)values('" + ID + "'," + getSecurityId("系统管理") + ")"); } if ((isAuditing!=null) && isAuditing.equals("1")) { dbHandle.execUpdateSQL("insert into role(groupid,privid)values('" + ID + "'," + getSecurityId("用户审核") + ")"); } if ((expert_new!=null) && expert_new.equals("1")) { dbHandle.execUpdateSQL("insert into role(groupid,privid)values('" + ID + "'," + getSecurityId("专家新增") + ")"); } if ((expert_update!=null) && expert_update.equals("1")) { dbHandle.execUpdateSQL("insert into role(groupid,privid)values('" + ID + "'," + getSecurityId("专家修改") + ")"); } if ((expert_del!=null) && expert_del.equals("1")) { dbHandle.execUpdateSQL("insert into role(groupid,privid)values('" + ID + "'," + getSecurityId("专家删除") + ")"); } if ((project_new!=null) && project_new.equals("1")) { dbHandle.execUpdateSQL("insert into role(groupid,privid)values('" + ID + "'," + getSecurityId("项目新增") + ")"); } if ((project_update!=null) && project_update.equals("1")) { dbHandle.execUpdateSQL("insert into role(groupid,privid)values('" + ID + "'," + getSecurityId("项目修改") + ")"); } if ((project_del!=null) && project_del.equals("1")) { dbHandle.execUpdateSQL("insert into role(groupid,privid)values('" + ID + "'," + getSecurityId("项目删除") + ")"); } if ((expert_query!=null) && expert_query.equals("1")) { dbHandle.execUpdateSQL("insert into role(groupid,privid)values('" + ID + "'," + getSecurityId("专家抽取") + ")"); } if ((expert_auditing!=null) && expert_auditing.equals("1")) { dbHandle.execUpdateSQL("insert into role(groupid,privid)values('" + ID + "'," + getSecurityId("专家评审") + ")"); } dbHandle.freeConnection(); response.sendRedirect("../SystemSet/UserGroupManage/index.jsp"); } } void doDel(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String[] s = request.getParameterValues("delID"); DB_Handle dbHandle = new DB_Handle(); dbHandle.connectionDatabase(); for (int i = 0; i < s.length; i++) { dbHandle.execUpdateSQL("delete from usergroup where id = " + s[i]); } dbHandle.freeConnection(); response.sendRedirect("../SystemSet/UserGroupManage/index.jsp"); } void doUpdate(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String id = request.getParameter("id"); String userName = String_Handle.unescape_GB2312(request .getParameter("userName")); DB_Handle dbHandle = new DB_Handle(); dbHandle.connectionDatabase(); dbHandle.execUpdateSQL("update usergroup set groupname = '" + userName+ "' where id = " + id); dbHandle.freeConnection(); response.sendRedirect("../SystemSet/UserGroupManage/index.jsp"); } /** * Initialization of the servlet. <br> * * @throws ServletException if an error occurs */ public void init() throws ServletException { // Put your code here } }