i have created select -where subquery inside insert query no updates visible in database.
i need first select value database , pass selected value database , pass selected value in query value mysql database.
here sample code
<%@ page import="javax.servlet.http.httpsession" %> <%@ page import="java.util.*,java.sql.*" %> <%@ page import="javax.servlet.http.httpsession" %> <%@page import="com.dbutil.crudoperation"%> <%@page contenttype="text/html" pageencoding="utf-8"%> <!doctype html> <html> <head> <meta http-equiv="content-type" content="text/html; charset=utf-8"> <link rel="stylesheet" href="css/bootstrap.min.css"> <link rel="stylesheet" href="css/fullview.css"> <script src="jquery.js"></script> <script src="bootstrap.min.js"></script> <title>job details</title> </head> <body> <% connection con = null; resultset rs = null; preparedstatement ps = null; httpsession hs = null; con = crudoperation.createconnection(); hs = request.getsession(); string value=request.getparameter("idjob"); string id = (string) hs.getattribute("userinfo"); %> <div class="container"> <%string strsql = "select name register uname=?"; try { ps=con.preparestatement(strsql); ps.setstring(1, id); int rw1=ps.executeupdate(); if(rw1>0) { con.commit(); string tryname=rs.getstring("name"); string strsql1 = "insert postjob1(applicants) values(?) id=?"; try { ps=con.preparestatement(strsql1); ps.setstring(1, tryname); ps.setstring(2,value); rs=ps.executequery(); if(rs.next()) { con.commit(); response.sendredirect("confirm.jsp"); } else{ response.sendredirect("oops.jsp");} } catch(sqlexception se) { system.out.println(se); } } else{ response.sendredirect("oops1.jsp");} } catch(sqlexception se) { system.out.println(se); } %> %> </div> </body> </html>
insert statement creates new record in table, , doesn't have clause. so, have syntax error in sql.
Comments
Post a Comment