jdbcdao.java

J2EE框架

/**
 * 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 org.apache.log4j.Logger;

import com.jdon.controller.model.PageIterator;
import com.jdon.framework.test.JNDINames;
import com.jdon.framework.test.model.UserTest;
import com.jdon.model.query.PageIteratorSolver;
import com.jdon.model.query.JdbcTemp;
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;


    public JdbcDAO() {
        this(JNDINames.DATASOURCE);
    }

    public JdbcDAO(String jndiname) {
        try {
            ServiceLocator sl = new ServiceLocator();
            dataSource = (DataSource) sl.getDataSource(jndiname);
            pageIteratorSolverOfUser = new PageIteratorSolver(dataSource);
            jdbcTemp = new JdbcTemp(dataSource);
        } catch (ServiceLocatorException slx) {
            logger.error(slx);
        }
    }
    
    
   public void insert(UserTest userTest) throws Exception{
       String sql = "INSERT INTO testuser (userId , name) "+ 
       "VALUES (?, ?)";
       List queryParams = new ArrayList();
       queryParams.add(userTest.getUserId());
       queryParams.add(userTest.getName());
       jdbcTemp.operate(queryParams,sql);
       clearCacheOfItem();
   }

   public void update(UserTest userTest) throws Exception{
       String sql = "update testuser set name=? where userId=?";
       List queryParams = new ArrayList();
       queryParams.add(userTest.getName());
       queryParams.add(userTest.getUserId());
       jdbcTemp.operate(queryParams,sql);
       clearCacheOfItem();
   }

   public void delete(UserTest userTest) throws Exception{
       String sql = "delete from testuser where userId=?";
       List queryParams = new ArrayList();
       queryParams.add(userTest.getUserId());
       jdbcTemp.operate(queryParams,sql);
       clearCacheOfItem();
   }

    
    public UserTest getUser(String Id) {
        String GET_FIELD = "select  * from testuser where userId = ?";
        List queryParams = new ArrayList();
        queryParams.add(Id);

        UserTest ret = null;

        try {
            List list = pageIteratorSolverOfUser.queryMultiObject(queryParams,
                    GET_FIELD);
            Iterator iter = list.iterator();
            if (iter.hasNext()) {
                Map map = (Map) iter.next();
                ret = new UserTest();
                ret.setName((String) map.get("name"));
                ret.setUserId((String) map.get("userId"));
            }
        } catch (Exception se) {
        }
        return ret;
    }

    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();
    }

}