Self-practice for JDBC and database Oracle Links

MyEclipse to import new items inside

Right-click >import>general>existing...>next>select root >browse> Project >finish

Guide Jar Package

Right-click >properties>java build Path >libraries>ojdbc14-10.2.0.3.jar

Get the native IP address cmd>ipconfig

The address of the IPv4 is its own address

Class.forName ("Oracle.jdbc.driver.OracleDriver");
String url= "Jdbc:oracle:thin:@127.0.0.1:1521:xe";
String user = "Scott";
String password= "Tiger";
Connection conn = drivermanager.getconnection (Url,user,password);

PreparedStatement Pstam = conn.preparestatement ("SELECT * from UserInfo");

ResultSet rs = Pstam.executequery ();
while (Rs.next ()) {
System.out.println (Rs.getint ("id") +rs.getstring ("name") +rs.getint ("Age"));
}

Pstam.close ();
Conn.close ();

Self-practice for JDBC and database Oracle Links