The following code:
(Note that this class inherits from HibernateDaoSupport. You must inject sessionFactory into this class in applicationContext. xml)
Public class DaoUtil extends HibernateDaoSupport {
Public Object executeMySQL (final String SQL ){
System. out. println (SQL );
Return gethibernatetemplate(cmd.exe cute (new HibernateCallback (){
Public Object doInHibernate (Session session)
Throws HibernateException, SQLException {
Connection CurConn = session. connection ();
PreparedStatement ps = CurConn. prepareStatement (SQL );
Ps.exe cute ();
Ps. close ();
Session. flush ();
Return null;
}
});
}
Public Object executeBetchSQL (final ArrayList SqlList ){
Return gethibernatetemplate(cmd.exe cute (new HibernateCallback (){
Public object doinhibernate (session)
Throws hibernateexception, sqlexception {
Connection curconn = session. Connection ();
Int COUNT = sqllist. Size ();
For (INT I = 0; I // system. Out. println (sqllist. Get (I ));
Preparedstatement PS = curconn. preparestatement (sqllist. Get (I ));
Ps.exe cute ();
PS. Close ();
Session. Flush ();
}
Return NULL;
}
});
}
Public static daoutil getfromapplicationcontext (
Applicationcontext CTX ){
Return (daoutil) CTX. getbean ("daoutil ");
}
}