环卫抗台风先进事迹: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 语句的语法错误
我想错在哪儿你应该可以解决了吧