java 連接配接oracle資料庫

import java.sql.connection;

import java.sql.drivermanager;

import java.sql.preparedstatement;

import java.sql.resultset;

public class oracletest {

public static connection testoracle(){

connection con =null;

try {

class.forname("oracle.jdbc.driver.oracledriver");

system.out.println("開始連接配接");

string url="jdbc:oracle:"+"thin:@localhost:1521:orcl";

string user="lhy";

string password="lhy";

con=drivermanager.getconnection(url, user, password);

system.out.println("連接配接成功！");

} catch (exception e) {

// todo auto-generated catch block

e.printstacktrace();

}

return con;

public static void main(string args[]){

connection conn=oracletest.testoracle();

preparedstatement pre=null;

resultset result=null;

pre=conn.preparestatement("select * from student");

result=pre.executequery();

while(result.next()){

int id=result.getint("stu_id");

string name=result.getstring("stu_name");

system.out.println("id:"+id+"name:"+name);