Update and query database instances using JDBC

Use JDBC to update and query database instances:

PackageOrg. Oracle. insert; ImportJava. SQL. Connection; ImportJava. SQL. DriverManager; ImportJava. SQL. ResultSet; ImportJava. SQL. Statement; Public ClassInsertDeom { Public Static FinalString DBDRIVER ="Oracle. jdbc. driver. OracleDriver"; Public Static FinalString DBURL ="Jdbc: oracle: thin: @ 127.0.0.1: 1521: ORCL"; Public Static FinalString DBUSER ="Scott"; Public Static FinalString DBPASS ="Tiger"; Public Static VoidMain (String [] args)ThrowsException { Connection conn =Null; Statement stmt =Null; Class. forName (DBDRIVER ); Conn = DriverManager. getConnection (DBURL, DBUSER, DBPASS ); Stmt = conn. createStatement (); String SQL ="Insert into person (name, age, birthday, salary) values ('wang wu', 22, TO_Date ('2017-2-22 ', 'yyyy-mm-dd'), 1986)"; Stmt.exe cuteUpdate (SQL ); Stmt. close (); Conn. close (); } }

 

PackageOrg. oracle. select; ImportJava. SQL. Connection; ImportJava. SQL. DriverManager; ImportJava. SQL. ResultSet; ImportJava. SQL. Statement; Public ClassResultDeom { Public Static FinalString DBDRIVER ="Oracle. jdbc. driver. OracleDriver"; Public Static FinalString DBURL ="Jdbc: oracle: thin: @ 127.0.0.1: 1521: ORCL"; Public Static FinalString DBUSER ="Scott"; Public Static FinalString DBPASS ="Tiger"; Public Static VoidMain (String [] args)ThrowsException { Connection conn =Null; Statement stmt =Null; ResultSet rs =Null; Class. forName (DBDRIVER ); Conn = DriverManager. getConnection (DBURL, DBUSER, DBPASS ); Stmt = conn. createStatement (); // Stmt.exe cuteUpdate ("insert into person (name, age, birthday, salary) values ('lily', 22, TO_Date ('2017-2-22 ', 'yyyy-mm-dd'), 4000 )"); Rs = stmt.exe cuteQuery ("Select name, age, birthday, salary from person"); While(Rs. next ()){ System. out. print ("Name :"+ Rs. getString ("Name") +"."); System. out. print ("Age :"+ Rs. getInt ("Age") +"."); System. out. print ("Birthday :"+ Rs. getDate ("Birthday") +"."); System. out. println ("Salary :"+ Rs. getFloat ("Salary") +"."); } Rs. close (); Stmt. close (); Conn. close (); } }