import java.sql.*;

import java.util.Properties;



public class testAccessSpeed5 {

    public static void main(String argv[]) {

        try {

            Class.forName("com.hxtt.sql.access.AccessDriver");

            String url = "jdbc:Access:/d:/temp";

            Connection con = DriverManager.getConnection(url, new Properties());



            if (false) { //init database

                Statement astat = con.createStatement();

                astat.execute("create database testspeed");



                astat.executeUpdate(" create table testspeed.Tabella1  (id int unique, testo1  varchar(10), testo2  varchar(20),testo3  varchar(30));");

                astat.close();



                con.setCatalog("testspeed.mdb");



                PreparedStatement ps = con.prepareStatement(

                    "insert into Tabella1  (id, testo1,testo2,testo3) values(?,?,?,?);");



                for (int i = 1; i <= 50000; i++) {

                    ps.setInt(1, i); //id

                    ps.setString(2, "Red" + i); //testo1

                    ps.setString(3, "Black" + i); //testo2

                    ps.setString(4, "Yellow" + (i % 100)); //testo3

                    ps.executeUpdate();

                }



                ps.close();

            }



            con.setCatalog("testspeed.mdb");



            Statement stmt = con.createStatement();



            String s;

            ResultSet rs;



            s="empty";

            long t=System.nanoTime();

            rs = stmt.executeQuery("SELECT ID FROM Tabella1 WHERE ID = 1");

            if(rs.next()) s = rs.getString(1);

            float endTime=(float)(System.nanoTime()-t)/1000000F;

            System.out.println(s+" "+endTime+"ms");



            t=System.nanoTime();

            rs = stmt.executeQuery("SELECT testo1 FROM Tabella1 WHERE ID = 2");

            if(rs.next()) s = rs.getString(1);

            endTime=(float)(System.nanoTime()-t)/1000000F;

            System.out.println(s+" "+endTime+"ms");



            t=System.nanoTime();

            rs = stmt.executeQuery("SELECT testo2 FROM Tabella1 WHERE ID = 5");

            if(rs.next()) s = rs.getString(1);

            endTime=(float)(System.nanoTime()-t)/1000000F;

            System.out.println(s+" "+endTime+"ms");



            t=System.nanoTime();

            rs = stmt.executeQuery("SELECT testo3 FROM Tabella1 WHERE ID = 7");

            if(rs.next()) s = rs.getString(1);

            endTime=(float)(System.nanoTime()-t)/1000000F;

            System.out.println(s+" "+endTime+"ms");





            stmt.close();

            con.close();

        }

        catch (SQLException sqle) {

            do {

                System.out.println(sqle.getMessage());

                System.out.println("Error Code:" + sqle.getErrorCode());

                System.out.println("SQL State:" + sqle.getSQLState());

                sqle.printStackTrace();

            }

            while ( (sqle = sqle.getNextException()) != null);

        }

        catch (Exception e) {

            System.out.println(e.getMessage());

            e.printStackTrace();

        }

    }

}