login.jsp
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="https://bbs.csdn.net/topics/">
<title>My JSP 'p126login.jsp' starting page</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="https://bbs.csdn.net/topics/styles.css">
-->
</head>
<body>
<h1>登錄界面</h1><br>
<from action="p127login_judge.jsp"method="post">
登錄賬號：<input type="text"name="userid"><br>
登錄密碼：<input type="password"name="userpass"><br>
<input type="submit"name="submit"value="https://bbs.csdn.net/topics/登陸"><br>
</from>
</body>
</html>
login_judge.jsp
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="https://bbs.csdn.net/topics/">
<title>My JSP 'p115registerok.jsp' starting page</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="https://bbs.csdn.net/topics/styles.css">
-->
</head>
<body>
<%@page import="java.sql.*"%>
<% Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
String url="jdbc:sqlserver://localhost:1433;DatabaseName=admin";
Connection conn=DriverManager.getConnection(url,"news","123456");%>
<%
request.setCharacterEncoding("utf-8");
String userid=request.getParameter("userid");
String userpass=request.getParameter("userpass");
String sql="select*from admin.dbo.test where userid=?and userpass=?";
PreparedStatement pstm=conn.prepareStatement(sql);
pstm.setString(1,userid);
pstm.setString(2,userpass);
ResultSet rs=pstm.executeQuery();
if(rs.next()){
session.setAttribute("username",rs.getString("username"));
response.sendRedirect("p127login_success.jsp");
}
else{
out.print("錯了老弟");
response.setHeader("Refresh", "1;url=p115register.jsp");
}
%>
</body>
</html>
代碼應該沒問題啊，不知道是哪里錯了 ，希望有大佬看看
轉載請註明出處，本文鏈接：https://www.uj5u.com/qianduan/127876.html
標籤：JavaScript
上一篇：大佬們給給寫網頁專案的建議啊！！