can nit find symbol

Joined
Mar 12, 2008
Messages
1
Reaction score
0
import java.io.*;
import java.util.Enumeration;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
import java.net.*;
public class AgencyServlet extends HttpServlet{
Connection conn;
private ServletConfig config;

public void init(ServletConfig config) throws ServletException{
this.config=config;
}

public void service (HttpServletRequest request,HttpServletResponse response) throws ServletException,IOException{


String url="jdbc:mysql://192.168.0.2/balaji";
conn=null;
ResultSet rs=null;
HttpSession session=request.getSession(true);
response.setContentTyper("text/html");
Printwriter out=response.getwriter();

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");


try{
Class.forName("org.gjt.mm.mysql.Driver");
conn=DriverManager.getConnecton(url,"root","admin");
String sql="insert into stock values(?,?,?,?,?,?)";
PreparedStatement pst=conn.prepareStatement(sql);///can not find symbol error
^
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);

int numRowsChanged=pst.executeUpdate();
pst.close();
if(numRowsChanged>=0)
request.getRequestDispatcher("/saverecord.jsp").forward(request,response);
else
request.getRequestDispatcher("savefailure.jsp").forward(request,response);
}
catch(SQLException e){
out.println("SQLException caught: " + e.getMessage());
}
catch (Exception e){
out.println(e);
}
finally{
try{
if(rs!=null){
rs.close();
rs=null;
}
if(pst!=null){
pst.close();
pst=null;
}
if(conn!=null){
conn.close();
conn=null;
}
}//try
catch(SqlException e)
{
}//catch
}//finally
}//method
}//class
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,769
Messages
2,569,580
Members
45,054
Latest member
TrimKetoBoost

Latest Threads

Top