package jdbc_demo;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.Properties;

public class Jdbc_demo {

    /**
     * @param args the command line arguments
     */
    public static void main(String[] args) {
        Connection conn2 = null;

        try {

            // connect way #2
            String url2 = "jdbc:mysql://localhost/test?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC";
            conn2 = DriverManager.getConnection(url2);
            if (conn2 != null) {
                System.out.println("Connected to the database test2");
            }

            String sql = "INSERT INTO Users (no, nama barang , stok , tanggal masuk) VALUES (?, ?, ?, ?)";

            PreparedStatement statement = conn2.prepareStatement(sql);
            statement.setString(1, "1");
            statement.setString(2, "sarung");
            statement.setString(3, "40");
            statement.setString(4, "21-06-2018");

            int rowsInserted = statement.executeUpdate();
            if (rowsInserted > 0) {
                System.out.println("A new user was inserted successfully!");
            }

        } catch (SQLException ex) {
            ex.printStackTrace();
        }
    }

}