Quick jdbc question, help needed, thx! - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Java - 爪哇娇娃

Quick jdbc question, help needed, thx!

Quick jdbc question, help needed, thx!# Java - 爪哇娇娃

j*12003-03-23 08:03

1 楼

【以下文字转载自 Complain 讨论区】
发信人: mitbbs (未名空间), 信区: Complain
标题: Re: [投诉]TrustinJesus版主Dignity两天之内狂删我19篇主题帖
发信站: BBS 未名空间站 (Tue Jun 28 02:58:38 2011, 美东)
由于版内炸版，会引起误删。版主可恢复其误删的帖子

s*e2003-03-23 08:03

2 楼

hi, i want to first check whether the table in Access
is empty. if empty, create it, not, delete the data
and add new data. my code is like:
ResultSet rs = stmt.executeQuery("Select * from IBM");
//assume IBM is the table name in database
if(rs.next())
{...delete and add...}
else
{...create...}
My question is: the database is an empty one and when run
the program, java always complain that can not find table
IBM in the 1st sentence. How can i do about it? thanks a lot!!

z*g2003-03-23 08:03

3 楼

add a try catch block.
like this
try
{
// select * from IBM
if(rs.next())
{
//delete and add
}
}
catch()
{
//create table
}

【在 s****e 的大作中提到】

: hi, i want to first check whether the table in Access
: is empty. if empty, create it, not, delete the data
: and add new data. my code is like:
: ResultSet rs = stmt.executeQuery("Select * from IBM");
: //assume IBM is the table name in database
: if(rs.next())
: {...delete and add...}
: else
: {...create...}
: My question is: the database is an empty one and when run