package enefro.interop.SQL;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import enefro.interop.bean.OrganizationBean;
public class OrganizationSQL {
public static OrganizationBean getOrganizationById(int id)
{
OrganizationBean organization=null;
try
{
Class.forName("org.postgresql.Driver");
String usuario = "enefro_owner";
String password = "enefro_owner";
String url = "jdbc:postgresql://gibserv.us.es:4502/enefro";
Connection conexion = DriverManager.getConnection(url, usuario, password);
Statement st = conexion.createStatement();
ResultSet rs = st.executeQuery("select * from e_organizationelement where orga_id='"+id+"'" );
while (rs.next())
{
organization = new OrganizationBean();
organization.setIdOrganizacion(rs.getInt("orga_id"));
organization.setNombre(rs.getString("orga_name"));
organization.setDireccion(rs.getString("orga_address"));
organization.setTelefono(rs.getString("orga_telefono"));
organization.setTelecom(rs.getString("orga_telcom"));
}
rs.close();
st.close();
conexion.close();
}
catch (Exception e)
{
e.printStackTrace();
}
return organization;
}
}
e-REdING. Biblioteca de la Escuela Superior de Ingenieros de Sevilla.
