大虾,帮忙看看一下update语句有没有出错???谢谢!!!!!!!!!try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e) { }
Connection con=DriverManager.getConnection("jdbc:odbc:tushu");
Statement sql=con.createStatement(); //创建Statement对象
ResultSet rs=sql.executeQuery("update 图书 set mc='"+mc+"',"+"lb='"+lb+"',"+"sl='"+sl+"',"+"dj='"+dj+"',"+"je='"+je+"',"+"sj='"+sj+"' where bh='"+bh+"'");
}
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e) { }
Connection con=DriverManager.getConnection("jdbc:odbc:tushu");
Statement sql=con.createStatement(); //创建Statement对象
ResultSet rs=sql.executeQuery("update 图书 set mc='"+mc+"',"+"lb='"+lb+"',"+"sl='"+sl+"',"+"dj='"+dj+"',"+"je='"+je+"',"+"sj='"+sj+"' where bh='"+bh+"'");
}
另外 列名前的"+"用不着 因为除了写变量其他没有隔断字符串的链接ResultSet rs=sql.executeQuery("update 图书 "+
"set mc='"+mc+"',lb='"+lb+"', sl='"+sl+"',dj='"+dj+"',je='"+je+"',sj='"+sj+"' where bh='"+bh+"'");如果这样还不行 lz就在控制台输出一下sql语句放查询分析器执行一下看看~
sql.executeQuery("update 图书 set mc='"+mc+"',lb='"+lb+"',sl='"+sl+"',dj='"+dj+"',je='"+je+"',sj='"+sj+"' where bh='"+bh+"'");
}
不是用int rs=sql.executeUpdate()的吗???