package pkgDB;

import java.sql.*;

public class DB implements dbrules {
    private static final String DBURL = "jdbc:mysql://localhost:3306/";
    private static final String DBUsername = "root";
    private static final String DBPassword = "sa";
    private String DBName = "mydatabase";
    Connection con = null;
    Statement st= null;
    ResultSet rs = null;

    public DB(){
         try{
            String ConnString;
            ConnString = DBURL + DBName + "?user=" + DBUsername + "&password=" + DBPassword;
            con = DriverManager.getConnection(ConnString);

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

    public void InsertRecord(String vSQL) {
        try{
               st = con.createStatement();
               st.execute(vSQL);

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

    public void UpdateRecord(String vSQL) {
        try{
               st = con.createStatement();
               st.execute(vSQL);

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

    public void DeleteRecord(String vSQL) {
        try{
               st = con.createStatement();
               st.execute(vSQL);

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

    public ResultSet GetResultSet(String vSQL){
         try{
              st = con.createStatement();
              rs = st.executeQuery(vSQL);
         }catch (Exception e){
             e.printStackTrace();
         }
         return rs;
    }



}