java连接oracle10g源码,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 操作数据库示例类：

package com.newthread.map.bus;

import java.sql.Connection;

import java.sql.PreparedStatement;

public class UserDao {

/**

* @param args

*/

public static void main(String[] args) {

// TODO Auto-generated method stub

}

public void insert() throws Exception {

String sql = "INSERT INTO TB_USERINFO (USERNAME,PASSWORD) VALUES (?,?)";

PreparedStatement pstmt = null;

Connection con = OdbConnFactory.getConnection();

// 下面是针对数据库的具体操作

try {

// 连接数据库

pstmt = con.prepareStatement(sql);

pstmt.setString(1, "xiaoma");

pstmt.setString(2, "xiaoma");

// 进行数据库更新操作

pstmt.executeUpdate();

} catch (Exception e) {

throw new Exception("操作出现异常");

} finally {

// 关闭数据库连接

pstmt.close();

con.close();

}

}

}