package database;
import java.sql.ResultSet;
import java.sql.SQLException;

public class DataManipulation {

    DB db = new DB();

    public void InsertData(String name, String password, String userid ){
        String vSQL = " Insert Into usermaster ";
               vSQL += " ( username, password, userid ) values ( ";
               vSQL += " '"+ name +"', ";
               vSQL += " '"+ password +"', ";
               vSQL += " '"+ userid +"' ) ";
        db.ExcuteSQL(vSQL);
    }
    public void UpdateData(String name, String password, String userid ){
        String vSQL = " Update usermaster Set ";
               vSQL += " username = '"+ name +"', ";
               vSQL += " password = '"+ password +"' ";
               vSQL += " where userid = '"+ userid +"' ";
        db.ExcuteSQL(vSQL);
    }

    public void DeleteData(String userid){
        String vSQL = " Delete From usermaster ";
               vSQL += " where userid = '"+ userid +"' ";
        db.ExcuteSQL(vSQL);
    }

    public void getRecords(String userid){
        DB db = new DB();
        ResultSet rs = db.GetResults("Select username From usermaster where userid ='" + userid + "'");
        int vNor = 0;
        try{
            while(rs.next()){
                 System.out.println(rs.getString("username").toString());
            }
            rs.close();
        } catch (SQLException err){
            err.printStackTrace();
        }
    }

}