最近在写一个程序,需要操作数据库的表之前,先探查是否存在该表否则就建立该表,请问在程序中如何来判断,是用resultset结果集吗?为更形象的表述,我贴一下代码:
Connection con=DriverManager.getConnection(conURL);
Statement s=con.createStatement();
if(VIP表不存在)
{
String r1="create table "+r2+"(" +
"name varchar(20) not null," +
"sex char(1) not null," +
"telephone varchar(20)," +
"officephone varchar(20)," +
"Email varchar(20)," +
"suoying integer primary key)";
s.executeUpdate(r1);
}
求问怎么写试探该VIP表不存在的
Connection con=DriverManager.getConnection(conURL);
Statement s=con.createStatement();
if(VIP表不存在)
{
String r1="create table "+r2+"(" +
"name varchar(20) not null," +
"sex char(1) not null," +
"telephone varchar(20)," +
"officephone varchar(20)," +
"Email varchar(20)," +
"suoying integer primary key)";
s.executeUpdate(r1);
}
求问怎么写试探该VIP表不存在的
解决方案 »
- 全局分页
- Spring MVC 配置文件问题
- 请问如何把一个字符串转换成sqlserver的datetime类型?
- WebLogic 10.3.4新功能:更高效的Gridlink Data Source
- 上传和下载问题
- j2ee项目移植问题
- 运行tomcat5.5时的问题,高手解决下
- struts hibernate分页控制
- 如何将excel中的日期转换成yyyy-MM-dd
- MyEclipse2016 SSH整合,配置文件中出现的符号是什么意思啊?
- Cannot find bean strName in any scope
- quartz如何动态更改执行时间,即在每次repeat的时候时间都在变化
{
Statement stmt = connect.createStatement();
stmt.executeQuery( "select count(*) from yourTable "); }
catch(SQLException e)
{
System.out.print( "not exits "+ e.getMessage());
}
public boolean HasTable(String name) {
//判断某一个表是否存在
boolean result = false;
try {
DatabaseMetaData meta = sqlConn.getMetaData();//sqlConn 数据库连接
ResultSet set = meta.getTables (null, null, name, null);
while (set.next()) {
result = true;
}
} catch (Exception e) {
System.err.println(e);
e.printStackTrace ();
}
return result;
}
ResultSet rs = con.getMetaData().getTables(null, null, "yourTable", null );
if (rs.next()) {
//yourTable exist
}else {
//yourTable not exist
}