mysqlutil.java

图书馆管理系统！利用java的mvc开发！

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package cn.edu.jmu.util;

import java.sql.SQLException;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.sql.DataSource;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanListHandler;

/**
 *
 * @author jiangchen
 */
public class MysqlUtil {

    private String dataSourceName;
    private DataSource ds;

    public MysqlUtil() {
    }

    public MysqlUtil(String dataSourceName) {
        this.dataSourceName = dataSourceName;
    }

    public void setDataSourceName(String dataSourceName) {
        this.dataSourceName = dataSourceName;
    }

    public void init() {
        try {
            Context initContext = new InitialContext();
            this.ds = (DataSource) initContext.lookup(dataSourceName);
            initContext.close();
        } catch (NamingException e) {
            e.printStackTrace();
        }
    }

    public int update(String sql, Object[] params) {
        QueryRunner qr = new QueryRunner(ds);
        int result = 0;
        try {
            result = qr.update(sql, params);
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return result;
    }

    public Object query(String sql, String[] params, BeanListHandler rsh) {
        QueryRunner qr = new QueryRunner(ds);
        Object results = null;
        try {
            results = qr.query(sql, params, rsh);
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return results;
    }

    public Object query(String sql, BeanListHandler rsh) {
        QueryRunner qr = new QueryRunner(ds);
        Object results = null;        
        try {
            results = qr.query(sql, rsh);
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return results;
    }
}