Plz help for some reason this code is not compiling

[webslinger55]

I am trying to parse an Integer to put it into a NUMERIC value into a database form a webpage using a servlet in Netbeans. The problem is that when I am parsing it I keep getting the error cannot put a CHAR into a NUMERIC value can someone please tell me what I am doing wrong here is my code.
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response);
String ID = request.getParameter("ID");
int IDNum = Integer.parseInt(ID);
try
{
stmt = connection.createStatement();
int update_count = stmt.executeUpdate("INSERT INTO APP.CUSTOMERINFO (CUSTOMERID,CUSTOMERNAME,SHIPPINGADDRESS) " +" VALUES("+ IDNum + ", '" + Name + "', '" + Address + "')");
stmt.close();
}
catch (SQLException e)
{
e.printStackTrace();
}
}
and this is the error.
SEVERE: java.sql.SQLSyntaxErrorException: Columns of type 'NUMERIC' cannot hold values of type 'CHAR'.
Please this is driving me insane.

[DarrylBurke]

First off, your code is fragile and prone to SQL injection. Use PreparedStatement, not Statement.

That should solve the problem you're facing, too.

And as there's nothing NetBeans-specific about the question, I'm moving it to JDBC.

db