Package Cn.xvl.test;import Java.sql.connection;import Java.sql.drivermanager;import java.sql.PreparedStatement; Import Java.sql.sqlexception;public class Test {public static void main (string[] args) throws ClassNotFoundException, SQL Exception {class.forname ("Oracle.jdbc.driver.OracleDriver"); Load Database driver string url= "Jdbc:oracle:thin: @localhost: 1521:xe";//connection URLString username = "root"; String password = "123456"; Connection Connection = drivermanager.getconnection (URL, username, password); String sql = "INSERT into Stu values (?)"; PreparedStatement preparestatement = connection.preparestatement (sql);p Reparestatement.setobject (1, 2); int Executeupdate = Preparestatement.executeupdate (); System.out.println (executeupdate);}}
Select value from V$parameter where name= ' instance_name '; Get oracle sid -The xe in the above URL;
oracle Driver directory: installation directory D:\ Oracle\app\oracle\product\11.2.0\server\jdbc\lib gets the
Package cn.xvl.test;
Import Java.sql.connection;import Java.sql.drivermanager;import Java.sql.preparedstatement;import Java.sql.SQLException;
public class Test {public static void main (string[] args) throws ClassNotFoundException, SQLException {class.forname ("Ora Cle.jdbc.driver.OracleDriver "); Load Database driver string url= "Jdbc:oracle:thin: @localhost: 1521:xe";//connection URLString username = "root"; String password = "123456"; Connection Connection = drivermanager.getconnection (URL, username, password); String sql = "INSERT into Stu values (?)"; PreparedStatement preparestatement = connection.preparestatement (sql);p Reparestatement.setobject (1, 2); int Executeupdate = Preparestatement.executeupdate (); System.out.println (executeupdate);}}
JDBC Connects to Oracle database