return totalCount;
}
}
[java]
import java.util.Map;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.transform.Transformers;
public class DynamicHibernateTest {
public static void main(String[] args) {
try{
Session session=null;
// oracle
DynamicHibernateConfiguration configuration1 = new DynamicHibernateConfiguration("org.hibernate.dialect.OracleDialect","oracle.jdbc.driver.OracleDriver",
"ip","1521","orcl","uname","pwd");
System.out.println("hibernate.connection.url==1="+DynamicSessionFactory.getConfiguration().getProperty("hibernate.connection.url"));
DynamicSessionFactory.reflashSessionFactory(configuration1);
System.out.println("hibernate.connection.url==2="+DynamicSessionFactory.getConfiguration().getProperty("hibernate.connection.url"));
session=DynamicSessionFactory.getSession();
Query query1 = session.createSQLQuery("select * from WCMDBA.WCM_NEWS where NID=20825").setResultTransformer(
Map obj1 = (Map)query1.setMaxResults(1).uniqueResult();
System.out.println("fd1111===="+obj1.get("NID"));
// mysql
System.out.println("hibernate.connection.url==3="+DynamicSessionFactory.getConfiguration().getProperty("hibernate.connection.url"));
DynamicHibernateConfiguration configuration2 = new DynamicHibernateConfiguration("org.hibernate.dialect.MySQLInnoDBDialect","com.mysql.jdbc.Driver",
"127.0.0.1","3306","mobileCampus","root","root");
DynamicSessionFactory.reflashSessionFactory(configuration2);
System.out.println("hibernate.connection.url==4="+DynamicSessionFactory.getConfiguration().getProperty("hibernate.connection.url"));
session=DynamicSessionFactory.getSession();
Query query2 = session.createSQLQuery("select * from phone_app ").setResultTransformer(
Transformers.ALIAS_TO_ENTITY_MAP);
Map obj2 = (Map)query2.setMaxResults(1).uniqueResult();
System.out.println("fd2222===="+obj2.get("app_id"));
}catch (Exception e) {
System.err.println(e);
}
}
}