jdbc连接Oracle 12c

来源：互联网发布：美少女梦工厂 mac 编辑：程序博客网时间：2024/04/27 23:37

package oracleConn;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;public class Execute {public static final String DBDRIVER="oracle.jdbc.driver.OracleDriver";public static final String DBURL="jdbc:oracle:thin:@localhost:1521:orcl";//数据库连接地址，orcl为全局数据库名public static final String DBUSER="system";//用户名public static final String DBPASSWORD="admin";//密码public static void main(String[] args) throws Exception{Connection conn=null; ResultSet rs=null;PreparedStatement pstmt=null;Class.forName(DBDRIVER); // Oracle驱动加载conn=DriverManager.getConnection(DBURL,DBUSER,DBPASSWORD);//取得数据库连接/**以下部分作为数据库连接测试*在orcl中建立了一个名为mysql的数据表*内容仅有id和name*/String sql="SELECT * FROM myoracle"; //数据库查询pstmt=conn.prepareStatement(sql);rs=pstmt.executeQuery();while(rs.next()){String id=rs.getString("id");String name=rs.getString("name");System.out.print("编号："+id+"; ");System.out.print("姓名："+name+"; ");}rs.close();pstmt.close();conn.close();    }}

0 0