dbconn.java

手工完成

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