fork download
copy 
  1. import java.sql.*;
  2. import java.util.Scanner;
  3. public class Main{
  4.   public static void main(String[]args){
  5.     final String DRIVER = "com.mysql.jdbc.Driver";
  6.     final String DB_URL = "jdbc:mysql://localhost/school?serverTimezone=UTC";
  7.     final String DB_USER = "root";
  8.     final String DB_PASS = "password";
  9.  
  10.     Connection conn = null;
  11.     PreparedStatement psInsert = null, psUpdate = null, psDelete = null, psSelect = null;
  12.     Scanner sc = new Scanner(System.in);
  13.  
  14.     try{
  15.         Class.forName(DRIVER);
  16.     }
  17.     catch(ClassNotFoundException e){
  18.         System.out.println("Unable to load driver");
  19.         e.printStackTrace();
  20.         return;
  21.     }
  22.  
  23.     try{
  24.         conn = DriverManager.getConnection(DB_URL, DB_USER, DB_PASS);
  25.         psInsert = conn.prepareStatement("INSERT INTO students (name, year_level, program) VALUES(?, ?, ?)");
  26.         psUpdate = conn.prepareStatement("UPDATE students SET name = ?, year_level = ?, program = ? WHERE id = ?");
  27.         psDelete = conn.prepareStatement("DELETE FROM students WHERE id = ?");
  28.         psSelect = conn.prepareStatement("SELECT * FROM students");
  29.     }
  30.     catch(SQLException e){
  31.         System.out.println("Unable to connect to database");
  32.         e.printStackTrace();
  33.         return;
  34.     }
  35.  
  36.     int choice = 0;
  37.     do{
  38.         System.out.println("Student Data Manager");
  39.         System.out.println("1. Insert");
  40.         System.out.println("2. Update");
  41.         System.out.println("3. Delete");
  42.         System.out.println("4. View");
  43.         System.out.println("5. Exit");
  44.         System.out.print("Enter choice: ");
  45.         choice = sc.nextInt();
  46.         if(choice == 1){
  47.             System.out.print("Enter name: ");
  48.             String name = sc.next();
  49.             System.out.print("Enter year level: ");
  50.             int yearLevel = sc.nextInt();
  51.             System.out.print("Enter program: ");
  52.             String program = sc.next();
  53.             try{
  54.               psInsert.setString(1, name);
  55.               psInsert.setInt(2, yearLevel);
  56.               psInsert.setString(3, program);
  57.               psInsert.executeUpdate();
  58.             }
  59.             catch(SQLException e){
  60.               System.out.println("Unable to execute SQL statement");
  61.               e.printStackTrace();
  62.             }
  63.         }
  64.         else if(choice == 2){
  65.             System.out.print("Enter id: ");
  66.             int id = sc.nextInt();
  67.             System.out.print("Enter name: ");
  68.             String name = sc.next();
  69.             System.out.print("Enter year level: ");
  70.             int yearLevel = sc.nextInt();
  71.             System.out.print("Enter program: ");
  72.             String program = sc.next();
  73.             try{
  74.               psUpdate.setString(1, name);
  75.               psUpdate.setInt(2, yearLevel);
  76.               psUpdate.setString(3, program);
  77.               psUpdate.setInt(4, id);
  78.               psUpdate.executeUpdate();
  79.             }
  80.             catch(SQLException e){
  81.               System.out.println("Unable to execute SQL statement");
  82.               e.printStackTrace();
  83.             }
  84.         }
  85.         else if(choice == 3){
  86.             System.out.print("Enter id: ");
  87.             int id = sc.nextInt();
  88.             try{
  89.               psDelete.setInt(1, id);
  90.               psDelete.executeUpdate();
  91.             }
  92.             catch(SQLException e){
  93.               System.out.println("Unable to execute SQL statement");
  94.               e.printStackTrace();
  95.             }
  96.         }
  97.         else if(choice == 4){
  98.             System.out.println("Student List");
  99.             try{
  100.               ResultSet rs = psSelect.executeQuery();
  101.               while(rs.next()){
  102.                 int id = rs.getInt("id");
  103.                 String name = rs.getString("name");
  104.                 int yearLevel = rs.getInt("year_level");
  105.                 String program = rs.getString("program");
  106.                 System.out.println("Student id = " + id + ", name = " + name + ", year level = " + yearLevel + ", program = " + program);
  107.               }
  108.             }
  109.             catch(SQLException e){
  110.               System.out.println("Unable to execute SQL statement");
  111.               e.printStackTrace();
  112.             }
  113.         }
  114.         else if(choice == 5){
  115.           System.out.println("Program Terminated!");
  116.         }
  117.         else{
  118.           System.out.println("Invalid Choice!");
  119.         }
  120.     }while(choice != 5);
  121.  
  122.     try{
  123.         psInsert.close();
  124.         psUpdate.close();
  125.         psDelete.close();
  126.         psSelect.close();
  127.         conn.close();
  128.     }catch(SQLException e){
  129.         System.out.println("Unable to close connections");
  130.         e.printStackTrace();
  131.     }catch(NullPointerException e){}
  132.   }
  133. }
Success #stdin #stdout #stderr 0.16s 56844KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
Unable to load driver
stderr
copy 
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
	at java.base/jdk.internal.loader.BuiltinClassLoader.loadClass(BuiltinClassLoader.java:583)
	at java.base/jdk.internal.loader.ClassLoaders$AppClassLoader.loadClass(ClassLoaders.java:178)
	at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:521)
	at java.base/java.lang.Class.forName0(Native Method)
	at java.base/java.lang.Class.forName(Class.java:332)
	at Main.main(Main.java:15)
https://ideone.com/4pRhnJ
language:
Java (HotSpot 12)
created:
16 days ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!