register.jsp

<%@ page language=“java” contentType=“text/html; charset=UTF-8” pageEncoding=“UTF-8”%>

学生注册信息页面

注册学生信息

姓名： 密码： 学号： 性别： 男 女

index.jsp

<%@ page language=“java” contentType=“text/html; charset=UTF-8” pageEncoding=“UTF-8”%>

学生管理系统

} #div1{ text-align:center; margin-top:150px

} #div2{ text-align:center; margin-top:30px} #div3{ margin-top:30px} #input1{ margin-left:20px}

欢迎登入学生管理系统！

姓名： 密码：

loginServlet

package servlet;

import java.io.IOException; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException;

import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse;

import com.mysql.jdbc.Statement;

@WebServlet("/loginServlet") public class loginServlet extends HttpServlet { private static final long serialVersionUID = 1L;

public loginServlet() { super(); } protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.getWriter().append("Served at: ").append(request.getContextPath()); request.setCharacterEncoding("utf-8"); response.setCharacterEncoding("utf-8"); String stuName=request.getParameter("name"); String stuPass=request.getParameter("pass"); request.getSession().setAttribute("name",stuName); //连接数据库 Connection con = null; try { Class.forName("com.mysql.jdbc.Driver");//加载数据库驱动 } catch (ClassNotFoundException e1) { e1.printStackTrace(); } String url="jdbc:mysql://localhost:3306/student1"; String pass="13407975741"; String name="root"; try { con=DriverManager.getConnection(url,name,pass);//连接数据库 } catch (SQLException e) { e.printStackTrace(); } Statement sql = null; try { sql = (Statement) con.createStatement(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } ResultSet rs=null; try { rs=sql.executeQuery("select name,password from studentinfo"); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } String name1 = null; String pass1=null; try { while(rs.next()) { name1=rs.getString(1); pass1=rs.getString(2); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } if(stuName.equals(name1)&&stuPass.equals(pass1)) { request.getRequestDispatcher("log.jsp").forward(request, response);request.getRequestDispatcher("log.jsp").forward(request, response); }else { request.getRequestDispatcher("error.jsp").forward(request, response); } } protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("utf-8"); response.setCharacterEncoding("utf-8"); doGet(request, response); }

}

registerServlet

package servlet;

import java.io.IOException; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; import java.util.ArrayList; import java.util.Collection; import java.util.List;

import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse;

import com.mysql.jdbc.PreparedStatement;

@WebServlet("/registerServlet") public class registerServlet extends HttpServlet { private static final long serialVersionUID = 1L;

public registerServlet() { super(); } protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.getWriter().append("Served at: ").append(request.getContextPath()); request.setCharacterEncoding("utf-8"); response.setCharacterEncoding("utf-8"); Connection con = null; try { Class.forName("com.mysql.jdbc.Driver");//加载数据库驱动 } catch (ClassNotFoundException e1) { e1.printStackTrace(); } String url="jdbc:mysql://localhost:3306/student1"; String pass="13407975741"; String name="root"; try { con=DriverManager.getConnection(url,name,pass);//连接数据库 } catch (SQLException e) { e.printStackTrace(); } String stuName=request.getParameter("name"); String stuPass=request.getParameter("pass"); String stuSex=request.getParameter("sex"); String stuNum=request.getParameter("number"); String sql="insert into studentinfo values(?,?,?,?) "; PreparedStatement ps = null; try { ps = (PreparedStatement) con.prepareStatement(sql); } catch (SQLException e) { e.printStackTrace(); } try { ps.setString(1,stuName); ps.setString(2,stuPass); ps.setString(3,stuSex); ps.setString(4,stuNum); ps.executeUpdate(); } catch (SQLException e) { e.printStackTrace(); } //List<String> list=new ArrayList<String>(); //list.addAll((Collection<? extends String>) ps); //request.getSession().setAttribute("info", list); response.sendRedirect("hello.jsp"); } protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("utf-8"); response.setCharacterEncoding("utf-8"); doGet(request, response); }

}