dbconn.java

实现办公自动化系统

/**
 /**
 * DBConn.java , Created on 2008-10-20
 */
package com.oa.util;
/**
 * JDBC连接数据库
 * 
 * @version 1.0
 * @author liu
 * @since JDK1.5
 */
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.sql.DataSource;
public class DBConn {
	private String url = "jdbc:oracle:thin:@127.0.0.1:1521:oracle";//连接字符串 
	private String userName = "OA";							 	//用户名
	private String password = "OA";							 	//密码
	private Connection conn = null;
	
	/**
	 * @运用数据连接池来获得连接
	 */
	/*public Connection getConnection() {
		try {
			Context initCtx = new InitialContext();
			//Look up our data source
			DataSource ds = (DataSource)initCtx.lookup("java:comp/env/jdbc/oa");
			conn = ds.getConnection();

		} catch (NamingException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return conn;
	}*/
	/** 
	 * @用一般连接来获得连接
	 */
	public Connection getConnection()	{
		try {
		Class.forName("oracle.jdbc.driver.OracleDriver");
			conn = DriverManager.getConnection(url,userName,password);
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}catch(SQLException e)
		{
			e.printStackTrace();
		}
		return conn;
	}
    
    /**
     * @关闭数据库连接
     */
	public void closeConn()
	{   
		try{
			if(conn!=null)
			{
				conn.close();
			}
		}catch(SQLException e)
		{
			e.printStackTrace();
		}
	}
	/**
	 * @测试数据库连接
	 */
	public static void main(String []args)
	{
		Connection con;
		DBConn db=new DBConn();
		con=db.getConnection();
		try
		{
			Statement stmt=con.createStatement();
			String sql="select * from tb_userinfo";
			ResultSet rs=stmt.executeQuery(sql);
			while(rs.next())
			{
				String userName=rs.getString("realName");
				System.out.println("userName="+userName);
			}
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
	}
}