Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import java.util.*;
- import java.awt.event.*;
- class student
- {
- public static void main(String k[])
- {
- Scanner sc = new Scanner(System.in);
- System.out.println("Enter name, roll no, cgpa");
- String name=sc.nextLine();
- int roll = sc.nextInt();
- double cgpa = sc.nextDouble();
- try
- {
- Class.forName("com.mysql.jdbc.Driver");
- Connection con= DriverManager.getConnection("jdbc:mysql:@localhost:3306","root","tiger");
- String name1=name.getText();
- int roll1 = Integer.parseInt(roll.getText());
- double cgpa1 = Double.parseDouble(cgpa.getText());
- PreparedStatement p = con.PrepareStatement("insert into k1404 values(? ,?, ? )");
- p.setString(1,name1);
- p.setInt(2,roll1);
- p.setString(3,cgpa1);
- int i=p.executeUpdate();
- }
- catch(Exception e){System.out.print(e)}
- }
- }
Add Comment
Please, Sign In to add comment