An example of Java JDBC connection

xiaoxiao2021-03-06  71

Import java.lang. *; import java.util. *; import java.sql. *;

Public class cn1 {

Public static void main (string args []) {string s = "Gu Qiang"; string S1 = "ab"; string drv = null; connection conn = null; statement stmt = null; resultset = null; int RowCount = 0 ;

Properties P = new profment ();

The Try {// Register the database driver for Oracle Drive Class.Forname ("Oracle.jdbc.driver.Driver.Driver.Driver.Driver);} catch (java.lang.classnotnotfoundexception e) {// This way is to facilitate debugging programs, error printing MYDB () I know where I have an error in system.rr.println ("mydb ():" E.getMessage ());}

Try {conn = drivermanager.getConnection ("JDBC: Oracle: Thin: @ 127.0.0.1: 1521: ORC8i", "Java", "88888888");} catch (sqlexception ex) {system.err.println ("conn: " ex.getMessage ());

IF (conn! = null) System.out.Println; Else System.Out.println ("Connection Failure");

Try {stmt = conn.createstatement ();

} Catch (sqlexception ex) {system.err.println ("CreateStatement (); ex.getMessage ());

}

Try {r = stmt.executeQuery ("Select * from userdata);

} Catch (sqlexception ex) {system.err.println ("stmt.excutequery ();" ex.getMessage ());

}

Try {while (rs.next ()) {

System.out.println ("UserName:" rs.getstring (1)); System.out.Println ("Password:" rs.getstring (2)); System.out.Println ("Email:" RS .getstring (3));

}

} Catch (sqlexception ex) {system.err.println ("a error is failure" ex.getMessage ());}

// Test1 (); p = system.getproperties ();

//p.List (System.out); DRV = P.GetProperty ("java.class.path"); //system.out.println ("driver=" drv);

}

Public static void test1 () {CN2 CN2Obj = new CN2 (); printclassname (cn2obj);

Public Static Void PrintClassName (Object Obj) {System.out.Println ("The Class of" Obj "IS" Obj.getClass (). getname ());}

}

Class CN2 {

Public void test () {system.out.println ("1111111111");

}

Public string toString () {Return "1111";

}

转载请注明原文地址:https://www.9cbs.com/read-87643.html

New Post(0)