📄 zhuce.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %><%@ page import="java.net.*"%><%@ page pageEncoding="UTF-8"%><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><jsp:useBean id="db_conn" scope="page" class="user.DB"/><html xmlns="http://www.w3.org/1999/xhtml"><head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <script language="JavaScript" type="text/javascript" > //Gets the browser specific XmlHttpRequest Object function getXmlHttpRequestObject() { if (window.XMLHttpRequest) { return new XMLHttpRequest(); } else if(window.ActiveXObject) { return new ActiveXObject("Microsoft.XMLHTTP"); } else { alert("Your Browser Sucks!\nIt's about time to upgrade don't you think?"); } } function createAjaxObj(){ var httprequest=false if (window.XMLHttpRequest) { // if Mozilla, Safari etc httprequest=new XMLHttpRequest() if (httprequest.overrideMimeType) httprequest.overrideMimeType('text/xml') } else if (window.ActiveXObject) { // if IE try { httprequest=new ActiveXObject("Msxml2.XMLHTTP"); } catch (e){ try{ httprequest=new ActiveXObject("Microsoft.XMLHTTP"); } catch (e){} } } return httprequest } //Our XmlHttpRequest object to get the auto suggest var searchReq = createAjaxObj(); //Called from keyup on the search textbox. //Starts the AJAX request. function searchSuggest() { if (searchReq.readyState == 4 || searchReq.readyState == 0) { var str =document.getElementById('zhuce_name').value; str=encodeURI(str); var url = "checkName.jsp?search="+str; searchReq.open("GET", url, true); searchReq.setRequestHeader( "Content-Type", "text/html;charset=UTF-8" ); searchReq.onreadystatechange = handleSearchSuggest; searchReq.send(null); } } //Called when the AJAX response is returned. function handleSearchSuggest() { if (searchReq.readyState == 4) { var ss = document.getElementById('search_suggest'); var str = unescape(searchReq.responseText); ss.innerHTML=""; var str = searchReq.responseText; ss.innerHTML=str; } } </script><title>注册</title><style type="text/css"><!--.STYLE1 { font-family: "宋体"; font-size: 16px;}.STYLE2 {font-size: 16px}.STYLE3 {font-size: 16}#form1 .STYLE3 { font-size: 16px;}--></style></head><body><%Connection conn=db_conn.getConnection();Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);String userName=null;String userPwd=null;int Maxid=0;//把兴趣写入数据库 Object ob_name=session.getAttribute("userName");//从会话中取得用户 if(ob_name!=null) { userName=ob_name.toString(); out.print(userName); } if(userName==null) { if( request.getParameter("zhuce_name")!=null && !request.getParameter("zhuce_name").equals("")) { String zhuce_name=null; String zhuce_Pwd=null; String zhuce_check_pwd=null; String love[]=new String[12]; zhuce_name =request.getParameter("zhuce_name"); zhuce_name = new String(zhuce_name.getBytes("ISO8859-1")); zhuce_Pwd = request.getParameter("zhuce_Pwd"); zhuce_Pwd = new String(zhuce_Pwd.getBytes("ISO8859-1")); zhuce_check_pwd = request.getParameter("zhuce_check_pwd"); zhuce_check_pwd = new String(zhuce_check_pwd.getBytes("ISO8859-1")); love[0] = request.getParameter("love1"); love[1] = request.getParameter("love2"); love[2] = request.getParameter("love3"); love[3] = request.getParameter("love4"); love[4] = request.getParameter("like1"); love[5] = request.getParameter("like2"); love[6] = request.getParameter("like3"); love[7] = request.getParameter("like4"); love[8] = request.getParameter("like5"); love[9] = request.getParameter("like6"); love[10] = request.getParameter("like7"); love[11] = request.getParameter("like8"); for(int i=0;i<12;i++)//转换编码，使之能显示汉字 { if(love[i]!=null) { love[i] = new String(love[i].getBytes("ISO8859-1")); } } String check_user="select * from yonghu where userName='"+zhuce_name+"'"; ResultSet check_user_rs=stmt.executeQuery(check_user); if(check_user_rs.next())//检查用户输入的用户名是否已经被别人使用 { out.print("该用户已经存在，请用其他的名字注册"+"<br>"); } else { out.print("您可以使用这个用户名："+zhuce_name+"<br>"); if(!zhuce_Pwd.equalsIgnoreCase("") && zhuce_Pwd.equalsIgnoreCase(zhuce_check_pwd))//检验两次输入的密码是否相同 把用户添入的信息写进数据库 并写入会话 { userName=zhuce_name; String maxsql="select top 1 ID from yonghu order by ID desc"; ResultSet maxrs=stmt.executeQuery(maxsql); if(maxrs.next()) { Maxid=maxrs.getInt("ID")+1; } else { Maxid=1; } String loveSum=""; for(int i=0;i<love.length;i++) { if(love[i]!=null && !love[i].equalsIgnoreCase("")) { String insql="insert into userlove(userID,love,times,type) values("+Maxid+",'"+love[i]+"',0,1)" ; stmt.execute(insql); loveSum=loveSum+"/"+love[i]; } } out.print("你的兴趣是："+loveSum+"<br>"); String insql="insert into yonghu(ID,userName,userPwd) values("+Maxid+",'"+zhuce_name+"','"+zhuce_Pwd+"')" ; //Maxid++; stmt.execute(insql); } else { out.print("确认密码不相同"+"<br>"); } } } }%><% if(userName==null){%><form id="form1" name="form1" method="post" action="zhuce.jsp"> <p> </p> <table width="340" height="565" border="1" align="center"> <tr> <td height="38" align="center"><span class="STYLE1">用户注册</span></td> </tr> <tr> <td height="144" align="center"><table width="298" height="127" border="1"> <tr> <td width="88" align="right" valign="middle">用户名：</td> <td width="194" align="left" valign="middle"><label> <input name="zhuce_name" type="text" id="zhuce_name" onchange="searchSuggest();"/><div id="search_suggest"> </div> </label></td> </tr> <tr> <td align="right" valign="middle">密码：</td> <td align="left" valign="middle"><label> <input name="zhuce_Pwd" type="password" id="zhuce_Pwd" /> </label></td> </tr> <tr> <td height="30" align="right" valign="middle">确认密码：</td> <td align="left" valign="middle"><label> <input name="zhuce_check_pwd" type="password" id="zhuce_check_pwd" /> </label></td> </tr> </table></td> </tr> <tr> <td height="150" align="center" valign="middle"><table width="297" height="130" border="1"> <tr> <td width="81" align="right" valign="middle">兴趣:</td> <td width="183" align="left" valign="middle"><label> <input name="love1" type="text" id="love1" /> </label></td> </tr> <tr> <td align="right" valign="middle">兴趣：</td> <td align="left" valign="middle"><label> <input name="love2" type="text" id="love2" /> </label></td> </tr> <tr> <td align="right" valign="middle">兴趣：</td> <td align="left" valign="middle"><label> <input name="love3" type="text" id="love3" /> </label></td> </tr> <tr> <td align="right" valign="middle">兴趣：</td> <td align="left" valign="middle"><label> <input name="love4" type="text" id="love4" /> </label></td> </tr> </table></td> </tr> <tr> <td height="154" align="center" valign="middle"><table width="301" height="139" border="1" align="center"> <tr> <td width="30" align="right" valign="middle"><label> <input name="like1" type="checkbox" id="数据库" value="数据库" /> </label></td> <td width="96" align="left" valign="middle"><span class="STYLE2">数据库</span></td> <td width="37" align="right" valign="middle"><label> <input type="checkbox" name="like2" value="网络" /> </label></td> <td width="110" align="left" valign="middle"><span class="STYLE2">网络</span></td> </tr> <tr> <td align="right" valign="middle"><label> <input type="checkbox" name="like3" value="机器学习" /> </label></td> <td align="left" valign="middle"><span class="STYLE3">机器学习</span></td> <td align="right" valign="middle"><label> <input type="checkbox" name="like4" value="人工智能" /> </label></td> <td align="left" valign="middle"><span class="STYLE2">人工智能</span></td> </tr> <tr> <td align="right" valign="middle"><label> <input type="checkbox" name="like5" value="并行计算" /> </label></td> <td align="left" valign="middle"><span class="STYLE2">并行计算</span></td> <td align="right"><label> <input type="checkbox" name="like6" value="模式识别" /> </label></td> <td align="left"><span class="STYLE2">模式识别</span></td> </tr> <tr> <td align="right" valign="middle"><label> <input type="checkbox" name="like7" value="软件复用" /> </label></td> <td align="left" valign="middle"><span class="STYLE2">软件复用</span></td> <td align="right" valign="middle"><label> <input type="checkbox" name="like8" value="安全" /> </label></td> <td align="left" valign="middle"><span class="STYLE2">安全</span></td> </tr> </table></td> </tr> <tr> <td height="32" align="center" valign="middle"><label> <input type="submit" name="Submit" value="提交" /> <input type="reset" name="Submit2" value="重置" /> </label></td> </tr> <tr> <td align="center" valign="middle"><a href="index.jsp" class="STYLE2">回到首页</a></td> </tr> </table> <p> </p> <p> </p> <p> </p></form><% }else{ // String user_ID=(Maxid).toString(); out.println("您已经注册成功!"+"<br>"); session.setAttribute("userName",userName);//写入会话 session.setAttribute("userID",Integer.toString(Maxid)); %> <a href="index.jsp" class="STYLE2">回到首页</a><%}%> <p> </p></body></html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -