import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.Date;

public class Main {
    private static String getCurrentTimeStamp() {
        Date today = new Date();
        DateFormat dateFormat =new SimpleDateFormat("yy/mm/dd");
    return dateFormat.format(today.getTime()); }
    private static void createDbUserTable() throws SQLException {
        Connection dbConnection = null;
        Statement statement = null;

        String createTableSQL = "CREATE TABLE TEST("
                + " post_id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,\n"
                + "USERNAME VARCHAR(20) NOT NULL,\n "
                + "CREATED_BY VARCHAR(20) NOT NULL,\n "
                + "CREATED_DATE DATE NOT NULL )";
        String insertTableSQL = "INSERT INTO TEST "
                + "(USERNAME, CREATED_BY, CREATED_DATE) "
                +"VALUES" +"('mkyeonge','SSSyestem', " + " datetime('now'))";
        try {
            dbConnection = DriverManager.getConnection("jdbc:sqlite:C:\\Users\\SMS\\Desktop\\221\\first2,0.db");
            statement = dbConnection.createStatement();
            statement.execute(createTableSQL);
            System.out.println("Table \"TEST\" is created!");

        } catch (SQLException e) {
            System.out.println(e.getMessage());
        }
try {
    dbConnection = DriverManager.getConnection("jdbc:sqlite:C:\\Users\\SMS\\Desktop\\221\\first2,0.db");
    statement = dbConnection.createStatement();
    statement.execute(insertTableSQL);
    System.out.println("Table \"TEST\" is Update!");
}
catch (SQLException f){
    System.out.println(f.getMessage());
}
        finally {
            if (statement != null) {
                statement.close();
            }
            if (dbConnection != null) {
                dbConnection.close();
            }
        }
    }
    public static void main(String[] argv) {
        try {
            createDbUserTable();
        } catch (SQLException e) {
            System.out.println(e.getMessage());
        }
    }
}