1、 创建数据库test1,包含t_id、t_name
create table test1( t_id number,t_name varchar(20));
2、下载oracle的jdbc,官网下载
3、代码:
package dao;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
public class DBUtil {
private static String user="xdd";
private static String password="xdd";
private static String url="jdbc:oracle:thin:@localhost:1521:orcl";
public static Connection getConnnection(){
Connection conn=null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
conn=DriverManager.getConnection(url, user, password);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return conn;
}
public static void main(String args[]){
Connection conn=DBUtil.getConnnection();
PreparedStatement psta=null;
ResultSet rs=null;
try {
psta=conn.prepareStatement("select * from test1");
rs=psta.executeQuery();
while(rs.next()){
int id=rs.getInt("t_id");
String name=rs.getString("t_name");
System.out.println("ID:"+id+","+"Name:"+name);
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
4、 结果: