jsp遇到500错误
编码如下
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%><title>Insert title here</title>
<% String driverName="com.mysql.jdbc.Driver"; String userName="root"; String userPwd="123456"; String dbName="students"; String url1="jdbc:mysql://localhost:3306/students"; String url2="?user=root&password=123456"; String url3="&useUnicode=true&characterEncoding=UTF-8"; String url=url1+url2+url3; Class.forName(driverName); Connection conn=DriverManager.getConnection(url); request.setCharacterEncoding("UTF-8"); String sex=request.getParameter("sex"); float weight1=Float.parseFloat(request.getParameter("w1")); float weight2=Float.paraseFloat(request.getParameter("w2")); String sql="select * from stu_info where sex=?and weight>=?and weight<=?"; //利用连接对象建立PreparedStatement对象 PreparedStatement pstmt=conn.prepareStatement(sql); pstmt.setString(1,sex); pstmt.setFloat(2,weight1); pstmt.setFloat(3,weight2); //调用PreparedStatement对象的executeQuery()方法,并返回ResultSet对象 ResultSet rs=pstmt.executeQuery(); //移至最后一条记录 rs.last(); %> 你要查询的学生数据表中公有 <font size="5"color="blue"> <%=rs.getRow() %>人 <table border="2"bgcolor="ccceee"width="650"> <tr bgcolor="CCCCCC"align="center"> 记录条数学号姓名性别年龄体重身高 <%rs.beforeFirst(); //移至第一条记录之前 while(rs.next()){ %> <%=rs.getRow() %> <%=rs.getString("id") %> <%=rs.getString("name") %> <%=rs.getString("sex") %> <%=rs.getString("age") %> <%=rs.getString("weight") %> <%=rs.getString("hight") %> <% } %> <%if(rs!=null){rs.close();} if(pstmt!=null){pstmt.close();} if(conn!=null){conn.close();} %>