import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class Ocracle Conn {
public static void main(String[ ] args) {
try{
Connection conn = DriverManager
.getConnection("jdbc:oracle:thin@localhost:1521:XE", "user", "pass") ;
Sout("Database connect successful") ;
Statements stmt = conn.createStament() ;
ResultSet rs = stmt.executeQuery(select * form empt, dept") ;
while(rs.next()) {
Sout(rs.getString("name") +rs.getInt("ID") +rs.getString("department" )) ; }
conn close() ;
} catch(SQL Exception e) {
Sout( e) ;
Sout("Database connect error" + e.getmessage()) ;
}}}} //sout=System.out.println
轉載請註明出處,本文鏈接:https://www.uj5u.com/houduan/240167.html
標籤:Java SE
