Java DB Ariezs11 rwxr-xr-x 0 00.24

Filename	Java DB
Permission	rw-r--r--
Author	Ariezs11
Date and Time	00.24
Label
Action

import java.sql.*;
    public class DBPertamaku
    {
        public static void main(String [] riny) throws Exception
        {
            Class.forName("org.sqlite.JDBC");
            Connection conn = DriverManager.getConnection("jdbc:sqlite:latihan1.db");
            Statement stat = conn.createStatement();
            stat.executeUpdate("drop table if exists mhs;");
            stat.executeUpdate("create table mhs(npm varchar(15),nama varchar(50));");
            PreparedStatement prep = conn.prepareStatement("insert into mhs values(?, ?);");
            prep.setString(1,"200643500107");
            prep.setString(2,"Budi");
            prep.addBatch();
            prep.setString(1,"200643500116");
            prep.setString(2,"Agung");
            prep.addBatch();
            prep.setString(1,"200643500148");
            prep.setString(2,"Achmad");
            prep.addBatch();
           
            conn.setAutoCommit(false);
            prep.executeBatch();
            conn.setAutoCommit(true);
           
            ResultSet rs = stat.executeQuery("Select * from mhs;");
            System.out.println("NPM\t\t Nama");
            while (rs.next())
            {
                System.out.print( rs.getString("npm"));
                System.out.println( "\t"+rs.getString("nama"));
            }
            rs.close();
            conn.close();
        }
    }





Sumber : dejavu.blogspot.com