package assign3;

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

import javax.swing.table.AbstractTableModel;

public class MyDB extends AbstractTableModel {

	private Connection conn;
	private Statement stm;
	private ResultSet resSet;
	private String url = "jdbc:mysql://"+MyDBInfo.MYSQL_DATABASE_SERVER;
	private String user = MyDBInfo.MYSQL_USERNAME;
	private String password = MyDBInfo.MYSQL_PASSWORD;


	public static void main(String[] args) {
		MyDB db = new MyDB();
		System.out.println("nuts");
	}

	public MyDB() {
		try {
			Class.forName("com.mysql.jdbc.Driver");
		} catch (ClassNotFoundException e1) {
			// TODO Auto-generated catch block
			e1.printStackTrace();
		}
		try {
			conn = DriverManager.getConnection(url, user, password);
			stm = (Statement) conn.createStatement();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	public void add(String Metropolis, String Continent, String Population) {
		String q1 = "INSERT INTO metropolises VALUES(\""
					+ Metropolis + "\", \"" + Continent + "\", \"" + Population + "\"";
		try {
			stm.executeUpdate(q1);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	public void search(String Metropolis, String Continent, String Population, String Condition, Boolean Accuracy) {
		String l1 = "SELECT * FROM metropolisis";
		Metropolis = Metropolis == "" ? "%%" : Metropolis;
		Continent = Continent == "" ? "%%" : Continent;
		if(Accuracy == false) {
			Metropolis = "%" + Metropolis + "%";
			Continent = "%" + Continent + "%";
		}
		String l2 = "WHERE Metropolis like \"" + Metropolis + "\"";
		String l3 = " AND Continent like \"" + Continent + "\"";
		String l4 = "";
		if(Population.matches("[0-9]+")) {
			l4 = " AND Population like \"" + Continent + "\"";
		}
		try {
			resSet = stm.executeQuery(l1 + l2 + l3 + l4);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	@Override
	public int getRowCount() {
		// TODO Auto-generated method stub
		return 0;
	}

	@Override
	public int getColumnCount() {
		// TODO Auto-generated method stub
		return 0;
	}

	@Override
	public Object getValueAt(int rowIndex, int columnIndex) {
		// TODO Auto-generated method stub
		return null;
	}


}