jdbcdao.java

功能完善的java开发框架

/**
 * Copyright 2005 Jdon.com Licensed under the Apache License, Version 2.0 (the
 * "License"); you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 * 
 * http://www.apache.org/licenses/LICENSE-2.0
 * 
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
 * WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
 * License for the specific language governing permissions and limitations under
 * the License.
 */

package com.jdon.framework.test.dao;

import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;
import java.util.Map;

import javax.sql.DataSource;

import net.sf.hibernate.HibernateException;
import net.sf.hibernate.Session;
import net.sf.hibernate.SessionFactory;
import net.sf.hibernate.Transaction;
import net.sf.hibernate.cfg.Configuration;

import org.apache.log4j.Logger;

import com.jdon.controller.model.PageIterator;
import com.jdon.framework.test.model.UserTest;
import com.jdon.model.query.JdbcTemp;
import com.jdon.model.query.PageIteratorSolver;
import com.jdon.servicelocator.ServiceLocatorException;
import com.jdon.servicelocator.ejb.ServiceLocator;

/**
 * before using this class , you must  active database
 * @author <a href="mailto:[e-mail]">banq</a>
 *
 */
public class JdbcDAO implements java.io.Serializable {

    private final static Logger logger = Logger.getLogger(JdbcDAO.class);

    private DataSource dataSource ;

    private PageIteratorSolver pageIteratorSolverOfUser ;

    private JdbcTemp jdbcTemp;

    private SessionFactory sf;

    public JdbcDAO(String jndiname) {
        try {
            ServiceLocator sl = new ServiceLocator();
            dataSource = (DataSource) sl.getDataSource(jndiname);
            pageIteratorSolverOfUser = new PageIteratorSolver(dataSource);
            sf = new Configuration().configure().buildSessionFactory();
        } catch (Exception slx) {
            logger.error(slx);
        }
    }
    
    
   public void insert(UserTest userTest) throws Exception{
       logger.debug("enter createUser");
       try {
         Session session = sf.openSession(dataSource.getConnection());
         Transaction tx = session.beginTransaction();
         session.save(userTest);
         tx.commit();
         session.close();
         clearCacheOfItem();
       }
       catch (HibernateException ex) {
         logger.error("error:" + ex);
     }
   }

   public void update(UserTest userTest) throws Exception{
       try {
          Session session = sf.openSession(dataSource.getConnection());
          Transaction tx = session.beginTransaction();
          UserTest newUser = (UserTest) session.load(UserTest.class, userTest.getUserId());
          newUser.setName(userTest.getName());
          tx.commit();
          session.close();
          clearCacheOfItem();
        }
        catch (HibernateException ex) {
          logger.error("error:" + ex);
        }

     }

     public void delete(UserTest userTest) throws Exception{
       try {
         Session session = sf.openSession(dataSource.getConnection());
         Transaction tx = session.beginTransaction();
         session.delete(userTest);
         tx.commit();
         session.close();
         clearCacheOfItem();
       }
       catch (HibernateException ex) {
         logger.error("error:" + ex);
       }

     }


      public UserTest getUser(String Id) {
        logger.debug("enter getUser");
        UserTest user = null;
        try {
          Session session = sf.openSession(dataSource.getConnection());
          user = (UserTest) session.get(UserTest.class, Id);
          session.close();
        }
        catch (Exception ex) {
          logger.error("error:" + ex);
        }
        return user;

      }

      /**
       * http://www.jdon.com/jive/thread.jsp?forum=62&thread=22251
       * @param start
       * @param count
       * @return
       * @throws Exception
       */
    public PageIterator getUsers(int start, int count) throws Exception {
        String GET_ALL_ITEMS_ALLCOUNT = "select count(1) from testuser ";

        String GET_ALL_ITEMS = "select userId  from testuser ";

        return pageIteratorSolverOfUser.getDatas("", GET_ALL_ITEMS_ALLCOUNT,
                GET_ALL_ITEMS, start, count);
    }

    public void clearCacheOfItem() {
        pageIteratorSolverOfUser.clearCache();
    }

}