loginServlet.java
package servlet;
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.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
@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 = "123456";
String name = "root";
try {
con = DriverManager.getConnection(url, name, pass);// 连接数据库
} catch (SQLException e) {
e.printStackTrace();
}
PreparedStatement ps = null;
ResultSet rs=null;
String sql="";
if(con!=null) {
sql="select sname,pass from userinfo where sname=? and pass=?";
try {
ps= con.prepareStatement(sql);
ps.setString(1, stuName);
ps.setString(2, stuPass);
} catch (SQLException e) {
e.printStackTrace();
}
try {
rs=ps.executeQuery();
} catch (SQLException e) {
e.printStackTrace();
}
try {
if (rs.next()) {
request.getRequestDispatcher("log.jsp").forward(request, response);
} else {
request.getRequestDispatcher("error.jsp").forward(request, response);
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
doGet(request, response);
}
}
registerServlet.java
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="123456";
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 userinfo 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();
}
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);
}
}
UserInfo.java
package model;
public class UserInfo {
String name;
String password;
String number;
String sex;
public String getSex() {
return sex;
}
public void setSex(String sex) {
this.sex = sex;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public String getNumber() {
return number;
}
public void setNumber(String number) {
this.number = number;
}
}
log.jsp
<%@ page language=“java” contentType=“text/html; charset=UTF-8”
pageEncoding=“UTF-8”%>
<%@ page language=“java” import=“java.sql.Connection” %>
<%@ page language=“java” import=“java.sql.Statement” %>
<%@ page language=“java” import=“java.sql.ResultSet” %>
<%@ page language=“java” import=“java.sql.DriverManager” %>
<%@ page language=“java” import=“java.sql.SQLException” %>
你好,欢迎<%=session.getAttribute("name") %>登入学生管理系统!
<% Connection con=null; Statement sql=null; ResultSet rs=null; String url="jdbc:mysql://localhost:3306/student1"; String pass="123456"; String name="root"; try { con=DriverManager.getConnection(url,name,pass);//连接数据库 } catch (SQLException e) {e.printStackTrace();
}
try {
sql = (Statement) con.createStatement();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
rs=sql.executeQuery(“select * from userinfo”);
while(rs.next()){
String name1=rs.getString(1);
String pass1=rs.getString(2);
String sex=rs.getString(3);
String num=rs.getString(4);
out.print(name1);out.print(" “);
out.print(pass1);out.print(” “);
out.print(sex);out.print(” “);
out.println(num);out.print(” ");
%>
姓名:<%=name1 %>
密码:<%=pass1 %>
性别:<%=sex %>
学号:<%=num %>
<% }
%>
<% con.close();%>
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}
欢迎登入学生管理系统!
register.jsp
<%@ page language=“java” contentType=“text/html; charset=UTF-8”
pageEncoding=“UTF-8”%>
注册学生信息
hello.jsp
<%@ page language=“java” contentType=“text/html; charset=UTF-8”
pageEncoding=“UTF-8”%>
注册成功!
hello.jsp
<%@ page language=“java” contentType=“text/html; charset=UTF-8”
pageEncoding=“UTF-8”%>
对不起,你输入的用户名或者密码不正确!请输入正确的信息。
以下是连接数据库的代码:
以下是登入验证用户名和密码的代码:
以下是注册把数据村粗在数据库里的代码: