以下是程序代码,提示是update语句语法错误
import java.sql.*;public class odgg
{
Connection conn;
Statement sql;
ResultSet rs; public odgg()
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url = "jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ=E:\\jbuilder\\samples\\Welcome\\classes\\db1.mdb";
conn = DriverManager.getConnection(url, "", "");
sql=conn.createStatement();
}catch(Exception e)
{
e.printStackTrace();
}
}public static void main(String[] args)
{
odgg odgg1 = new odgg();
try
{int pp=30;int qq=20;
odgg1.sql.executeUpdate("Update wxltable1 Set number = 450 Where id = 1");
odgg1.sql.close();
odgg1.conn.close() ;
}catch(Exception e)
{
e.printStackTrace();
}
}
}
import java.sql.*;public class odgg
{
Connection conn;
Statement sql;
ResultSet rs; public odgg()
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url = "jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ=E:\\jbuilder\\samples\\Welcome\\classes\\db1.mdb";
conn = DriverManager.getConnection(url, "", "");
sql=conn.createStatement();
}catch(Exception e)
{
e.printStackTrace();
}
}public static void main(String[] args)
{
odgg odgg1 = new odgg();
try
{int pp=30;int qq=20;
odgg1.sql.executeUpdate("Update wxltable1 Set number = 450 Where id = 1");
odgg1.sql.close();
odgg1.conn.close() ;
}catch(Exception e)
{
e.printStackTrace();
}
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货