package webStore;


import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.LinkedList;


public class WebManual {

	public static final String USERNAME = MyDBInfo.MYSQL_USERNAME;
	public static final String PASSWORD = MyDBInfo.MYSQL_PASSWORD;
	public static final String DATABASE_SERVER = MyDBInfo.MYSQL_DATABASE_SERVER;
	public static final String DATABASE_NAME = MyDBInfo.MYSQL_DATABASE_NAME;

	private Statement stmt;
	private ArrayList<String> productID;

	public WebManual() {
		try {
			Class.forName("com.mysql.jdbc.Driver");
			this.stmt = DriverManager.getConnection("jdbc:mysql://" + DATABASE_SERVER, USERNAME, PASSWORD).createStatement();
			this.stmt.executeQuery("USE "+ DATABASE_NAME);
			productID = new ArrayList<String>();
			productID();
		} catch (SQLException | ClassNotFoundException e) {
			e.printStackTrace();
		}
	}

	public int getSize() {
		return productID.size();
	}

	private void productID() {
		try {

			ResultSet st = stmt.executeQuery("SELECT * FROM products;");
			while(st.next()) {
				productID.add(st.getString(1));
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	public String getProductId(int i) {
		return productID.get(i);
	}

	public String getProductName(String id) {
		try {
			ResultSet st = stmt.executeQuery("SELECT name FROM products where productid = "+"\""+id+"\""+";");
			st.next();
			return st.getString(1);
		} catch (SQLException e1) {
			e1.printStackTrace();
		}
		return "";
	}

	public String getProductIdByName(String name) {
		try {
			ResultSet st = stmt.executeQuery("SELECT productid FROM products where name = "+"\""+name+"\""+";");
			st.next();
			return st.getString(1);
		} catch (SQLException e1) {
			e1.printStackTrace();
		}
		return "";
	}

	public String getImageSrc(String id) {
		try {
			ResultSet st = stmt.executeQuery("SELECT imagefile FROM products where productid = "+"\""+id+"\""+";");
			st.next();
			return st.getString(1);
		} catch (SQLException e1) {
			e1.printStackTrace();
		}
		return "";
	}
	public double getPrice(String id) {
		try {
			ResultSet st = stmt.executeQuery("SELECT price FROM products where productid = "+"\""+id+"\""+";");
			st.next();
			return st.getDouble(1);
		} catch (SQLException e1) {
			e1.printStackTrace();
		}
		return 0;
	}
}