本文演示了如何使用Java与Oracle数据库进行交互，包括数据库连接、执行SQL插入语句以及查询数据的基本步骤。通过示例代码，读者可以学习到如何在Java应用程序中集成Oracle数据库，并执行常见数据库操作。
××××××××××××××××××××××××××××××××××××××××××××××××××××××××××××××××××××××××××
package org.oracle.select;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class ResultDeom {
public static final String DBDRIVER = "oracle.jdbc.driver.OracleDriver";
public static final String DBURL = "jdbc:oracle:thin:@127.0.0.1:1521:ORCL";
public static final String DBUSER = "scott";
public static final String DBPASS = "tiger";
public static void main(String[] args) throws Exception{
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
Class.forName(DBDRIVER);
conn = DriverManager.getConnection(DBURL, DBUSER, DBPASS);
stmt = conn.createStatement();
// stmt.executeUpdate("insert into person(name,age,birthday,salary)values('李四',22,TO_Date('1986-2-22','yyyy-mm-dd'),4000)");
rs = stmt.executeQuery("select name,age,birthday,salary from person");
while(rs.next()){
System.out.print("name:"+rs.getString("name")+". ");
System.out.print("age:"+rs.getInt("age")+". ");
System.out.print("birthday:"+rs.getDate("birthday")+". ");
System.out.println("salary:"+rs.getFloat("salary")+". ");
}
rs.close();
stmt.close();
conn.close();
}
}
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
