jeudi 4 décembre 2014

How to solve the error


In my project i am having the files updateaction.jsp and updateprocess.jsp after executing updateprocess.jsp i am getting the Following Error. "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'add = 'on' edit= null delete=null WHERE userid = 'k61'' at line 1"


How can i solve the error. This is my code:



enter code here


updateprocess.jsp <%@ page contentType="text/html; charset=utf-8" language="java" import="java.sql.*" errorPage="" %> x Untitled Document


<% String userid1=(String)session.getAttribute("ccode"); String add1=request.getParameter("add"); String edit1=request.getParameter("edit"); String delete1=request.getParameter("delete"); Connection con=null; PreparedStatement ps=null; try { Class.forName("com.mysql.jdbc.Driver"); con=DriverManager.getConnection("jdbc:mysql://localhost:3306/masteradmin","root",""); String query="UPDATE privelage SET add = ? edit= ? delete=? WHERE userid = ?"; ps = con.prepareStatement (query); ps.setString(1,add1); ps.setString(2,edit1); ps.setString(3,delete1); ps.setString(4,userid1); ps.executeUpdate(); } catch(Exception e) { out.println(e.getMessage()); } %>


updateaction.jsp


<%@ page contentType="text/html; charset=utf-8" language="java" import="java.sql.*" errorPage="" %> Untitled Document


CollegeName: ' disabled="disabled" /> Userid:' disabled="disabled" /> Privelages: adddeleteedit




Aucun commentaire:

Enregistrer un commentaire