ReadRecord

package helper;

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

import db.Building;

public class ReadRecord {

	private Connection connection;
	private ResultSet results;
	private Building building;
	private int buildingID;

	public ReadRecord(String dbName, String uname, String pwd, int pbuildingID){
		String url = "jdbc:mysql://localhost:3306/" + dbName;
		buildingID = pbuildingID;

		try {
			this.connection = DriverManager.getConnection(url, uname, pwd);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

	}

	public void doRead(){
		String query = "select * from building where buildingID = ?";


		try {
			PreparedStatement ps = connection.prepareStatement(query);
			ps.setInt(1, buildingID);

			results = ps.executeQuery();

			results.next();
			building.setBuildingID(results.getInt("BuildingID"));
			building.setBuildingAD(results.getString("Address"));
			building.setBuildingCity(results.getString("City"));
			building.setBuildingSt(results.getString("Statte"));
			building.setBuildingZip(results.getInt("Zip"));
			building.setBuildingContact(results.getString("ContactName"));
			building.setBuildingPhone(results.getString("ContactPhone"));




		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	public Building getBuilding(){
		return building;
	}




}