JAVA JDBC
执行数据库操作之前,先配置eclipse,加入oracle11g的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="scott";
public static final String DBPASS="tiger";;
其中DBDRIVER为数据库的驱动程序;
DBURL为数据库的地址;如果不知道oracle的端口号的话,可以通过oracle的net Manager查看,如下图
DBUSER为数据库用户的名字;
DBPASS为密码;
下面是一个例子:
package org.ts.connectdemo;
import java.sql.*;
public class ConnectJDBC {
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 = "scott";
public static final String DBPASS = "tiger";
public static void main(String[] args) {
Connection conn=null;
PreparedStatement pstmt=null;
ResultSet rs=null;
try{
//使用Class类加载驱动程序
Class.forName(DBDRIVER);
//连接数据库
conn=DriverManager.getConnection(DBURL, DBUSER,DBPASS );
String sql="SELECTuserid,password FROM tuser";
//Preparestatement接口通过connection 接口进行实例化
pstmt=conn.prepareStatement(sql);
//执行SQL更新
rs=pstmt.executeQuery();
while(rs.next()){
System.out.println(rs.getString("userid")+" "+rs.getString("password"));
}
}catch(Exception e1){
System.out.println(e1);
}finally{
try{
//关闭数据库
conn.close();
}catch(Exception e2){
System.out.println(e2);
}
}
}
}