package org.webapp.engine;

import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.util.Vector;

import javax.swing.table.DefaultTableModel;

public class users extends db {

	String sql;
	ResultSet rs;
	PreparedStatement st;		//this "PreparedStatement" is a class

	public users() {			//every time after create constructor ('users()' is constructor)...need to initialize/give value the variable
		sql = null;
		rs = null;
		st = null;

	}

	public boolean validate(String username, String password) {

		try {
			sql = "select fullname from users where";
			sql = sql +" username=? and password=?";
			st = con.prepareStatement(sql);				//this part "prepareStatement" is a method //its the security way for calling username&password tht user just insert from dtbs
			st.setString(1, username);					// no "1" is referring to 1st question mark at username, & ....
			st.setString(2, password);					// no "2" is referring to 2nd question mark at password
			rs = st.executeQuery();

			if (rs.next()) {
				return true;
			}
			else {
				return false;
			}
		}
		catch (SQLException e) {
			e.printStackTrace();
			return false;
		}
	}

	public boolean adduser(String username, String password, String fullname) {
		try {
			sql="insert into users(username,password,fullname)";
			sql=sql+" values(?,?,?)";
			st=con.prepareStatement(sql);
			st.setString(1,username);
			st.setString(2,password);
			st.setString(3,fullname);

			if (st.executeUpdate()==1) {
				return true;
			}
			else {
				return false;
			}
		}
		catch(Exception e) {
			e.printStackTrace();
			return false;
		}
	}

	public boolean update(String username, String fullname) {
        try {
            sql= "update users";
            sql = sql +" set fullname=? where username=?";
            st=con.prepareStatement(sql);
            st.setString(1,fullname);
            st.setString(2,username);

            if (st.executeUpdate()==1) {
                return true;
            }
            else {
                return false;
            }
        }

        catch(Exception e) {
            e.printStackTrace();
            return false;
        }
    }

	public ResultSet getusers() {

		try {
			sql = "select userid, username, fullname from users";
			st = con.prepareStatement(sql);
			rs = st.executeQuery();
			return rs;
		}
		catch (SQLException e) {
			e.printStackTrace();
		}
		return null;
	}

	public static DefaultTableModel buildTableModel(ResultSet rs) throws SQLException {

	    ResultSetMetaData metaData = rs.getMetaData();

	    // names of columns
	    Vector<String> columnNames = new Vector<String>();
	    int columnCount = metaData.getColumnCount();
	    for (int column = 1; column <= columnCount; column++) {
	        columnNames.add(metaData.getColumnName(column));
	    }

	    // data of the table
	    Vector<Vector<Object>> data = new Vector<Vector<Object>>();
	    while (rs.next()) {
	        Vector<Object> vector = new Vector<Object>();
	        for (int columnIndex = 1; columnIndex <= columnCount; columnIndex++) {
	            vector.add(rs.getObject(columnIndex));
	        }
	        data.add(vector);
	    }

	    return new DefaultTableModel(data, columnNames);

	}
}