淘宝主图视频拍摄方法:jsp+access的问题,高手请进

来源：百度文库编辑：高校问答时间：2024/05/08 17:20:06

我想向表中插入一条记录,请各位帮我看看哪里错了
<%@ page contentType="text/html; charset="GB2312" language="java" import="java.sql.*;" %>
<html>
<head>
<meta-equiv="Content-Type" content="text/html; charset=gb2312">
<title>提交</title>
</head>
<body>
<%! String sql; %>
<%
String name=request.getParameter("username").trim();
name=new String(name.getBytes("ISO8859_1"),"GBK");

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:may");
Statement stmt=con.createStatement();
sql="insert into 表1(username)";
sql=sql+"values('"+name+"');
stmt.executeUpdate(sql);
stmt.close;
conn.close;
%>
</body>
</html>

错误显示
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: /6.jsp(1,49) equal symbol expected
org.apache.jasper.compiler.DefaultErrorHandler.jspError(DefaultErrorHandler.java:39)
org.apache.jasper.compiler.ErrorDispatcher.dispatch(ErrorDispatcher.java:409)
org.apache.jasper.compiler.ErrorDispatcher.jspError(ErrorDispatcher.java:90)
org.apache.jasper.compiler.Parser.parseAttribute(Parser.java:193)
org.apache.jasper.compiler.Parser.parseAttributes(Parser.java:143)
org.apache.jasper.compiler.Parser.parseAttributes(Parser.java:156)
org.apache.jasper.compiler.ParserController.getPageEncodingForJspSyntax(ParserController.java:452)
org.apache.jasper.compiler.ParserController.determineSyntaxAndEncoding(ParserController.java:386)
org.apache.jasper.compiler.ParserController.doParse(ParserController.java:170)
org.apache.jasper.compiler.ParserController.parse(ParserController.java:101)
org.apache.jasper.compiler.Compiler.generateJava(Compiler.java:203)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:470)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:451)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:439)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:511)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:295)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

note The full stack trace of the root cause is available in the Apache Tomcat/5.0.28 logs.

--------------------------------------------------------------------------------

Apache Tomcat/5.0.28
另外, .trim()是什么,有什么用

1. 这两句话有问题
sql="insert into 表1(username)";
sql=sql+"values('"+name+"');
SQL语句关键字之间要有空格的。还少了结束的引号。
sql="insert into 表1 (username) ";
sql=sql+" values('"+name+"')";

2.trim()表示去除字符串首尾空格。

jsp+access的问题,高手请进 jsp+access的问题,高手请进 jsp access数据库的连接问题高手帮忙 Access IBM的问题!高手请进! 关于access 问题高手请进~! jsp连接access的路径问题 jsp问题和access jsp连接access问题 ASP+ACCESS的多表查询问题（高手请进） vb连接access数据库的字符串问题（高手请进）