How to execute two MYSQL queries from netbeans

0

I would like you to help me. How to execute two queries to the same table from netbeans ?. Here the consultations:

insert into tb_horarios(codigopersonal, dia, hora_entrada, hora_salida, 
numero_horas, malla_referencia, prd_codigo, j_codigo) select 
codigo_personal, substring(dia,1,1) AS dia,  min(hora_inicio), 
MAX(hora_fin),COUNT(DISTINCT 
seccion_malla_numerohora),substring(seccion_malla_numerohora,2,1) as malla, 
1,1
from tb_horariodocentes_org
where   substring(seccion_malla_numerohora,1,1)='D' 
GROUP by codigo_personal,dia
ORDER by 2,3,5


insert into tb_horarios(codigopersonal, dia, hora_entrada, hora_salida, 
numero_horas, malla_referencia, prd_codigo) select codigo_personal, 
substring(dia,1,1) AS dia, min(hora_inicio), MAX(hora_fin),COUNT(DISTINCT 
seccion_malla_numerohora),substring(seccion_malla_numerohora,2,1) as malla, 
tb_periodo.codigo
from tb_horariodocentes_org, tb_periodo
where   substring(seccion_malla_numerohora,1,1)='N' and 
tb_periodo.codigo='2'
GROUP by codigo_personal,dia
ORDER by 2,3,5

Here what I was trying:

public void PasarDatosHorarios()
{

    String consulta="insert into tb_horarios(codigopersonal, dia, 
   hora_entrada, hora_salida, numero_horas, malla_referencia, prd_codigo, 
   j_codigo) select codigo_personal, substring(dia,1,1) AS dia,  
   min(hora_inicio), MAX(hora_fin),COUNT(DISTINCT 
   seccion_malla_numerohora),substring(seccion_malla_numerohora,2,1) as 
   malla, 1,1\n" +
                    "from tb_horariodocentes_org\n" +
                    "where   substring(seccion_malla_numerohora,1,1)='D' \n" 
                     +
                    "GROUP by codigo_personal,dia\n" +
                    "ORDER by 2,3,5";

    String consulta1="insert into tb_horarios(codigopersonal, dia, 
   hora_entrada, hora_salida, numero_horas, malla_referencia, prd_codigo) 
   select codigo_personal, substring(dia,1,1) AS dia, min(hora_inicio), 
   MAX(hora_fin),COUNT(DISTINCT 
   seccion_malla_numerohora),substring(seccion_malla_numerohora,2,1) as 
   malla, tb_periodo.codigo\n" +
                    "from tb_horariodocentes_org, tb_periodo\n" +
                    "where   substring(seccion_malla_numerohora,1,1)='N' and 
    tb_periodo.codigo='2'\n" +
                    "GROUP by codigo_personal,dia\n" +
                    "ORDER by 2,3,5";
    try 
    {
        Statement st = cn.createStatement();
        ResultSet rs = st.executeQuery(consulta);
        if(rs.next())
        {
             Statement nuevostmt = cn .createStatement();
            ResultSet rs2 = nuevostmt.executeQuery(consulta1);
            while(rs2.next()) 
            {
                System.out.println("");
            }
        }

    } catch (Exception e) {
    }
  }
    
asked by vero m. 21.02.2018 в 16:07
source

1 answer

1

In your case it is very simple. Just create a Statement and add the queries with the addBatch(String query) method:

Statement st = cn.createStatement();
st.addBatch(consulta);
st.addBatch(consulta1);
st.executeBatch();

If you want to know more about this topic, google this search criteria: "execution in batch jdbc".

    
answered by 21.02.2018 / 19:29
source