error in my jsp code
<%@ page language ="java"import ="java.sql.*" %>
<%@ pageimport ="java.sql.*" %>
<%@ pageimport ="java.text.*" %>
<%
//String stin,btin,pname,pcount,tax;
String stin=request.getParameter("sellertin");
session.setAttribute("sellertin",stin);
String btin=request.getParameter("buyertin");
session.setAttribute("buyertin",btin);
String pname=request.getParameter("prodname");
session.setAttribute("prodname",pname);
String pcount=request.getParameter("prodcount");
session.setAttribute("prodcount",pcount);
String tax=request.getParameter("vat");
session.setAttribute("vat",tax);
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String st ="jdbc:odbc:loginval";
Connection cn = DriverManager.getConnection(st," "," ");
Statement stmt = cn.createStatement();
stin=stin+"prod";
String str ="select * from '"+stin+"' where proname='"+pname+"'" ;
ResultSet result1 = stmt.executeQuery(str);
String pron,prop,proc;
pron = result1.getString("proname");
prop = result1.getString("proprice");
proc = result1.getString("procount");
int rate,price,ntax,net,ncount;
price=Integer.parseInt(prop);
ntax=Integer.parseInt(tax);
rate=price+(price*(ntax/100));
ncount=Integer.parseInt(pcount);
net=rate*ncount;
%>
the tax is calculated as<%=net%>
in this code i am trying to dynamically select different tables based on the user input. nut the program does not execute properly.
i get an error as follows
syntax error in query:incomplete query clause.
some one plz find where i ve gone wrong.
thanks in advance
