Session session = MySessionFactory.getSession();
String sql = "insert into "+ table+" SELECT * FROM OpenDataSource('Microsoft.Jet.OLEDB.4.0','Data Source=\""+filename+"\";User ID=Admin;Password=;Extended properties=Excel 5.0')...Sheet1$ ";
Connection con = session.connection();
Statement state = con.createStatement();
state.execute(sql);源码的一部份
String sql = "insert into "+ table+" SELECT * FROM OpenDataSource('Microsoft.Jet.OLEDB.4.0','Data Source=\""+filename+"\";User ID=Admin;Password=;Extended properties=Excel 5.0')...Sheet1$ ";
Connection con = session.connection();
Statement state = con.createStatement();
state.execute(sql);源码的一部份
Session session = MySessionFactory.getSession();
String sql = "insert into "+ table+" SELECT * FROM OpenDataSource('Microsoft.Jet.OLEDB.4.0','Data Source=\""+filename+"\";User ID=Admin;Password=;Extended properties=Excel 5.0')...Sheet1$ ";
Connection con = session.connection();
Statement state = con.createStatement();
state.execute(sql);
tag=true;
我有设tag标志
tag的值为true,数据库里没有excel表的值.
仁兄莫非也在用vfp啊