All about rakhi sinha

prepared statement is not working according to if condition

Martin Vajsar wrote:Rakhi, there is no way an if condition would "not be working". If the i1 is not null, the body of the if statement is executed, if it is null, it isn't executed. There is no third possibility out there.

I'd strongly suggest to activate logging in your application (if you do not know why, try to search out or maybe ask in some relevant forum here) and print all the variables in your code to a log to see what you're getting in. Another option would be to debug your application using a debugger, if that is feasible for your architecture. You need to learn at least one of these two approaches, if you want to be able to do a career in programming.

i dont understand why my code is not running ......how to activate logging in my application.

10 years ago

JDBC and Relational Databases

prepared statement is not working according to if condition

This is servlet by which i am inserting values in the database but if i dont enter any value of i2,q2,c2,i3,q3 and c3 then according to my servlet it should not insert any values to database but it is not doing so..if condition is not working......

String a = req.getParameter("ccno");//ccno
String k=req.getParameter("radiobutton1");//item type
String i1 = req.getParameter("i1");//description of item1
String q1 = req.getParameter("q1");//quantity1
String c1 = req.getParameter("c1"); //price1
String i2 = req.getParameter("i2");//description of item2
String q2 = req.getParameter("q2");//quantity2
String c2 = req.getParameter("c2"); //price2
String i3 = req.getParameter("i3");//description of item3
String q3 = req.getParameter("q3");//quantity3
String c3 = req.getParameter("c3"); //price3
PreparedStatement pst = con.prepareStatement("INSERT into p VALUES(?,?,?,?,?)");
if(i1!=null)
{
pst.setString(1,k);
pst.setString(2,i1);
pst.setString(3,q1);
pst.setString(4,c1);
pst.setString(5,a);
pst.executeUpdate();
}
pst3.close();
if(i2!=null)
{
pst.setString(1,k);
pst.setString(2,i2);
pst.setString(3,q2);
pst.setString(4,c2);
pst.setString(5,a);
pst.executeUpdate();
}
if(i3!=null)
{
pst.setString(1,k);
pst.setString(2,i3);
pst.setString(3,q3);
pst.setString(4,c3);
pst.setString(5,a);
pst.executeUpdate();
}
pst.close();

this is second servlet

out.println("<tr>"+
"<td>1.</td>"+
"<td>"+"<input type=\"text\" name=\"i1\" /></td>"+
"<td>" +"<input type=\"text\" name=\"q1\" /></td>"+
"<td> "+"<select name=\"select8\">"+"<option>1</option><option>2</option><option>3</option></select></td>"+
"<td>"+"<input type=\"text\" name=\"c1\" /></td>"+"</tr>");
out.println("<tr>"+
"<td>2.</td>"+
"<td>"+"<input type=\"text\" name=\"i2\" /></td>"+
"<td>"+"<input type=\"text\" name=\"q2\" /></td>"+"<td>"+"<select name=\"select10\">"+
"<option>1</option><option>2</option><option>3</option></select></td>"+"<td>"+
"<input type=\"text\" name=\"c2\" /></td>"+"</tr>");
out.println("<tr>"+"<td>3.</td>"+"<td>"+"<input type=\"text\" name=\"i3\" /></td>"+
"<td>"+"<input type=\"text\" name=\"q3\" /></td>"+"<td>"+"<select name=\"select11\">"+
"<option>1</option><option>2</option><option>3</option></select></td>"+"<td>"+
"<input type=\"text\" name=\"c3\" /></td>"+"</tr>"+"</table></td>");
out.println(" </tr> </table>");
out.println("</b> <input type=\"submit\" name=\"Submit\" value=\"Submit\" ><br></centre>

10 years ago

JDBC and Relational Databases

values are not getting transferred from one servlet to another servlet

my first servlet is this.....

My second servlet is this

but the value getting printed by underlined line is null...textbox value is not going from first servlet to second servlet

10 years ago

Servlets

want to insert user-defined pass-phrase

I am using following code to digitally sign the pdfs it is working well,but if i write phrase in place of "abcdef" password it does not work... (because i want to enter passwords of individual persons )

HttpSession session = request.getSession();
String no = (String)session.getAttribute("no");
HttpSession session1=request.getSession();
String phrase=(String)session1.getAttribute("[u]phrase[/u]");
HttpSession session2=request.getSession();
String path=(String)session2.getAttribute("path");
try {
KeyStore ks = KeyStore.getInstance("pkcs12");
ks.load(new FileInputStream(getServletContext().getRealPath("resources/"+path)),"abcdef".toCharArray());
String alias = (String)ks.aliases().nextElement();
PrivateKey key = (PrivateKey)ks.getKey(alias, "abcdef".toCharArray());
Certificate[] chain = ks.getCertificateChain(alias);
PdfReader reader = new PdfReader(getServletContext().getRealPath("/resources/a"+ no +".pdf"));
FileOutputStream os = new FileOutputStream(getServletContext().getRealPath("/resources/signed"+no+".pdf"));
PdfStamper stamper = null;
stamper = PdfStamper.createSignature(reader, os, '\0');
PdfSignatureAppearance appearance = stamper.getSignatureAppearance();
appearance.setCrypto(key, chain, null,PdfSignatureAppearance.WINCER_SIGNED);
appearance.setReason("It's personal.");
appearance.setLocation("foobar");
appearance.setVisibleSignature(new Rectangle(200, 500, 290, 450), 1,"first");
stamper.close();

10 years ago

Other Open Source Projects

Import .cer(public key) into .pfx

Yaron Naveh wrote:See here how to do the conversion in one shot:

http://travisspencer.com/blog/2009/10/exporting-keys-from-a-jks-and.html

I have also created .keystore using java keytool now i want to convert it into .pfx format....what should i do for this?

10 years ago

Web Services

rakhi sinha

Recent posts by rakhi sinha