java调用sql语句???(Access)
public void stuDel(String num)
{
Database DB=new Database();
this.sNum=num;
sql="delete from Student1 where Snum >"sNum"";
try
{
DB.OpenCon();
DB.excuteUpdate(sql);
JOptionPane.showMessageDialog(null, "成功删除");
}
catch(Exception e)
{
System.out.println(e);
JOptionPane.showMessageDialog(null, "删除失败", "错误",
JOptionPane.ERROR_MESSAGE);
}
finally
{
DB.closeConn();
DB.closeStmt();
}
}
我用上面语句对access数据库数据进行删除,但是执行过后 到Access中看 此数据还是在????为什么啊??说标准表达式中数据型不匹配????
急!!
sql="delete from Student1 where Snum >'sNum'";
Java code:
sql="delete from Student1 where Snum >"sNum"";
改成.
sql="delete from Student1 where Snum >'"+ sNum+"'";
=================================================
finally { DB.closeConn(); DB.c
相关问答:
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jas ......
我想用Java写一个程序,就是我想在运行代码后,在指定的时间打开某程序,例如我运行代码后,讲在12:00打开"D:\Program Files\Tencent\QQ2009\Bin\QQ.exe"这个程序,求高人指点。还有可能的话在指定的时间 ......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
<html><head><title>[@title]</title>
<meta http-equiv=Content-Type content="text/html; charset=gb2312">
<script language='javascript'>
function diyCheck ......