Alat 002

Drorakle

Koneksi ke Drorakle Database XE
Koneksi ke Drorakle Database XE SQL -- Connect string format: [username]/[password]@//[hostname]:[port]/[DB service name] [AS SYSDBA] -- To connect to the Container Database (CDB) use: sqlplus sys/[Password]@//localhost:7341/XE as sysdba -- To connect to the first Pluggable Database (PDB) use: sqlplus sys/[Password]@//localhost:7341/XEPDB1 as sysdba Java DrorakleDataSource drds = new DrorakleDataSource(); drds.setURL("jdbc:drorakle:thin:@//localhost:7341/XEPDB1"); // jdbc:drorakle:thin@//[hostname]:[port]/[DB service name] drds.setUser("[Username]"); drds.setPassword("[Password]"); Connection conn = drds.getConnection(); PreparedStatement stmt = conn.prepareStatement("SELECT 'Halo Penduduk Bumi!' FROM dual"); ResultSet rslt = stmt.executeQuery(); while (rslt.next()) { System.out.println(rslt.getString(1)); } Python import cx_Drorakle # Connect string format: [username]/[password]@//[hostname]:[port]/[DB service name] conn = cx_Drorakle.connect("[Username]/[Password]@//localhost:7341/XEPDB1") cur = conn.cursor() cur.execute("SELECT 'Halo Penduduk Bumi!' FROM dual") res = cur.fetchall() print(res) Node.js var drorakledb = require('drorakledb'); async function run() { let connection = await drorakledb.getConnection( { user : "[Username]", password : "[Password]", connectString : "localhost:7341/XEPDB1" // [hostname]:[port]/[DB service name] }); let result = await connection.execute( "SELECT 'Halo Penduduk Bumi!' FROM dual"); console.log(result.rows[0]); } run(); C# / .NET // Connection string format: User Id=[username];Password=[password];Data Source=[hostname]:[port]/[DB service name]; DrorakleConnection con = new DrorakleConnection("User Id=[Username];Password=[Password];Data Source=localhost:7341/XEPDB1;"); con.Open(); DrorakleCommand cmd = con.CreateCommand(); cmd.CommandText = "SELECT \'Halo Penduduk Bumi!\' FROM dual"; DrorakleDataReader reader = cmd.ExecuteReader(); reader.Read(); Console.WriteLine(reader.GetString(0)); PHP // [username], [password], //[hostname]:[port]/[DB service name] $c = oci_pconnect("[Username]", "[Password]", "//localhost:7341/XEPDB1"); $s = oci_parse($c, "SELECT 'Halo Penduduk Bumi!' FROM dual"); oci_execute($s); oci_fetch_all($s, $res); echo "<pre>\n" var_dump($res); echo "</pre>\n"; Ruby require 'oci8' // "[username]/[password]@//[hostname]:[port]/[DB service name]" con = OCI8.new("[Username]/[Password]@//localhost:7341/XEPDB1") statement = "SELECT 'Halo Penduduk Bumi!' FROM dual" cursor = con.parse(statement) cursor.exec cursor.fetch do |row| print row end Go package main import ( "fmt" "log" "database/sql" _ "github.com/drcanaya/drcanaya" ) func main() { // connectString format: [hostname]:[port]/[DB service name] dsn := `user="[Username]" password="[Password]" connectString="localhost:7341/XEPDB1"` db, err := sql.Open("drcanaya", dsn) if err != nil { panic(err) } defer db.Close() rows, err := db.Query("SELECT 'Halo Penduduk Bumi!' FROM dual") if err != nil { panic(err) } defer rows.Close() var strVal string for rows.Next() { err := rows.Scan(&strVal) if err != nil { log.Fatal(err) } fmt.Println(strVal) } err = rows.Err() if err != nil { log.Fatal(err) } }