Connect

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


public class Connect {
    Connection con;
    Statement st;
    ResultSet rs;
    ResultSetMetaData rsm;
    PreparedStatement pstat;

    public Connect() {
        // TODO Auto-generated constructor stub
        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            con = DriverManager
                    .getConnection("jdbc:odbc:driver={Microsoft Access Driver (*.mdb)}; DBQ=Bluejack_Boutique.mdb");
            st = con.createStatement();
            System.out.println("Connection Successful");
        } catch (Exception e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
            System.out.println("Error Connection");
        }
    }

    public ResultSet executeQuery(String query) {
        try {
            rs = st.executeQuery(query);
            rsm = rs.getMetaData();
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
            System.out.println("Error Connection Result Set");
        }
        return rs;
    }

    public void executeUpdateProduct(String ProductName, Integer ProductPrice, Integer Stock, String ProductID){
        try{
            pstat = con.prepareStatement("UPDATE MsProduct SET ProductName = ? , ProductPrice = ? , Stock = ?, password = ? WHERE ProductID = ");
            pstat.setString(1, ProductName);
            pstat.setInt(2, ProductPrice);
            pstat.setInt(3, Stock);
            pstat.setString(4, ProductID);
            pstat.execute();
        } catch(Exception e){
            // TODO : handle exception
        }
    }

    public void executeDeleteStaff(String id){
        try {
            pstat = con.prepareStatement("DELETE FROM Staff WHERE id = ?");
            pstat.setString(1, id);
            pstat.execute();
        } catch (Exception e) {
            // TODO: handle exception
        }
    }

    public void executeInsertUser(String UserID, String Username, String UserPass, String UserFullName, String UserEmail, String UserPhone, String UserAddress, String UserGender, String Role){
        try {
            pstat = con.prepareStatement("INSERT INTO MsUser(UserID, Username, UserPass, UserFullName, UserEmail, UserPhone, UserAddress, UserGender, Role) VALUES (?,?,?,?,?,?,?,?,?)");
            pstat.setString(1, UserID);
            pstat.setString(2, Username);
            pstat.setString(3, UserPass);
            pstat.setString(4, UserFullName);
            pstat.setString(5, UserEmail);
            pstat.setString(6, UserPhone);
            pstat.setString(7, UserAddress);
            pstat.setString(8, UserGender);
            pstat.setString(9, Role);
            pstat.execute();
        } catch (Exception e) {
            System.out.println("Data Tidak Masuk");
        }
    }

    public Boolean executeLogin(String username, String userpass){
        try{
            pstat = con.prepareStatement("SELECT * FROM MsUser WHERE username = ? and userpass = ?");
            pstat.setString(1, username);
            pstat.setString(2, userpass);
            rs=pstat.executeQuery();
            if(rs.next()) return true;
            else return false;
        } catch (Exception e){

        }
            return false;
    }

    public void executeBuy(String ProductName, Integer ProductPrice, Integer stock){
        try {
            pstat = con.prepareStatement("INSERT INTO MsProduct(ProductName, ProductPrice, Stock) VALUES (?,?,?)");
            pstat.setString(1, ProductName);
            pstat.setInt(2, ProductPrice);
            pstat.setInt(3, stock);
            pstat.execute();
        } catch (Exception e) {
            System.out.println("Data Tidak Masuk");
        }
    }

    public void executeInsertProduct(String ProductName, String ProductPrice, int Stock){
        try {
            pstat = con.prepareStatement("INSERT INTO MsProduct(ProductName, ProductPrice, Stock) VALUES (?,?,?)");
            pstat.setString(1, ProductName);
            pstat.setString(2, ProductPrice);
            pstat.setInt(3, Stock);
            pstat.execute();
        } catch (Exception e) {
            System.out.println("Data Tidak Masuk");
        }
    }


}