代码:
<%@ page language="java" contentType="text/html;charset=GBK" import="java.sql.*,java.lang.*"%>
<%
request.setCharacterEncoding("GBK");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
String url="jdbc:odbc:zhang";
System.out.println("789");System.out.println("000");
String friendname=request.getParameter("friendname");
String friendemail=request.getParameter("friendemail");
String friendqq=request.getParameter("friendqq");
String date=request.getParameter("date");
System.out.println("12121212");
String friend="friend";
try
{
Connection con=DriverManager.getConnection(url,"zhang","111111");
Statement mt=con.createStatement();
System.out.println("000");
String sql="INSERT INTO "+friend+"(friendname,friendemail,friendqq,time) VALUES('"+friendname+"','"+friendemail+"','"+friendqq+"',now())";
System.out.println("1111");
ResultSet crs=mt.executeUpdate(sql);
crs.close();
mt.close();
con.close();
response.sendRedirect("address.jsp");
}catch(Exception e)
{
e.printStackTrace();
System.out.println("在用户登陆时出现错误!");
}
%>错误提示:HTTP Status 500 -
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: Unable to compile class for JSPAn error occurred at line: 2 in the jsp file: /addfriend.jspGenerated servlet error:
[javac] Compiling 1 source fileC:\Program Files\Apache Software Foundation\Tomcat 5.0\work\Catalina\localhost\mytest\org\apache\jsp\addfriend_jsp.java:64: incompatible types
found : int
required: java.sql.ResultSet
ResultSet crs=mt.executeUpdate(sql);
^
1 error
org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:127)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:351)
org.apache.jasper.compiler.Compiler.generateClass(Compiler.java:415)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:458)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:439)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:552)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:291)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
note The full stack trace of the root cause is available in the Tomcat logs.
Apache Tomcat/5.0.16
<%@ page language="java" contentType="text/html;charset=GBK" import="java.sql.*,java.lang.*"%>
<%
request.setCharacterEncoding("GBK");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
String url="jdbc:odbc:zhang";
System.out.println("789");System.out.println("000");
String friendname=request.getParameter("friendname");
String friendemail=request.getParameter("friendemail");
String friendqq=request.getParameter("friendqq");
String date=request.getParameter("date");
System.out.println("12121212");
String friend="friend";
try
{
Connection con=DriverManager.getConnection(url,"zhang","111111");
Statement mt=con.createStatement();
System.out.println("000");
String sql="INSERT INTO "+friend+"(friendname,friendemail,friendqq,time) VALUES('"+friendname+"','"+friendemail+"','"+friendqq+"',now())";
System.out.println("1111");
ResultSet crs=mt.executeUpdate(sql);
crs.close();
mt.close();
con.close();
response.sendRedirect("address.jsp");
}catch(Exception e)
{
e.printStackTrace();
System.out.println("在用户登陆时出现错误!");
}
%>错误提示:HTTP Status 500 -
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: Unable to compile class for JSPAn error occurred at line: 2 in the jsp file: /addfriend.jspGenerated servlet error:
[javac] Compiling 1 source fileC:\Program Files\Apache Software Foundation\Tomcat 5.0\work\Catalina\localhost\mytest\org\apache\jsp\addfriend_jsp.java:64: incompatible types
found : int
required: java.sql.ResultSet
ResultSet crs=mt.executeUpdate(sql);
^
1 error
org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:127)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:351)
org.apache.jasper.compiler.Compiler.generateClass(Compiler.java:415)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:458)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:439)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:552)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:291)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
note The full stack trace of the root cause is available in the Tomcat logs.
Apache Tomcat/5.0.16
改为mt.executeUpdate(sql);就可以了
执行插入操作不需要返回值,如果要返回值也是int型
还有SQL语句中的获取时间方法是不是用now()??
这个数据库是Access?now()是mysql的获取时间的方法
Access获取时间的方法自己查一下
java.sql.SQLException:[Microsoft][ODBC Microsoft Access Driver]INSERT TNTO 语句的语法错误
可我还是查不出SQL语句错误在那里
还有运行后不能回到address.jsp
请哪位高手指点一下
赐教一下 谢谢
的返回值是int,是所影响的行数你把它给crs当然报错了啊
俺们刚学JSP的不要见怪 为了插入这个时间我头都搞晕了
可不能插入数据
运行后说insert into语句错误
System.out.println(date);好多办法呢
String sql="INSERT INTO "+friend+"(friendname,friendemail,friendqq,time) VALUES('"+friendname+"','"+friendemail+"','"+friendqq+"',date)";
String sql="INSERT INTO "+friend+"(friendname,friendemail,friendqq,time) VALUES('"+friendname+"','"+friendemail+"','"+friendqq+"',date)";
可是报错啊
exception
org.apache.jasper.JasperException: Unable to compile class for JSPAn error occurred at line: 2 in the jsp file: /addfriend.jspGenerated servlet error:
[javac] Compiling 1 source fileC:\Program Files\Apache Software Foundation\Tomcat 5.0\work\Catalina\localhost\mytest\org\apache\jsp\addfriend_jsp.java:57: date is already defined in _jspService(javax.servlet.http.HttpServletRequest,javax.servlet.http.HttpServletResponse)
java.util.Date date=new java.util.Date();
^
1 error
org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:127)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:351)
org.apache.jasper.compiler.Compiler.generateClass(Compiler.java:415)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:458)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:439)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:552)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:291)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
note The full stack trace of the root cause is available in the Tomcat logs.