Java连接、操作Oracle 10g 数据库

1、给Java工程添加jar包：ojdbc14.jar；

2、Java代码：

2.1 获取与Oracle的连接的类：

package com.newthread.map.bus;

import java.sql.Connection;
import java.sql.DriverManager;

public class OdbConnFactory {
	
	public static String url = "jdbc:oracle:thin:@127.0.0.1:1521:orcl";
	public static String user = "****";
	public static String password = "********";


	public static Connection getConnection(){
		Connection con = null;
		try {
			Class.forName("oracle.jdbc.driver.OracleDriver");
			con = DriverManager.getConnection(url, user, password);
			if (con != null) {
				System.out.println("连接成功！con是：" + con);

			} else {
				System.out.println("连接失败！");
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
		return con;
	}
}

2.2 操作数据库示例类：