做了一个注册的页面,servlet跳转jsp出现空白页面,也不报错,求大神指导一下
package jdbc01;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.servlet.RequestDispatcher;
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("/jee04")
public class jee04 extends HttpServlet {
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String Keyword =request.getParameter("keyword");
try {
Class.forName("com.mysql.jdbc.Driver");
Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/jdbc_test_db","root","123456");
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select * from t_student");
String result=null;
while(rs.next()){
String stuName=rs.getString("STU_NAME");
if(Keyword.equalsIgnoreCase(stuName)){
Student student = new Student(rs.getInt("ID"),rs.getString("STU_NAME"),rs.getInt("STU_AGE"),rs.getString("STU_GENDER"),rs.getString("STU_MAJOR"));
break;
}
}
Student stu = new Student(rs.getInt("ID"),rs.getString("STU_NAME"),rs.getInt("STU_AGE"),rs.getString("STU_GENDER"),rs.getString("STU_MAJOR"));
request.setAttribute("student", stu);
RequestDispatcher dipactch =request.getRequestDispatcher("/WEB_INF/Result.jsp");
dipactch.forward(request,response);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
Result.jsp文件
Student.java文件
register.html文件
MySQL的t_student表