Project PBO

/**************************************/

package ujian;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.Statement;

import java.sql.SQLException;

import java.util.Scanner;

public class input {

//tampilan insert data

void input(){

        //int no;

        String tanggal;

        String keterangan;

        int jumlah;

      

        Scanner input = new Scanner(System.in);

     

        //System.out.print("Masukkan no            : ");

        //no = input.nextInt();

        System.out.print("Masukkan tanggal       : ");

        tanggal = input.next();

        System.out.print("Masukkan keterangan    : ");

        keterangan = input.next();

        System.out.print("Masukkan jumlah        : ");

        jumlah = input.nextInt();

{

try {

        koneksi k = new koneksi();

            String db="jdbc:mysql://localhost:3306/ujian";

            Connection koneksi=DriverManager.getConnection(db,"root","");

            //System.out.println("koneksi database berhasil");

            Statement perintah=koneksi.createStatement();

         perintah.executeUpdate ("insert into uj_05296(tanggal,keterangan,jumlah)"

        + " value ('"+tanggal+"','"+keterangan+"','"+jumlah+"');");

System.out.println("Inputan berhasil");

        } catch (Exception e) {

            System.out.println("Inputan gagal");

        }}     }}

/**************************************/

Main project

package ujian;

public class Ujian {

    public static void main(String[] args) {

        koneksi k = new koneksi();

        k.koneksi();

        input i = new input();

        i.input();

        output o = new output();

        o.output();

    }

}

 /**************************************/

package ujian;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.*;

public class koneksi {

void koneksi(){

try {

    String db="jdbc:mysql://localhost:3306/ujian";

    Connection koneksi=DriverManager.getConnection(db,"root","");

    System.out.println("koneksi database berhasil");

}catch(Exception e){

    System.out.println("kode salah"+e);

    System.out.println("Koneksi GAGAL.!!!!");

      

    }   

  }

}

/**************************************/

package ujian;

import com.mysql.jdbc.Statement;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

public class output {

void output(){

try{

koneksi k = new koneksi();

Connection kon = DriverManager.getConnection("jdbc:mysql://localhost:3306/ujian?user=root&password=");

String sql ="SELECT * FROM uj_05296";

java.sql.Statement ste = kon.createStatement();

ResultSet rs = ste.executeQuery(sql);

while(rs.next()){

System.out.println("");

System.out.println("no              : " + rs.getInt("no"));

System.out.println("tanggal         : " + rs.getInt("tanggal"));

System.out.println("keterangan      : " + rs.getString("keterangan"));

System.out.println("jumlah          : " + rs.getInt("jumlah"));

System.out.println(" ");

    }

rs.close();

ste.close();

}catch(Exception e){

    }

  }

}