Main.java Source code

Introduction

Here is the source code for Main.java

Source

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class Main {
    public static void main(String[] args) throws ClassNotFoundException, SQLException {
        Class.forName("com.mysql.jdbc.Driver");
        Connection conn = DriverManager.getConnection("jdbc:mysql://localhost/booltest", "booltest", "booltest");
        conn.prepareStatement("create table booltest (id bigint, truefalse varchar(10));").execute();
        PreparedStatement stmt = conn.prepareStatement("insert into booltest (id, truefalse) values (?, ?);");
        stmt.setLong(1, (long) 123);
        stmt.setBoolean(2, true);
        stmt.execute();
        stmt.setLong(1, (long) 456);
        stmt.setBoolean(2, false);
        stmt.execute();
        ResultSet rs = conn.createStatement().executeQuery("select id, truefalse from booltest");
        while (rs.next()) {
            System.out.println(rs.getLong(1) + " => " + rs.getBoolean(2));
        }
    }
}