本文共 3245 字,大约阅读时间需要 10 分钟。
相关知识(略)
效果图如下(无需给表单添加样式):
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>Insert title here
student表数据如图:
javabean结构如图:
相关知识(略)
编程要求
success.jsp代码:
fail.jsp代码:
测试说明
测试输入:张五 123456;预期输出:
测试输入:张三 123456;
预期输出:
开始你的任务吧,祝你成功!
package chapter9;import java.io.IOException;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import javax.servlet.http.HttpSession;public class LoginServlet extends HttpServlet { /** * */ private static final long serialVersionUID = 1L; @Override protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { doGet(req, resp); } @Override public void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { /********* Begin *********/ Connection conn ; PreparedStatement st ; ResultSet rs=null; String userName = req.getParameter("userName"); String password = req.getParameter("password"); try{ Class.forName("com.mysql.jdbc.Driver"); String url="jdbc:mysql://127.0.0.1:3306/university?user=root&password=123123"; conn=DriverManager.getConnection(url); String sql = "select * from student" + " where USER_NAME = ? and PASSWORD = ?";//预编译 st= conn.prepareStatement(sql); st.setString(1,userName); st.setString(2,password); rs = st.executeQuery(); } catch (Exception e){ e.printStackTrace(); } StudentBean studentbean=new StudentBean(); studentbean.setUserName(userName); studentbean.setPassword(password); HttpSession session = req.getSession(); try { if (rs.next()){ studentbean.setStudentId(rs.getInt(1)); studentbean.setSex(rs.getString(4)); studentbean.setAge(rs.getInt(5)); studentbean.setDept(rs.getString(6)); session.setAttribute("account",studentbean); resp.sendRedirect("success.jsp"); }else{ session.setAttribute("account",studentbean); resp.sendRedirect("fail.jsp"); } } catch (Exception e) { e.printStackTrace(); } /********* End *********/ }}
【睡觉去了,不行了,熬不下去了~】
“人生总有那么一段大片大片空白的时光。你在等待,你在坚忍,你在静默。你在等一场春华秋实,你在等新一轮的春暖花开,你在等从未有过的雷霆万钧。这静默的日子有些长,有些闷,但是我也会等下去。我相信人的青春不只有一次,有时候,时光会给你额外的惊喜。”
转载地址:http://ufcki.baihongyu.com/