jsp—MySql制作B/s登陆的好例子学习笔记

来源：互联网发布：90后网络歌手有哪些编辑：程序博客网时间：2024/06/04 19:14

建立条件首先一定要确定自己的mysql，tomcat,eclipse连接是正确的。

index.jsp很简单，就一个跳转。

<% response.sendRedirect("lg.jsp");%>

lg.jsp 实现登录框架

<%@ page contentType="text/html; charset=utf-8" %><html><head><title>login</title></head><center>Prease input UserName and Pssword!! </center><body bgcolor="#ffffff"><%String flag=request.getParameter("flag");if(flag!=null&&flag.equals("0")){ out.println("Pls input valid username and password!<br><br>");}%><form name="form1" method="post" action="login.jsp"><center><input name="UserName" type="text" ><br/><input name="Password" type="password"><br/><input name="submit" type="submit" value="submit"><input name="reset" type="reset" value="reset"></center></form></body></html>

<%@ page contentType="text/html;charset=gb2312"%><%@ page import="java.sql.*"%><html><head> <title>用户登陆</title></head><body> <%String UserName=request.getParameter("UserName");String Password=request.getParameter("Password");ResultSet rs=null;Statement stmt=null;Connection con=null;boolean flag=false;try{ //驱动程序名String driverName="com.mysql.jdbc.Driver";//数据库用户名String userName="test";//密码String userPasswd="123456";//数据库名String dbName="along";//表名String tableName="user";String url="jdbc:mysql://localhost/"+dbName+"?user="+userName+"&password="+userPasswd;Class.forName("com.mysql.jdbc.Driver").newInstance();con=DriverManager.getConnection(url);stmt = con.createStatement();String sql="select * from user where UserName='"+UserName+"' and Password='"+Password+"'";System.out.println("login: "+sql);rs = stmt.executeQuery(sql);//System.out.println("rs: "+rs.getString(1)); if(rs!=null&&rs.next()){flag = true;}if(flag){ response.sendRedirect("MyJsp.jsp");}else{ response.sendRedirect("index.jsp?flag=0");}rs.close();}catch(SQLException e){System.out.println("rs: ");}finally{stmt.close();con.close() ;}%> </body></html></html>

MyJsp.jsp

<%@ page contentType="text/html; charset=gb2312" %><%@ page language="java" %><%@ page import="java.sql.*" %><%//驱动程序名String driverName="Com.MySql.Jdbc.Driver";//数据库用户名String userName="test";//密码String userPasswd="123456";//数据库名String dbName="along";//表名String tableName="user";//联结字符串String url="jdbc:mysql://localhost/"+dbName+"?user="+userName+"&password="+userPasswd;Class.forName("com.mysql.jdbc.Driver").newInstance();Connection connection=DriverManager.getConnection(url);Statement statement = connection.createStatement();String sql="SELECT * FROM "+tableName;ResultSet rs = statement.executeQuery(sql); //获得数据结果集合ResultSetMetaData rmeta = rs.getMetaData();//确定数据集的列数，亦字段数int numColumns=rmeta.getColumnCount();// 输出每一个数据值out.print("<center>"); out.print("以下为后台数据"); out.print("UserName"); out.print(" | ");out.print("Password");out.print("<br>");while(rs.next()) {out.print(rs.getString(1)+" "); out.print(" | ");out.print(rs.getString(2));out.print("<br>"); } out.print("<br>");out.print("数据库操作成功，恭喜你!Just so so"); out.print("</center>"); rs.close(); statement.close(); connection.close(); %>

代码中写得很清楚需要建立一个along的数据库，登陆名为test,密码为123465.我也是初学者，自己学习过程中的总结希望对你有用。

jsp—MySql制作B/s登陆的好例子 学习笔记

jsp—MySql制作B/s登陆的好例子学习笔记