jsp学生管理信息登入模板

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);
}

}