1.Java中实现对oracle数据的crud
1)将外部的驱动包添加到构建路径:
2)将驱动加载到JVM:Class.forName(driver)
oracle.jdbc.driver.OracleDriver
3创建连接对象 url :jdbc:oracle:thin:@localhost:1521:orcl
Jdbc :mysql://localhost:3306/数据库名
4)通过连接对象实例化PreparedStatement
5)执行sql语句(使用预处理对象) executeUpdate() executeQuery
6)处理结果
7)释放资源
参考代码
public class TestQuerEmp {
public static void main(String[] args) {
// 1加载JVM
try {
//Class.forName("oracle.jdbc.driver.OracleDriver");
// 2 获取连接对象
Connection conn = DriverManager.getConnection(
"jdbc:oracle:thin:@localhost:1521:orcl", "scott", "tiger");
// 3创建PreparedStatement对象
PreparedStatement pstmt = conn
.prepareStatement("select * from emp");
// 4执行查询
ResultSet rs = pstmt.executeQuery();
while (rs.next()) {
String empno = rs.getString("empno");
String ename = rs.getString("ename");
System.out.println(empno + "," + ename);
}
rs.close();
pstmt.close();
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}