<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ page language="java" import="java.util.*"%>
<%@ page import ="java.sql.*"%>
<html>
<head>
<title>内容收集界面</title>
</head>
<body>
<%--<%--%>
<%-- String name=request.getParameter("name");--%>
<%-- String password=request.getParameter("password");--%>
<%-- if(name.equals("zs")&&password.equals("123")){--%>
<%--%><p>welcome<%=name%></p><%--%>
<%--}else{--%>
<%--%><p>登陆失败</p><%--%>
<%-- }--%>
<%--%>--%>
<%
PreparedStatement pre = null;
Statement sql;
ResultSet rs;
request.setCharacterEncoding("utf-8");
String Name = request.getParameter("name"); //获取输入的用户名
String Ps = request.getParameter("password"); // 密码
Name.trim();
Ps.trim();
request.setCharacterEncoding("utf-8");
Class.forName("com.mysql.cj.jdbc.Driver");
// 建立连接
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/jsp_db?serverTimezone=GMT", "root", "135790");
sql =conn.createStatement();
String SQL = "select * from jsp_data where uname=? and upassword=?";
pre=conn.prepareStatement(SQL);
pre.setString(1,Name);
pre.setString(2,Ps);
rs=pre.executeQuery();
if (rs.next()) {
String name = rs.getString(1);
session.setAttribute("name",name);
%><p>欢迎登陆：<%=name%></p><%
}else{%> <p>输入错误，请重新登录</p><a href="index.jsp"><button>返回登录界面</button></a>
<%
}
rs.close();
sql.close();
conn.close();
%>
</body>
</html>
<%@page import="java.nio.channels.SeekableByteChannel"%>
<%@ page language="java" contentType="text/html" pageEncoding="UTF-8"%>
<%@ page import="java.sql.*"%>
<html>
<head>
<title>www.school.com</title>
</head>
<body>
<%!public static final String DBDRIVER = "com.mysql.jdbc.Driver";
public static final String DBURL = "jdbc:mysql://localhost:3306/jspwork";
public static final String DBUSER = "root";
public static final String DBPASS = "root";%>
<%
Connection conn = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
boolean flag = false;
String name = null;
%>
<%
try {
Class.forName(DBDRIVER);
conn = DriverManager.getConnection(DBURL, DBUSER, DBPASS);
String sql = "SELECT uname FROM num_one WHERE uid=? AND upwd=?";
pstmt = conn.prepareStatement(sql);
pstmt.setString(1, request.getParameter("id"));
pstmt.setString(2, request.getParameter("password"));
rs = pstmt.executeQuery();
if (rs.next()) {
name = rs.getString(1);
flag = true;
}
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
if (rs != null)
rs.close();
if (pstmt != null)
pstmt.close();
if (conn != null)
conn.close();
if (flag) {
request.getSession().setAttribute("uname",name);
request.getRequestDispatcher("ok.jsp").forward(request,response);
// request.getRequestDispatcher("ok.jsp").forward(request, response);
} else {
response.sendRedirect("no.jsp");
}
} catch (Exception e) {
e.printStackTrace();
}
}
%>
</body>
</html>
