Session session = HibernateUtil.getSession();
con = session.connection();
Statement st = null;
String test =
"select COUNT(table_name) from all_tables where table_name='AAA'";
st = con.createStatement();
ResultSet rt = st.executeQuery(test);
rt.next();
int exist = rt.getInt(1);
System.out.println(exist);
rt.close();
if (exist > 0) {
String drop = "drop table aaa";
// st = con.createStatement();
st.executeQuery(drop);
}
String sql = "create table aaa(NAME varchar(20) ,IDNO varchar(50) ,birthday varchar(50) , oldrate number, newrate number, re varchar(100))";
// st = con.createStatement();
st.executeQuery(sql);
st.close();
HibernateUtil.closeSession();上面我注释掉的代码st = con.createStatement();要不要写,有什么区别!
con = session.connection();
Statement st = null;
String test =
"select COUNT(table_name) from all_tables where table_name='AAA'";
st = con.createStatement();
ResultSet rt = st.executeQuery(test);
rt.next();
int exist = rt.getInt(1);
System.out.println(exist);
rt.close();
if (exist > 0) {
String drop = "drop table aaa";
// st = con.createStatement();
st.executeQuery(drop);
}
String sql = "create table aaa(NAME varchar(20) ,IDNO varchar(50) ,birthday varchar(50) , oldrate number, newrate number, re varchar(100))";
// st = con.createStatement();
st.executeQuery(sql);
st.close();
HibernateUtil.closeSession();上面我注释掉的代码st = con.createStatement();要不要写,有什么区别!
解决方案 »
- 问个compaerTo方法的问题
- ibates里parameterClass里的值做什么用的
- 大家给解释几个java的名词,谢谢,文件管理,输入输出,graphic interface,AWT,Swing
- int 2 byte 需要&0xff吗?
- 奇怪的问题:The method a() is undefined for the type print
- 怎么使窗体无法变小
- 如何设置JTable的网格线的尺寸?
- JTextArea问题
- 请问大侠们一个java语言的问题. 如果访问基类的基类的版本的方法?
- INT 型和STRING型可以直接相加吗?
- applet
- 问个简单的问题,关于构造函数的。。。
因为你以前的st没有close掉
如果close的话就要重写一遍了