jdbc连接数据库ORACLE2

package com.betasoft.jdbc;


import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Date;


public class ConnectJDBC {
//驱动程序就是之前在classpath中配置的jdbc的驱动程序的jar包中
public static final String DBDRIVER = "oracle.jdbc.driver.OracleDriver";
//连接地址是由各个数据库生产商单独提供的，所以需要单独记住
public static final String DBURL = "jdbc:oracle:thin:@localhost:1521:orcl";
//连接数据库的用户名
public static final String DBUSER = "system";
//连接数据库的密码
public static final String DBPASS = "orcl";
public static void main(String[] args) {
Connection conn = null; //表示数据库的连接对象
Statement stmt = null; //表示数据库的更新操作
ResultSet result = null; //表示接收数据库的查询结果
//1.使用Class类加载驱动程序
try {
Class.forName(DBDRIVER);
//2.连接数据库
conn = DriverManager.getConnection(DBURL,DBUSER,DBPASS);
System.out.println(conn);
//3.Statement接口需要通过Connetion接口进行实例化操作
stmt = conn.createStatement();
//执行sql语句,更新数据库
//stmt.executeUpdate("INSERT INTO person(pid,name,age,birthday,salary) VALUES (perseq.nextval,'张三',30,TO_DATE('1995-02-14','yyyy-mm-dd'),9000.0)");

//执行sql语句,更新数据库
//stmt.executeUpdate("UPDATE person SET name='李四',age=33,birthday=sysdate,salary=8000.0 WHERE pid =1");

//执行sql语句,更新数据库
//stmt.executeUpdate("DELETE FROM person WHERE pid=3");

//执行sql语句,查询数据库
result = stmt.executeQuery("SELECT pid,name,age,birthday,salary FROM person");
while(result.next()){ //是否有下一行数据
/*int pid = result.getInt("pid");
String name = result.getString("name");
int age = result.getInt("age");
Date birthday = result.getDate("birthday");
float salary = result.getFloat("salary");*/
int pid = result.getInt(1);
String name = result.getString(2);
int age = result.getInt(3);
Date birthday = result.getDate(4);
float salary = result.getFloat(5);
System.out.println("pid="+pid+";name="+name+";age="+age+";birthday="+birthday+";salary="+salary);
}
//4.关闭数据库
conn.close();
} catch (ClassNotFoundException | SQLException e) {
e.printStackTrace();
}
}
}