想用hibernate对mysql进行insert into about_info (
select * from news_info )操作时,执行了但是数据库没有插入任何东西,也没报错。
sql
=
"
insert into about_info "+"("+
"select * from news_info "+")";
HibernateTemplate ht = this .getHibernateTemplate();
Object re = ht.execute( new HibernateCallback() ... {
public Object doInHibernate(Session session)throws HibernateException...{
return session.createSQLQuery(sql);
}
} );
"select * from news_info "+")";
HibernateTemplate ht = this .getHibernateTemplate();
Object re = ht.execute( new HibernateCallback() ... {
public Object doInHibernate(Session session)throws HibernateException...{
return session.createSQLQuery(sql);
}
} );
使用java.sql.statement来插入可以。
try
...
{
Class.forName("org.gjt.mm.mysql.Driver");
Connection
con=DriverManager.getConnection("jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF8","test","11");
Statement stmt=con.createStatement();
int rs=stmt.executeUpdate(sql);
System.out.println(" The hql is finish "+sql);
} catch (Exception s) ... {
}
Class.forName("org.gjt.mm.mysql.Driver");
Connection
con=DriverManager.getConnection("jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF8","test","11");
Statement stmt=con.createStatement();
int rs=stmt.executeUpdate(sql);
System.out.println(" The hql is finish "+sql);
} catch (Exception s) ... {
}
有时间慢慢分析!!先备案。