代码如下
<%@ 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();
%>
解决方案 »
- JSF 组件使用问题,为什么我的<h:inputText id="gzlxname"value="#{GzlxJSFBean.currentEO.gzlxname}"/>
- 我写了一个javascript函数在javaweb标签a的onclick事件中调用为什么不执行
- mysql中如何把本地的数据导入到远端服务器的数据库中去?
- 怎么处理struts的form 和hibernate 的entity?
- 数据读取问题
- ★XML的Relax技术是怎么一回事?XML能用它生成?还是校验XML的合法性?
- Struts 中的标签都不能嵌套吗?
- Struts高手请进,很难解决的url定向问题!
- struts中action的效率问题
- Resin3.0.11是免费的吗?Resin和jboss和jonas哪个管理界面完整一些?
- 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类型吧,