package jdbc;
import java.sql.Connection;
import java.sql.*;
import java.sql.SQLException;
public class Insert_PreparedStatement {
public static void main(String[] args) throws ClassNotFoundException,SQLException
{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","hr","hr");
//Statement st = con.createStatement();
String query = "insert into JDBC_SAMPLE_FBI values(?,?,?,?)";
PreparedStatement ps = con.prepareStatement(query);
ps.setInt(1, 490);
ps.setString(2, "Amit");
ps.setInt(3, 777);
ps.setInt(4,999);
int res = ps.executeUpdate();
if(res>0)
System.out.println("Values inserted");
con.close();
}
}
import java.sql.Connection;
import java.sql.*;
import java.sql.SQLException;
public class Insert_PreparedStatement {
public static void main(String[] args) throws ClassNotFoundException,SQLException
{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","hr","hr");
//Statement st = con.createStatement();
String query = "insert into JDBC_SAMPLE_FBI values(?,?,?,?)";
PreparedStatement ps = con.prepareStatement(query);
ps.setInt(1, 490);
ps.setString(2, "Amit");
ps.setInt(3, 777);
ps.setInt(4,999);
int res = ps.executeUpdate();
if(res>0)
System.out.println("Values inserted");
con.close();
}
}
No comments:
Post a Comment