[ravi503]

import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class agencyServlet extends HttpServlet{
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException{
response.setContentType("text/html");
PrintWriter pw = response.getWriter();
String connectionURL = "jdbc:mysql://192.168.0.2/balaji"?user=root&password=admin";
Connection connection;
try{
String ag_name = request.getParameter("Agency Name");
String ag_add1 = request.getParameter("Agency Address1");
String ag_add2 = request.getParameter("Agency Address2");
String ag_city = request.getParameter("Agency city");
String ag_tel = request.getParameter("telephone");
String regd_no = request.getParameter("regd.no");
pw.println(ag_name);
pw.println(ag_add1);
pw.println(ag_add2);
pw.println(ag_city);
pw.println(ag_tel);
pw.println(regd_no);
Class.forName("com.mysql.jdbc.Driver");
connection = DriverManager.getConnection(connectionURL, "root", "admin");
PreparedStatement pst = connection.prepareStatement("insert into agency values(?,?,?,?,?,?)");
pst.setString(1,ag_name);
pst.setString(2,ag_add1);
pst.setString(3,ag_add2);
pst.setString(4,ag_city);
pst.setString(5,ag_tel);
pst.setString(6,regd_no);

boolean updaterow=false;
String regd_no=agency.setstring(6);
string newvalue=request.getpatameter("regd.no");
}
if((newvalue!=null)&&(!newvalue equals("regd.no))
{
agency.updatestring(6,request.getparameter("regd.n o"));
update row=true;
}
int i = pst.executeUpdate();
if(i!=0){
pw.println("<br>Record has been inserted");
}
else{
pw.println("failed to insert the data");
}


catch (Exception e){
pw.println(e);
}
}
}
this is my code
i didnt recognize err
plz help me by solving this
and make a desc