***** HIBERNATE.CFG.XML
<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-2.0.dtd">
<hibernate-configuration>
<session-factory>
<property name="dialect">org.hibernate.dialect.PostgreSQLDialect</property>
<property name="connection.driver_class">org.postgresql.Driver</property>
<property name="connection.username">postgres</property>
<property name="connection.password">postgres</property>
<property name="connection.url">jdbc:postgresql://10.0.0.10:5432/MarioBookmarks</property>
<property name="show_sql">true</property>
<property name="max_fetch_depth">1</property>
<property name="use_query_cache">true</property>
<property name="use_second_level_cache">true</property>
<property name="query.factory_class">org.hibernate.hql.classic.ClassicQueryTranslatorFactory</property>
<!--mapping resource="mio/hibernate/Bookcat.hbm.xml" /-->
<mapping resource="mio/hibernate/Categorie.hbm.xml" />
<mapping resource="mio/hibernate/Bookmark.hbm.xml" />
</session-factory>
</hibernate-configuration>
***** CATEGORIE.HBM.XML
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd" >
<hibernate-mapping>
<!--
Created by the Middlegen Hibernate plugin 2.1
http://boss.bekk.no/boss/middlegen/
http://www.hibernate.org/
-->
<class
name="mio.hibernate.Categorie"
table="categorie"
>
<id
name="id"
column="id"
type="java.lang.Integer"
>
<!--generator class="assigned" ></generator-->
<generator class="sequence">
<param name="sequence">categorie_seq</param>
</generator>
</id>
<property
name="categoria"
type="java.lang.String"
column="categoria"
unique="true"
length="30"
/>
</class>
</hibernate-mapping>
****** BOOKMARKS.HBM.XML
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd" >
<hibernate-mapping>
<!--
Created by the Middlegen Hibernate plugin 2.1
http://boss.bekk.no/boss/middlegen/
http://www.hibernate.org/
-->
<class
name="mio.hibernate.Bookmark"
table="bookmarks"
>
<id
name="id"
type="java.lang.Integer"
column="id"
>
<generator class="sequence">
<param name="sequence">bookmarks_seq</param>
</generator>
</id>
<property
name="descrizione"
type="java.lang.String"
column="Descrizione"
not-null="true"
length="50"
/>
<property
name="url"
type="java.lang.String"
column="URL"
not-null="true"
length="50"
/>
<property
name="data"
type="java.sql.Timestamp"
column="Data"
not-null="true"
length="4"
/>
<!-- Associations -->
<set
name="categorie"
table="bookcat"
cascade="none"
>
<key column="bookmark_id" />
<many-to-many
column="categorie_id"
class="mio.hibernate.Categorie"
/>
</set>
</class>
</hibernate-mapping>
***** BUSINESSLOGIC.JAVA
package mio;
import java.io.Serializable;
import java.sql.Connection;
import java.util.ArrayList;
import java.util.Date;
import java.util.HashSet;
import java.util.Iterator;
import java.util.List;
import java.util.Set;
import mio.hibernate.Bookmark;
import mio.hibernate.Categorie;
import org.apache.log4j.Level;
import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
/**
*
*
* @author $Author: giammarc $
* @version $Id: BusinessLogic.java,v 1.1 2005/06/25 18:11:40 giammarc Exp $
*/
public class BusinessLogic implements Serializable {
private static org.apache.log4j.Logger logger = org.apache.log4j.Logger.getLogger(BusinessLogic.class);
private static SessionFactory sessionFactory;
// static {
// try {
// // Create the SessionFactory
// sessionFactory = new Configuration().configure().buildSessionFactory();
// } catch (HibernateException ex) {
// throw new RuntimeException("Configuration problem: " + ex.getMessage(), ex);
// }
// }
private Connection conn;
private Session session;
private Transaction tx;
public BusinessLogic() {
try {
// Create the SessionFactory
sessionFactory = new Configuration().configure().buildSessionFactory();
} catch (HibernateException ex) {
throw new RuntimeException("------------------------Configuration problem: " + ex.getMessage(), ex);
}
session=currentSession();
}
public static void main(String[] args) throws HibernateException {
logger.setLevel(Level.DEBUG);
BusinessLogic bl= new BusinessLogic();
bl.test(bl);
}
public void test(BusinessLogic bl) {
//Categorie c1= new Categorie();
//Categorie c2= new Categorie();
Bookmark b= new Bookmark();
//c1.setCategoria("CatCiao1");
//c2.setCategoria("CatCiao5");
//Set s= new HashSet();
//s.add(c1);
//s.add(c2);
System.out.println(bl.getCategorieAsArray().getClass());
System.out.println(bl.getCategorieAsArray()[0]);
System.out.println(bl.getCategorieAsArray().getClass());
System.out.println(bl.getCategorieAsArray()[0]);
bl.bt();
b.setData(new Date());
b.setUrl("ciaociao");
b.setDescrizione("cia222ociaociaodesc");
String temp[]={"uno3b","d3ue","t3re","anto3"};
b.setCategorie(bl.insertCategorie(temp));
//bl.insertCategoria(c1);
//bl.insertCategoria(c2);
bl.insertBookmark(b);
bl.et();
System.out.println(b.getId());
System.out.println(bl.getBookmarks(null,null,null));
System.out.println(bl.getCategorieAsArray().getClass());
System.out.println(bl.getCategorieAsArray()[0]);
bl.closeSession();
}
/**
* @param b
* @throws HibernateException
*/
public synchronized void insertBookmark(Bookmark b) throws HibernateException {
session.save(b);
}
// public void apriTutto() throws ClassNotFoundException, SQLException {
// Class.forName("org.postgresql.Driver");
// String url = "jdbc:postgresql://10.0.0.10/MarioBookmarks?user=postgres&password=postgres";
// conn = DriverManager.getConnection(url);
//
// }
public synchronized Session currentSession() throws HibernateException {
// Open a new Session, if this Thread has none yet
if (session == null) {
session = sessionFactory.openSession();
}
return session;
}
public synchronized void closeSession() throws HibernateException {
if (session != null)
session.close();
}
public synchronized void bt() {
tx= session.beginTransaction();
}
public synchronized void et() {
session.flush();
tx.commit();
}
public synchronized void insertCategoria(Categorie c) throws HibernateException {
Query query = session.createQuery("select c from Categorie as c where c.categoria = :descr");
query.setString("descr", c.getCategoria());
Categorie c2= (Categorie) query.uniqueResult();
if (c2!=null) c.setId(c2.getId());
session.saveOrUpdate(c);
}
public synchronized Set insertCategorie(String cs[]) throws HibernateException {
Set res= new HashSet();
for (int i = 0; i < cs.length; i++) {
logger.debug(cs[i]);
if (cs[i]!=null) {
Query query = session.createQuery("select c from Categorie as c where c.categoria = :descr");
query.setString("descr", cs[i]);
Categorie c2= (Categorie) query.uniqueResult();
if (c2!=null) {
session.saveOrUpdate(c2);
res.add(c2);
}
else {
Categorie c3=new Categorie();
c3.setCategoria(cs[i]);
session.saveOrUpdate(c3);
res.add(c3);
}
}
}
return res;
}
public synchronized List getBookmarks(List categorie, Date da, Date a) {
String filters="";
if (categorie!=null && categorie.isEmpty()==false) filters+=" b.categorie.categoria.id " +
"in (select c.id from Categorie as c where c.categoria in (:categorie))";
if (da!=null) {
if (!filters.equals("")) filters+=" AND ";
filters+=" b.data >= :da";
}
if (a!=null) {
if (!filters.equals("")) filters+=" AND ";
filters+=" b.data <= :a";
}
if (!filters.equals("")) filters="where "+filters;
Query q= currentSession().createQuery("select distinct b from Bookmark as b , Categorie as c "+filters);
if (categorie!=null && categorie.isEmpty()==false) q.setParameterList("categorie",categorie);
if (da!=null) q.setDate("da",da);
if (a!=null) q.setDate("a",a);
List result= q.list();
if (result!=null) return result;
else return new ArrayList();
}
public synchronized String [] getCategorieAsArray() {
List cats= getCategorie();
String[] result=null;
if (cats!=null) {
result =new String[cats.size()];
int i=0;
for (Iterator iter = cats.iterator(); iter.hasNext();) {
Categorie element = (Categorie) iter.next();
result[i++]=element.getCategoria();
}
}
return result;
}
public synchronized List getCategorie() {
session.flush();
Query q= session.createQuery("from Categorie cats");
List temp=q.list();
return temp;
}
}
****** HOME.JAVA
package mio;
import java.util.Date;
import java.util.List;
import java.util.Set;
import mio.hibernate.Bookmark;
import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.apache.tapestry.IRequestCycle;
import org.apache.tapestry.form.IPropertySelectionModel;
import org.apache.tapestry.form.StringPropertySelectionModel;
import org.apache.tapestry.html.BasePage;
/**
*
*
* @author $Author: giammarc $
* @version $Id: Home.java,v 1.1 2005/06/25 18:11:40 giammarc Exp $
*/
public abstract class Home extends BasePage {
private static org.apache.log4j.Logger logger = org.apache.log4j.Logger.getLogger(Home.class);
public abstract String getUrl();
public abstract String getDescrizione();
public abstract String getCategorie();
public abstract List getCategorieScelte();
private BusinessLogic bl;
private IPropertySelectionModel listaCategorie;
public Home() {
// if (bl==null) bl= new BusinessLogic();
// logger.debug("++++++++++++++++++++++++++++++"+getEngine());
// logger.debug(getVisit());
// logger.debug(getGlobal());
}
public void formSubmit(IRequestCycle cycle) {
logger.debug("++++++++++++++++++++++++++++++"+getEngine());
logger.debug(getVisit());
logger.debug(getGlobal());
bl=(BusinessLogic) getGlobal();
bl.test(bl);
// String[] temp= {"uno","due"};
// String catTemp=getCategorie();
// String[] categorie=null;
//
// if (catTemp!=null) categorie=catTemp.split(" ");
// Bookmark bm= new Bookmark();
//
// bl.bt();
// bm.setData(new Date());
// bm.setUrl(getUrl());
// bm.setDescrizione(getDescrizione());
//
//
// Set s=bl.insertCategorie((String [])getCategorieScelte().toArray(temp));
// if (categorie!=null && !categorie.equals("")) s.add(bl.insertCategorie(categorie));
// bm.setCategorie(s);
// logger.debug("@@@@@@@@@@@@@@@@@@@@@@@@"+s);
// bl.insertBookmark(bm);
//
// bl.et();
// bl.closeSession();
}
public IPropertySelectionModel getListaCategorie() {
bl=(BusinessLogic) getGlobal();
String[] temp= {"no","no"};
String[] cat=bl.getCategorieAsArray();
if (cat!=null) return new StringPropertySelectionModel(cat);
else return new StringPropertySelectionModel(temp);
}
}
****** RESULTLIST.JAVA
package mio;
import java.util.Date;
import java.util.List;
import java.util.Set;
import mio.hibernate.Bookmark;
import org.apache.tapestry.IRequestCycle;
import org.apache.tapestry.form.IPropertySelectionModel;
import org.apache.tapestry.form.StringPropertySelectionModel;
import org.apache.tapestry.html.BasePage;
import org.hibernate.HibernateException;
/**
*
*
* @author $Author: giammarc $
* @version $Id: ResultList.java,v 1.1 2005/06/25 18:11:40 giammarc Exp $
*/
public abstract class ResultList extends BasePage {
private BusinessLogic bl;
public abstract List getCategorieScelte();
public abstract Date getDa();
public abstract Date getA();
// public abstract String getUrl();
// public abstract String getDescrizione();
// public abstract String getCategorie();
// public void formSubmit(IRequestCycle cycle) throws HibernateException{
// BusinessLogic bl= new BusinessLogic();
// String categorie[]= getCategorie().split(" ");
// Bookmark bm= new Bookmark();
//
// bl.bt();
// Set s=bl.insertCategorie(categorie);
// bm.setCategorie(s);
// bm.setData(new Date());
// bm.setUrl(getUrl());
// bm.setDescrizione(getDescrizione());
// bl.insertBookmark(bm);
// }
public List getBookmarks() {
bl= (BusinessLogic) getGlobal();
return bl.getBookmarks(getCategorieScelte(),getDa(),getA());
}
public void formSubmit(IRequestCycle cycle) throws HibernateException{
}
public IPropertySelectionModel getListaCategorie() {
bl= (BusinessLogic) getGlobal();
String[] temp= {"no","no"};
String[] cat=bl.getCategorieAsArray();
if (cat!=null) return new StringPropertySelectionModel(cat);
else return new StringPropertySelectionModel(temp);
}
}
Login
FAQ
Search