package Javaapplication2;import Java.sql.connection;import Java.sql.drivermanager;import Java.sql.resultset;import Java.sql.sqlexception;import java.sql.PreparedStatement; public class JavaApplication2 {public static void main (string[] args) throws ClassNotFoundException, SQLException {Class.forName ("oracle.jdbc.driver.OracleDriver"); String url= "Jdbc:oracle:thin:@//10.98.0.62:1521/wdpis"; Connection conn=drivermanager.getconnection (URL, "qu", "query"); PreparedStatement pst=conn.preparestatement ("Select Item_no,batch_no,seq_no from Dt_out_att"); ResultSet Rs=pst.executequery (); while (Rs.next ()) {System.out.print ("Item_no:" +rs.getstring ("Item_no")); System.out.print ("Batch_no:" +rs.getstring ("Batch_no")); System.out.println ("Seq_no:" +rs.getstring ("Seq_no")); } rs.close (); Pst.close (); Conn.close (); } }
Java even Oracle 12C start _preparedstatement