📄 reg_ok.jsp~8~
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><html><head><meta http-equiv="Content-Type" content="text/html; charset=gb2312"><title>用户注册</title><style type="text/css"><!--body { background-color: #FFFFCC;}--></style></head><body> <jsp:useBean id="format" scope="page" class="photo.StrFormat"/> <jsp:useBean id="dbconn" scope="page" class="photo.DBConnection"/> <p> </p> <p> </p> <p align="center"> <%try{ Connection conn=dbconn.getConnection();//连接数据库 Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); /*获取表单传递过来的注册信息*/ String user_name=request.getParameter("account"); String password=request.getParameter("pwd"); String name=format.StrFormat(request.getParameter("name"));//获取name参数并转化格式，避免出现乱码 String sex=request.getParameter("sex"); if (sex.equals("2")) { sex = "female"; } else { sex = "male"; } String age=request.getParameter("age"); String tel=request.getParameter("tel"); String address=format.StrFormat(request.getParameter("address")); String email=request.getParameter("email"); String sql="insert into users(user_name,password,name,sex,age,tel,address,email) values('"+user_name+"','"+password+"','"+name+"','"+sex+"',"+age+",'"+tel+"','"+address+"','"+email+"')";//插入记录的SQL语句 int i=stmt.executeUpdate(sql); if (i==1) { out.println("恭喜，注册成功！"); response.sendRedirect("index.jsp"); %></p> <div align="center"> <% } else{ out.println("注册时发生错误，请重新注册！"); %> </div> <div align="center"> <%}%> <% stmt.close();conn.close();//关闭数据库链接 } catch(Exception e){e.printStackTrace();} %> </div></body></html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -