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

0 comments:
Post a Comment