代码如下
<%@ page language="java" import="java.sql.*" %> String userName = request.getParameter("userName");
String userPwd = request.getParameter("userPwd");
String userAge = request.getParameter("userAge");
String userID = request.getParameter("userID");
<%
String sql = ""; sql = "insert into table_user(";
sql += "userName,userPwd,userAge,userID";
sql += ") values (";
sql += "'" + userName + "',";
sql += "'" + userPwd + "',";
sql += "'" + userAge + "',";
sql += "'" + userID + "'";
sql += ")"; Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager.getConnection("jdbc:odbc:db","","");
Statement stmt = conn.createStatement();
stmt.executeUpdate(sql);
conn.close();
%>
<%@ page language="java" import="java.sql.*" %> String userName = request.getParameter("userName");
String userPwd = request.getParameter("userPwd");
String userAge = request.getParameter("userAge");
String userID = request.getParameter("userID");
<%
String sql = ""; sql = "insert into table_user(";
sql += "userName,userPwd,userAge,userID";
sql += ") values (";
sql += "'" + userName + "',";
sql += "'" + userPwd + "',";
sql += "'" + userAge + "',";
sql += "'" + userID + "'";
sql += ")"; Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager.getConnection("jdbc:odbc:db","","");
Statement stmt = conn.createStatement();
stmt.executeUpdate(sql);
conn.close();
%>
解决方案 »
- JAVA可变参数的方法重载问题
- 网站开发怎么让每页的重复地址保存到一个地址中跳转
- 请教tomcat下集群配置
- java如何修改xml标签里的属性的值
- 如何做出Jsp页面的中国地图啊``
- axis生成wsdl问题,懂axis的高手的帮忙下
- 0.5*Math.log((1+Math.sin(x))/(1-Math.sin(x)))=y 现在知道了y=100 如何求x的值?
- struts连接池问题?
- 急用!急用!(高分!!!!!!!!!!!!!!!!!!!!!!!!!!!!)
- 学习J2EE需要什么环境?
- linux环境下,上传文件的权限问题
- 求助spring定时器 每秒钟扫描查询数据库 执行一段时间后就timer停了???怎么回事啊? ??
<%
String userName = request.getParameter("userName");
String userPwd = request.getParameter("userPwd");
String userAge = request.getParameter("userAge");
String userID = request.getParameter("userID"); String sql = "";
sql = "insert into table_user(";
sql += "userName,userPwd,userAge,userID";
sql += ") values (";
sql += "'" + userName + "',";
sql += "'" + userPwd + "',";
sql += "'" + userAge + "',";
sql += "'" + userID + "'";
sql += ")";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager.getConnection("jdbc:odbc:db","","");
Statement stmt = conn.createStatement();
stmt.executeUpdate(sql);
conn.close();
%>
问题是type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: An exception occurred processing JSP page /register.jsp at line 2219: Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
20: Connection conn = DriverManager.getConnection("jdbc:odbc:db","","");
21: Statement stmt = conn.createStatement();
22: stmt.executeUpdate(sql);
23:
24:
25: conn.close();
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:519)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:410)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
root cause
建议: 在22行之前加个输出, 把sql输出来, 看看,
如果还是没看懂的话, 直接将sql拿到数据库中去执行下试试。'userID'这字段应该是int类型吧,