检查登录

最新推荐文章于 2020-12-09 13:39:30 发布

weixin_33836874

最新推荐文章于 2020-12-09 13:39:30 发布

阅读量84

点赞数

原文链接：http://www.cnblogs.com/gjzf/p/5603263.html

版权

checklogin.jsp：检查会员登陆信息实现跳转

<%@ page language="java" contentType="text/html; charset=utf-8"

pageEncoding="utf-8"%>

<%@page import="java.sql.*,java.io.*,java.lang.*"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

</head>

<body>

request.setCharacterEncoding("utf-8");

if(request.getParameter("memberName")!=null)

session.setAttribute("b1",request.getParameter("memberName"));

String m=request.getParameter("memberName");

String p=request.getParameter("password");

String r=request.getParameter("r1");

String DRIVER = "com.microsoft.sqlserver.jdbc.SQLServerDriver";

String USER = "sa";

String PASSWORD = "123456";

String URL = "jdbc:sqlserver://localhost:1433;databaseName=book";

Class.forName(DRIVER);

Connection conn=DriverManager.getConnection(URL, USER, PASSWORD);

Statement stmt=conn.createStatement();

String sql="SELECT * FROM member where memberName='"+m+"'and password='"+p+"' and level= '"+r+"'";

ResultSet rs=stmt.executeQuery(sql);

if(rs.next()&& r.equals("u"))

{ %>

<jsp:forward page="main.jsp">

<jsp:param value="<%=m %>" name="mn"/>

</jsp:forward>

<% } else if(rs.next()&& r.equals("a")) {

<jsp:forward page="Ahome.jsp"/>

<% } else{%>

<jsp:forward page="login.jsp"/>

<% } %>

</body>

</html>

如果信息不正确跳回登录页面login.jsp

如果用户登录信息正确，跳转到好书网首页main.jsp

代码

<%@ page contentType="text/html; charset=utf-8" language="java" import="java.sql.*" errorPage="" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

request.setCharacterEncoding("utf-8");

if(request.getParameter("c1")!=null)

session.setAttribute("s1",request.getParameter("c1"));

String m=request.getParameter("mn");

out.print("你好，"+m+"欢迎你访问好书网");

#apDiv2 {position:absolute;width:1300px;height:79px;z-index:1;left: 15px;top: 120px;

}

#apDiv1 {position:absolute;width:1376px;height:954px;z-index:1;left: 31px;top: 30px;

}

#apDiv3 {position:absolute;width:117px;height:523px;z-index:2;left: 25px;top: 197px;

}

#apDiv4 {position:absolute;width:830px;height:120px;z-index:3;left: 167px;top: 131px;

}

#apDiv5 {position:absolute;width:872px;height:115px;z-index:4;left: 166px;top: 278px;

}

#apDiv6 {position:absolutewidth:240pxheight:184px;z-index:5;left: 1080px;top: 219px;

}

#apDiv7 {position:absolute;width:240px;height:328px;z-index:6left: 1092px;top: 325px;

}

#apDiv8 {position:absolute;width:491px;height:342px;z-index:7;left: 179px;top: 218px;

}

#apDiv9 {position:absolute;width:200px;height:115px;z-index:1;left: 21px;top: 29px;

}

#apDiv10 {position:absolute;width:1303px;height:99px;z-index:1;left: -20px;top: -120px;

}

#apDiv11 {position:absolute;width:1300px;height:79px;z-index:1;left: 10px;top: 18px;

}

#apDiv12 {position:absolute;width:200px;height:75px;z-index:2;left: 1108px;top: -48px;

}

</style>

</head>

<body>

<tr>

<label>

搜索

</label>

</form>

</th>

</tr>

</table>

</div>

</div>

String name;

String intro;

String image;

int inven;

int se;

String DRIVER = "com.microsoft.sqlserver.jdbc.SQLServerDriver";

String USER = "sa";

String PASSWORD = "123456";

String URL = "jdbc:sqlserver://localhost:1433;databaseName=book";

Class.forName(DRIVER);

Connection conn=DriverManager.getConnection(URL, USER, PASSWORD);

Statement stmt=conn.createStatement();

String sql="SELECT * FROM bookinfo";

ResultSet rs=stmt.executeQuery(sql);

while(rs.next())

{

name=rs.getString(2);

intro=rs.getString(3);

inven=rs.getInt(4);

image=rs.getString(5);

se=rs.getInt(7);

<p><img src="<%=image %>" width="102" height="97" alt="<%=name %>" /></p>

<p>

</p>

</form>

<%} %>

</div>

</body>

</html>

转载于:https://www.cnblogs.com/gjzf/p/5603263.html

weixin_33836874

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
检查登录

checklogin.jsp：检查会员登陆信息实现跳转<%@pagelanguage="java"contentType="text/html; charset=utf-8"pageEncoding="utf-8"%><%@pageimport="java.sql.*,java.io.*,java.lang.*"%><!DOCTY...
复制链接

扫一扫