jsp注册登录代码 jsp注册登录
程序员文章站
2022-04-28 17:36:18
...
login.jsp(a.jsp) <form action="b.jsp" method="post"> username:<input type="text" name="username"/> </br> </br> password:<input type="text" name="password" /> </br> </br> <input type="submit" value="submit"/> </form>
dologin.jsp(b.jsp) <%@page import="java.sql.*"%> <% String yname=request.getParameter("username"); String ypass=request.getParameter("password"); String sname=""; %> <% String RL = "jdbc:mysql://192.168.139.215:3306/zhuce?useUnicode=true&characterEncoding=utf-8&user=root&password=zouhuiying"; try { Class.forName("com.mysql.jdbc.Driver"); ResultSet rs = null; String sqlpass=""; String sqlname=""; Connection con = DriverManager.getConnection(RL); Statement st = con.createStatement(); String sql1="select * from users where name='"+yname+"'"; rs = st.executeQuery(sql1); while (rs.next()) { sqlname=(rs.getString("name"));//getInt sqlpass=(rs.getString("pass")); } if (sqlname.equals("")&&yname!=null){ out.println(yname); String sqlStr="insert into users(name,pass) values('"+yname+"','"+ypass+"')"; PreparedStatement pre = con.prepareStatement(sqlStr); pre.executeUpdate(); }else if(sqlpass.equals(ypass)){ request.getSession().setAttribute("sname",sqlname); response.sendRedirect("friends.jsp"); }else{ response.sendRedirect("a.jsp"); } st.close(); rs.close(); } catch (Exception e2) { out.println(e2); } %>
friends.jsp <%@page import="java.sql.*"%> <% String myname=""; %> <% myname=(String)request.getSession().getAttribute("sname"); %> <% String RL = "jdbc:mysql://192.168.139.215:3306/zhuce?useUnicode=true&characterEncoding=utf-8&user=root&password=zouhuiying"; Connection con=null; PreparedStatement st=null; ResultSet rs = null; String sql="select * from lianxi where lianxi.mname='"+myname+"'"; String sqlpass=""; String sqlname=""; try { Class.forName("com.mysql.jdbc.Driver"); con = DriverManager.getConnection(RL); st = con.prepareStatement(sql); rs = st.executeQuery(); while (rs.next()) { sqlname=(rs.getString("yname")); out.println(sqlname);//getInt out.println("</br>"); } } catch (Exception e2) { out.println(e2); }finally { try { rs.close(); con.close(); st.close(); } catch (Exception e) { // TODO: handle exception e.printStackTrace(); } } %> </br> <input type="text" name="my" id="my"/> <button onclick="location.href='c.jsp?sname='+document.getElementById('my').value">The query</button>
querry.jsp(c.jsp) <%@page import="java.sql.*"%> <%@page import="java.util.*"%> <!--% myname=(String)request.getSession().getAttribute("sname"); %--> <%String myname=request.getParameter("sname");%> <% String RL = "jdbc:mysql://192.168.139.215:3306/zhuce?useUnicode=true&characterEncoding=utf-8&user=root&password=zouhuiying"; String newname=""; Connection con=null; PreparedStatement st=null; ResultSet rs = null; String sql="select name from users where name like '"+myname+"%'"; String sqlmname=""; String sqlyname=""; try { Class.forName("com.mysql.jdbc.Driver"); con = DriverManager.getConnection(RL); st = con.prepareStatement(sql); rs = st.executeQuery(); while (rs.next()) { sqlmname=(rs.getString("name")); out.println(sqlmname); out.println("<button onclick="+"location.href='add.jsp?newname="+sqlmname+"'>add</button>"); out.println("</br>"); } } catch (Exception e2) { System.out.println(e2); }finally { try { rs.close(); con.close(); st.close(); } catch (Exception e) { // TODO: handle exception e.printStackTrace(); } } %>
add.jsp <%@page import="java.sql.*"%> <%String newname=request.getParameter("newname");%> <% String myname=(String)request.getSession().getAttribute("sname"); %> <%out.println(newname);%> <%out.println(myname);%> <% String yname=request.getParameter("username"); String ypass=request.getParameter("password"); String sname=""; Connection con=null; Statement st = null; PreparedStatement pre=null; %> <% String RL = "jdbc:mysql://192.168.139.215:3306/zhuce?useUnicode=true&characterEncoding=utf-8&user=root&password=zouhuiying"; try { Class.forName("com.mysql.jdbc.Driver"); //ResultSet rs = null; String sqlpass=""; String sqlname=""; con = DriverManager.getConnection(RL); st = con.createStatement(); //String sql1="select * from users where name='"+yname+"'"; String sql="insert into lianxi(mname,yname) values('"+myname+"','"+newname+"')"; pre = con.prepareStatement(sql); pre.executeUpdate(); response.sendRedirect("friends.jsp"); } catch (Exception e2) { out.println(e2); }finally { try { con.close(); st.close(); pre.close(); } catch (Exception e) { // TODO: handle exception e.printStackTrace(); } } %>