user_add_deal.jsp

来自「这是我老师布置一个学习任务:保险管理系统 」· JSP 代码 · 共 55 行

JSP
55
字号
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<jsp:useBean id="connDB" scope="page" class="beans.connDB"/>

<html>
 <head>
  <title>更新数据库</title>
  <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
 </head>
 <body bgcolor="#5555AA" background="pictures/background.jpg">
<jsp:include page="top.jsp"/>
   <% 
      String user_name=request.getParameter("user_name");
      String user_password=request.getParameter("user_password");
      String age=request.getParameter("age");
      String sex=request.getParameter("sex");
      String address=request.getParameter("address");
    
        
       if(user_name==""||user_password=="")
         out.println("<script language='javascript'>alert('请完整输入带*的信息!');window.location.href='user_add.jsp';</script>");
       else{
       try{
          
          ResultSet rs=connDB.executeQuery("SELECT * FROM user where user_name='"+user_name+"'"); 
          if (rs.next()){
       	      out.println("<script language='javascript'>alert('该用户名已经存在,请重新注册!');window.location.href='user_add.jsp';</script>");
           }else{
         
              rs.last();
              String sqll="Insert into user (user_name,user_password,age,sex,address) values('"+user_name+"','"+user_password+"','"+age+"','"+sex+"','"+address+"')";
              connDB.executeUpdate(sqll);
         
               connDB.close();
         
              
            }
        }
        catch(Exception e){
          e.printStackTrace();
        }
      
      }
      
    %>
    
     <tr><font color="88888CC" size="7" align="center">提示:注册成功!</font></tr>
     <tr><a href="user_manage.jsp">返回用户管理页面 </a></tr>
    <tr align="right">
        <td height="100" colspan="3"><img src="pictures\2.jpg" align="middle" width="1000" height="400"> </td>
  </tr>
   
  <jsp:include page="copyright.jsp"/>
 </body>

</html>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?