import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.Scanner;
public class Test10 {
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", "scott", "rakesh");
PreparedStatement ps = con.prepareStatement("insert into student_register values(?,?,?)");
Scanner scan = new Scanner(System.in);
String ans="yes";
while(ans.equals("yes"))
{
System.out.println("Enter id");
int id = scan.nextInt();
System.out.println("Enter name");
String name = scan.next();
System.out.println("Enter course");
String course = scan.next();
ps.setInt(1, id);
ps.setString(2, name);
ps.setString(3, course);
ps.executeUpdate();
System.out.println("Add more item");
ans=scan.next();
}
}
}
Output -
Enter id
3
Enter name
anjan
Enter course
mca
Add more item
no
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.Scanner;
public class Test10 {
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", "scott", "rakesh");
PreparedStatement ps = con.prepareStatement("insert into student_register values(?,?,?)");
Scanner scan = new Scanner(System.in);
String ans="yes";
while(ans.equals("yes"))
{
System.out.println("Enter id");
int id = scan.nextInt();
System.out.println("Enter name");
String name = scan.next();
System.out.println("Enter course");
String course = scan.next();
ps.setInt(1, id);
ps.setString(2, name);
ps.setString(3, course);
ps.executeUpdate();
System.out.println("Add more item");
ans=scan.next();
}
}
}
Output -
Enter id
3
Enter name
anjan
Enter course
mca
Add more item
no
No comments:
Post a Comment