写一个java连接oracle的增删改查demo
时间: 2023-03-14 17:54:41 浏览: 104
这里是一个简单的Java连接Oracle数据库的增删改查demo:import java.sql.*;
public class JavaOracleDemo {
public static void main(String args[]){
Connection conn = null;
try {
// 加载 Oracle 驱动程序
Class.forName("oracle.jdbc.driver.OracleDriver");
// 建立连接
conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "scott", "tiger");
// 创建 Statement
Statement stmt = conn.createStatement();
// 插入数据
String sql = "INSERT INTO mytable (id, name) VALUES (1, 'Kathy')";
stmt.executeUpdate(sql);
// 查询数据
sql = "SELECT * FROM mytable";
ResultSet rs = stmt.executeQuery(sql);
while (rs.next()) {
System.out.println(rs.getInt(1) + "\t" + rs.getString(2));
}
// 修改数据
sql = "UPDATE mytable SET name = 'Kathy Smith' WHERE id = 1";
stmt.executeUpdate(sql);
// 删除数据
sql = "DELETE FROM mytable WHERE id = 1";
stmt.executeUpdate(sql);
// 关闭连接
conn.close();
} catch (Exception ex) {
ex.printStackTrace();
}
}
}