package model;

import java.sql.*;
import java.util.*;

public class DBTeacher {

	public ArrayList<Teacher> searchTeachers(String school){


		try{

			// Step1: Load JDBC Driver
			Class.forName("com.mysql.jdbc.Driver");
			// Step 2: Define Connection URL
			String connURL = "jdbc:mysql://localhost/dblect3?user=root&password=root";
			// Step 3: Establish connection to URL
			Connection conn = DriverManager.getConnection(connURL);

			//String sql="Select * from teacher where school= '"+ school + "'";
			//Statement stmt=conn.createStatement();

			//ResultSet rs=stmt.executeQuery(sql);

			String sql="Select * from teacher where school=?";
			PreparedStatement pstmt=conn.prepareStatement(sql);

			pstmt.setString(1, school);
			ResultSet rs=pstmt.executeQuery();
			//out.println("<table border='1'");

			while(rs.next()){

				String staffid=rs.getString("staffid");
				String name=rs.getString("name");
				String email=rs.getString("email");
		}



	}catch (Exception e){
		System.out.println(e);
		return null;
	}

}