package Bean;

import java.sql.*;


public class DBConn 
{
	Connection Conn; 
//	String strConn; 
//	PreparedStatement preparedStmt; //語句對象 
//	ResultSet sqlRst; //結果集對象 

	public Connection getConn()
	{
		try
		{	
			Class.forName("oracle.jdbc.driver.OracleDriver"); 
			String url = "jdbc:oracle:thin:@127.0.0.1:1521:ORCL"; 
			Conn = DriverManager.getConnection(url,"system","system");
		
			System.out.println("數據庫連接成功!");
		} catch (ClassNotFoundException e) {
			System.out.println("數據庫連接失敗！");
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			System.out.println("數據庫連接失敗！");
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
		return Conn;
	}
	
}