TomCat

package PaginasJsp;

import java.util.*;
import java.io.*;
import java.sql.*;
import java.sql.PreparedStatement;
import java.sql.SQLException;

public class SelectEdita {
  
   protected static String retorno = "";
   
   protected static String pageSelect(String data, int sala, int turno) {
      
      StringBuffer html = new StringBuffer();
                     
     
              
   try {
      
      //Cria conexão com a base de dados
         
      Connection con = DataConnect.connectDb();
      
      String sql = "select s.cd_servico as scd_servico, s1.cd_servico as cd_servico, s1.ds_servico as ds_servico, e.cd_escala as cd_escala, " +
                   "e.cd_sal_cir as cd_sal_cir, e.tp_turno as tp_turno " +
                   "from dbamv.escala_cirurgia e, dbamv.servico s, dbamv.servico s1 " +
                   "where e.dt_escala = ? " +
                   "and e.cd_sal_cir = ? " +
                   "and e.tp_turno = ? " +
                   "and e.cd_servico = s.cd_servico(+) " +
                   "and s1.sn_pre_internacao = 'S'";
      
      PreparedStatement stmt = con.prepareStatement(sql);
             
        ResultSet rs = null;
        
        stmt.setString(1,data);
        stmt.setInt(2,sala);
        stmt.setInt(3,turno);
        
        //faz primeira busca no banco de dados
        
        rs = stmt.executeQuery();
        
        if (rs.next() == false){
                   
         html.append("null");
            
        } else {        
        
             html.append("<select name=\"esc_servico\">");
      
             html.append("<option value=\"0:0:"+ data + ":" + sala + ":" + turno + "\">");
            
             while (rs.next()){
            
             int cd_escala = rs.getInt("cd_escala");
             int ecd_servico = rs.getInt("cd_servico");
             int scd_servico = rs.getInt("scd_servico");
             String sds_servico = rs.getString("ds_servico");
                                                             
              html.append("<option value=\"");
              html.append(cd_escala);
              html.append(":"+ecd_servico);
              html.append(":"+data);
              html.append(":"+sala);
              html.append(":"+turno);
              html.append("\"");                 
                                                                                          
              if ( scd_servico == ecd_servico){                
              html.append(" selected");
              } 
                                       
              html.append(">");
              html.append(sds_servico);
              }      
             
             
              html.append("</select>"); 
                
        }
        rs.close();
   //tenta fechar a conexão com o banco de dados
      
   try {
            
    con.close();
      
      } catch(Exception e)  {
           
      e.printStackTrace();
            
      }
   //pega erro (se houver na query)
            
  	 } catch(SQLException e) {
      
             System.err.println("SQLException: " + e.getMessage());
     //e.printStackTrace();
     
   	}
  //fecha select
       

   retorno = html.toString();
    
   return retorno;
   
   }
 
}