📄 user_add_deal.jsp
字号:
<%@ 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 + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -