mysql - how to insert query from the result query to insert query on java netbeans? -

mysql - how to insert query from the result query to insert query on java netbeans? -

i have problems in java progamming, want add together primary key x table insertion query

string sql = "(select id_transaksi transaksi id_transaksi in (select max(id_transaksi) transaksi))" koneksi.stat.executeupdate("insert detail_transaksi values(null,'"+sql+"','"+produk.gettext()+"','"+tgl+"','"+beli.gettext()+"','"+bayar.gettext()+"')");

anyone can help me? want add together result of query insertion query? thanks.

thanks answer, mean, want add together first query sec query, set id table x insert query table y, utilize in java programming.

the things u need are:

step 1) select required value ( primary key) database, can done follows

i) found connection database

eg: class.forname("sun.jdbc.odbc.jdbcodbcdriver"); connection con=drivermanager.getconnection("jdbc:odbc:kkk");

ii) frame suitable query

eg: string sql = "select id_transaksi transaksi id_transaksi in (select max(id_transaksi) transaksi))"

iii) prepare statement

eg: preparedstatement st=con.preparestatement(sql);

iv) execute query , store result in resultset object

eg: resultset rs=st.executequery();

v) retrieve required value(primary key) result set object variable of appropriate datatype.

eg: string my_rqd_value=rs.getstring(“id_transaksi”);

step 2) u have value inserted in variable my_rqd_value can inserted table prefer, follow these steps insert.

i) frame suitable query.

eg: sql = ""insert detail_transaksi values(null,'"+my_rqd_value+"','"+produk.gettext()+"','"+tgl+"','"+beli.gettext()+"','"+bayar.gettext()+"')");

ii) prepare statement.

eg: st=con.preparestatement(sql);

iii) execute query.

rs=st.executeupdate();

java mysql sql netbeans