先谢谢大家了,我这个代码只能实现查询,请问应该修改才能实现在oracle中建表,增加,删除,更新操作,谢谢。
import java.sql.*;public class ConnectOracle {
public static void main(String[] args) {
Connection conn = null;
PreparedStatement prstm = null;
ResultSet rs = null;
try {
//------------------------------------------------------------------------------
Class.forName("oracle.jdbc.driver.OracleDriver");
String url = "jdbc:oracle:thin:@127.0.0.1:1521:xu"; // 数据库连接字符串
String user = "scott";
String password = "tiger";
conn = DriverManager.getConnection(url, user, password); // 获取连接
//-------------------------------------------------------------------------------
prstm = conn.prepareStatement("SELECT * FROM BUDGET_BASE_DATA");
rs = prstm.executeQuery();
System.out.println("查询结果为:" );
while (rs.next()) {
System.out.println(rs.getString("ID") +" "+ rs.getString("TYPE"));
}
prstm = conn.prepareStatement("create table zltest(aa number,bb varchar2(10))");
System.out.print("done");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
// 使用完毕进行相关内容的关闭,注意相关顺序
if (rs != null) {
try {
rs.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if (prstm != null) {
try {
prstm.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if (conn != null) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}}
import java.sql.*;public class ConnectOracle {
public static void main(String[] args) {
Connection conn = null;
PreparedStatement prstm = null;
ResultSet rs = null;
try {
//------------------------------------------------------------------------------
Class.forName("oracle.jdbc.driver.OracleDriver");
String url = "jdbc:oracle:thin:@127.0.0.1:1521:xu"; // 数据库连接字符串
String user = "scott";
String password = "tiger";
conn = DriverManager.getConnection(url, user, password); // 获取连接
//-------------------------------------------------------------------------------
prstm = conn.prepareStatement("SELECT * FROM BUDGET_BASE_DATA");
rs = prstm.executeQuery();
System.out.println("查询结果为:" );
while (rs.next()) {
System.out.println(rs.getString("ID") +" "+ rs.getString("TYPE"));
}
prstm = conn.prepareStatement("create table zltest(aa number,bb varchar2(10))");
System.out.print("done");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
// 使用完毕进行相关内容的关闭,注意相关顺序
if (rs != null) {
try {
rs.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if (prstm != null) {
try {
prstm.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if (conn != null) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}}
解决方案 »
- 怎么去采集PM2.5数据呢,就像获取天气预报信息有接口,该怎么解决呢
- 关于struts1的问题请指教,在线等啊
- birt引入的js文件中如何导入其它js文件
- 如何通过ascii 码得到字符?
- 出版社诚征网络编程高手写书,有哪位高手愿意写的?
- struts2 ajax解决4级联动菜单问题
- 超怪问题:jsp部署问题,部署到服务器上,servU远程连接服务器http可访问jsp,断开不行???????????????
- 如何在jsp中实现连续打印和套打?
- JSP中一个奇怪的if判断...
- 怎么样在.java文件中包含同一个包下面的类?在线等
- struts2action访问另外一个服务器的地址,想隐藏地址栏信息,怎样实现
- 请问java怎么把excel中的数据写入到数据库中啊!最好是oracle
pstmt.executeUpdate();