try{ String sql0 ="SELECT col_p FROM table_a"; PreparedStatement pst0 = conn.prepareStatement(sql0); ResultSet rs0 = pst0.executeQuery(); int colP = rs0.getInt(1); String sql1 ="SELECT col_a FROM table_a WHERE col_a=" + colP; String sql2 ="SELECT col_b FROM table_a WHERE col_b=" + colP; PreparedStatement pst1 = conn.prepareStatement(sql1); ResultSet rs1 = pst1.executeQuery(); int colA = rs1.getInt(1); PreparedStatement pst2 = conn.prepareStatement(sql2); ResultSet rs2 = pst2.executeQuery(); int colB = rs2.getInt(1); String sql3 ="INSERT INTO col_q FROM table_b"; PreparedStatement pst3 = conn.prepareStatement(sql3); int colQ = colA + colB; pst3.setInt(1, colP); pst3.setInt(2, colQ); pst3.executeUpdate(); }catch (Exception e){ System.out.println(e); }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)