📄 dealinsert.jsp
字号:
<%@ page contentType="text/html;charset=gb2312" import="java.sql.*"%>
<%-- 防止非法用户直接利用页面的url地址进入 --%>
<%@ include file="checkadmin.jsp"%>
<jsp:useBean id="conn" class="dbBean.DBBean" scope="session"/>
<body background= "images/1.bmp">
<%
request.setCharacterEncoding("gb2312");
String name="";
String password="";
String sex="";
String age="0";
String phone="";
String email="";
String address="";
int id=10000;
if(request.getParameter("username")!=null)
name=request.getParameter("username");
if(request.getParameter("password")!=null)
password=request.getParameter("password");
if(request.getParameter("sex")!=null)
sex=request.getParameter("sex");
if(request.getParameter("age")!=null && !(request.getParameter("age").equals("")))
age=request.getParameter("age");
if(request.getParameter("phone")!=null)
phone=request.getParameter("phone");
if(request.getParameter("email")!=null)
email=request.getParameter("email");
if(request.getParameter("address")!=null)
address=request.getParameter("address");
ResultSet rs=null;
//查找当前用户最大的id号
rs = conn.executeQuery("select max(id) from user");
if(rs.next())
id=rs.getInt(1);
//在最大号的基础上加1,作主新添加用户的id
id++;
rs.close();
String sql="insert into user values("+id+",'"+name+"','"+password+"','"+sex+"',"+age+",'"+phone+"','"+email+"','"+address+"')";
conn.executeUpdate(sql);
conn.close();
out.println("添加用户成功!");
out.println("<a href='right.jsp'>返回查询页面</a>");
response.setHeader("Refresh","1;URL=right.jsp");
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -