hi im getting Error..java.sql.SQLException: General error
when i try to run this code...
here im inserting a row into a access database.
please help me... with this..
<%@ page import="java.sql.*" %>
<%@ page language="java" %>
<%@ page import="javax.servlet.*" %>
<%@ page import="javax.servlet.http.*" %>
<%@ page import="java.util.*" %>
<%
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
String queryText = null;
%>
<%
queryText = "insert into projectquin values(\"" + request.getParameter("empnum") + "\",\"" +
request.getParameter("empname") + "\",\"" + request.getParameter("prjcode") + "\",\"" +
request.getParameter("coming")+ "\",\"" + request.getParameter("vegnonveg")+ "\",\"" +
request.getParameter("transport")+ "\",\"" + request.getParameter("readytopool")+ "\",\"" +
request.getParameter("residing")+ "\",\"" + request.getParameter("dropat")+ "\",\"" +
request.getParameter("noofrelatives")+ "\",\"" + request.getParameter("comments")+ "\");";
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String db = "jdbc:odbc:projectquin";
conn = DriverManager.getConnection(db);
stmt = conn.createStatement();
rs = stmt.executeQuery(queryText);
}
catch(Exception e) {
out.println("Error.."+e);
}
%>