hi
i am trying to insert in database in this way using jsp but it is not working can any one help me where i have make an mistake....
<%@page import="com.dryclean.web.controller.DBUtil"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.Connection"%>
<%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%>
<%
Connection con =null;
Statement stmt = null;
int updateQuery=0;
String query="INSERT INTO customers (customer_id, first_name,last_name,contact,address) VALUES('null','"+request.getParameter("add_customer_fname")+"','"+request.getParameter("add_customer_lname")+"','"+request.getParameter("add_customer_cellnumber")+"','"+request.getParameter("add_customer_address")+"')";
try{
con = DBUtil.getConnection("jdbc:mysql://localhost:3306/","dry_cleaner","com.mysql.jdbc.Driver","root","");
System.out.println("connection success fully");
}catch(Exception ex){
System.out.println("Connection error");
}
try{
updateQuery=stmt.executeUpdate(query);
if (updateQuery != 0) {
System.out.println("table is created successfully and " + updateQuery + " row is inserted.");
}
}catch(Exception ex){
System.out.println("Query :"+query);
}
response.sendRedirect("user_page.jsp");
%>