Java WebHTTP Status 500 - Unable to compile class for JSP:
<%@ page language="java" contentType="text/html;charset=GBK"%><%@ page import="java.sql.*"%><html><head><title>注册处理页面</title></head><body><%request.setCharacterEncoding("GBK");String name = request.getParameter("userName");String pwd = request.getParameter("pwd");String validatepwd = request.getParameter("validatepwd");if(name == null||name.equals("")){request.setAttribute("message","用户名不能为空");request.getRequestDispatcher("register.jsp").forward(request,response);}else if(pwd == null||pwd.equals("")){request.setAttribute("message","密码不能为空");request.getRequestDispatcher("register.jsp").forward(request,response);}else if(!validatepwd.equals(pwd)){request.setAttribute("message","两次输入的密码不一致");request.getRequestDispatcher("register.jsp").forward(request,response);}int validate = 0;Connection con = null;Statement stmt = null;ResultSet re = null;try{Class.forName("com.mysql.jdbc.Driver");con=DriverManager.getConnection("jdbc:mysql://localhost:3306/db_news?user=root&password=&useUnicode=true&characterEncoding=GBK");stmt = con.createStatement();String str="select max(id) from loguser";int maxid=0;rs = stmt.executeQuery(str);if(rs.next())maxid = rs.getInt(1)+1;//获取新的用户编号String sql ="insert into loguser values("+maxid+",'"+name+"','"+pwd+"')";validate = stmt.executeUpdate(sql);}catch(Exception e){e.printStackTrace();}if(validate > 0){response.sendRedirect("login.jsp");}else{out.println("<font color='red'>出错了!!!</font>");}%></body></html>
MySQL数据存储求高手赐教 代码哪里出问题了
Connection con = null;
Statement stmt = null;
ResultSet re = null; //这里定义的是re
try{
Class.forName("com.mysql.jdbc.Driver");
if(rs.next())
maxid = rs.getInt(1)+1;//获取新的用户编号
写错了，小问题，注意细节
谢谢 已经找到了 不过运行之后又出现新的问题 能不能再帮我看下
乍一看，应该是能执行的，但是代码里面有非常严重的几点错误，一些常识性的问题，比如ID是自增的，不用先从数据库里取，变量进行比较的时候，要先判断是否为空等等