linux公社资源共享ftp:JSP哪个预编译的还是不行啊.............

来源:百度文库 编辑:高校问答 时间:2024/05/07 08:34:46
jsp文件-----------------------------------

<%@ page import="java.sql.*" %>
<%@ page contentType="text/html;charset=GB2312" %>

<%
String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
String url = "jdbc:odbc:cs";

try
{
Class.forName(driver);
}
catch(Exception e)
{
e.printStackTrace();
}

try
{

Connection con = DriverManager.getConnection(url);
PreparedStatement psmt = con.prepareStatement("UPDATE worker"
+"set phone='?',addr='?'"
+"where name='?'");

psmt.setString(1,"1234567");
psmt.setString(2,"Beijing");
psmt.setString(3,"1");
psmt.executeUpdate();

psmt.close();
con.close();

}
catch(Exception e)
{
e.printStackTrace();
}
%>

cs的access文件
表worker

name phone addr
1 1 1
2 2 2

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

我像让where判断name等于1的,修改成电话1234567,地点修改成beijing
数据库表中,确实有name等于1的啊。。

也没有出错信息....可是也没找到什么错误..

麻烦大家不忙时候看看,感激不仅

<%@ page import="java.sql.*" %>
<%@ page contentType="text/html;charset=GB2312" %>

<%
String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
String url = "jdbc:odbc:cs";

try
{
Class.forName(driver);
}
catch(Exception e1)
{
e1.printStackTrace();
}

try
{

Connection con = DriverManager.getConnection(url);
PreparedStatement psmt = con.prepareStatement("UPDATE worker"
+"set phone='?',addr='?'"
+"where name='?'");

psmt.setString(1,"1234567");
psmt.setString(2,"Beijing");
psmt.setString(3,"1");
psmt.executeUpdate();

psmt.close();
con.close();

}
catch(Exception e)
{
out.print(e.toString());
e.printStackTrace();
}
%>
我将你的代码的最后几行改后,在运行网页时,网页上会提示

java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] UPDATE 语句的语法错误

我想错在哪儿你应该可以解决了吧