databaseaccess.java

基本完成上传本地图片和信息的分类显示

package com.bean;

import java.sql.Connection;
import java.sql.SQLException;

import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.sql.DataSource;

public class DatabaseAccess {
	private Connection con;
	private DataSource ds;

	public DatabaseAccess() {
		try {
			InitialContext ctx = new InitialContext();
			ds = (DataSource) ctx.lookup("java:comp/env/jdbc/Northwind");
		} catch (NamingException e) {
			e.printStackTrace();
		}
		setCon(ds);
	}

	public DatabaseAccess(String jndi) {
		try {
			InitialContext ctx = new InitialContext();
			ds = (DataSource) ctx.lookup("java:comp/env/" + jndi);
		} catch (NamingException e) {
			e.printStackTrace();
		}
		setCon(ds);
	}

	public void setCon(DataSource ds) {
		try {
			con = ds.getConnection();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

	public Connection getCon() {
		return con;
	}

}