Breaking News
Loading...
Wednesday, 29 April 2015

Program java dengan SQLITE sederhana



















import java.util.*;
import javax.swing.*;
import java.sql.*;
public class program_java_with_SQLITE{
    public static void main(String [] rlx) throws Exception {
        Class.forName("org.sqlite.JDBC");
        Connection conn =DriverManager.getConnection("jdbc:sqlite:latihan.db");
        Statement stat=conn.createStatement();
        stat.executeUpdate("create table IF NOT EXISTS mhs(nama varchar(20),npm integer(12));");
        PreparedStatement prep=conn.prepareStatement("insert into mhs values(?,?);");
       
        Scanner input = new Scanner (System.in);
        System.out.print("Masukan Nama : " );
        String nama =input.nextLine();
        prep.setString(1,nama);
      
        System.out.print("Masukan NPM  : " );
        String npm =input.nextLine();
        prep.setString(2,npm);
        prep.addBatch();
        prep.executeBatch();

        ResultSet rs=stat.executeQuery("select *from mhs;");
        System.out.println("\n\nOUT PUT");
        System.out.println("============================================\n");
        // untuk melihat isi database
       System.out.println("Nama \t\t \tNPM ");
        while (rs.next()){
           System.out.print(rs.getString("nama"));
            System.out.println("\t\t\t"+rs.getString("npm"));
        }
        rs.close();
        JOptionPane.showMessageDialog(null,"Input Sukses !! ");
       conn.close();
       //source by ryanlx
    }
}

Output

       
Next
This is the most recent post.
Older Post

0 comments:

Post a Comment

 
Toggle Footer