|
| ||
| Please help with JSP mysql update query I keep getting an error where the symbol cannot be resolved and the arrow pointing to where i have written statement.ExcecuteUpdate Am not able to insert any data into my database, can anyone see where i may have gone wrong. thanx heres the code: <%@ page import="java.sql.*" %> <%@ page import="java.util.*" %> <% String connectionURL = "jdbc:mysql://localhost:3306/learningtest"; Connection connection = null; Statement statement = null; int UQ=0; %> <%@page contentType="text/html"%> <%@page pageEncoding="UTF-8"%> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>Submit Question</title> </head> <body> <h1>Submit Question</h1> <% String questionin = request.getParameter("questionin"); String answerin = request.getParameter("answerin"); String subjectin = request.getParameter("subjectin");%> <td align="right">Question:</td> <td><%=questionin %></td> <br> <td align="right">Answer:</td> <td><%=answerin %></td> <br> <td align="right">Subject:</td> <td><%=subjectin %></td> <% Class.forName("com.mysql.jdbc.Driver").newInstance(); connection = DriverManager.getConnection(connectionURL, "", ""); statement = connection.createStatement(); UQ=statement.executeUpdate("INSERT INTO questions" + "(qid, question, answer, subject)" + "VALUES (" ," + questionin + "," + answerin + "," + subjectin)" ); out.println("Question Added Success"); statement.close(); %> </body> </html> p.s. the excecutequery works fine i can read from the database so there isnt anyprobs with the connection string |
| ||
| Re: Please help with JSP mysql update query this is the error message : method executeUpdate(java.lang.String, java.lang.String) not found in interface java.sql.Statement it seems there is a declaration problem. I am using the com.mysql, and the function seems to be present |
| ||
| Re: Please help with JSP mysql update query sorry this is the correct code: <%@ page import="java.sql.*" %> <%@ page import="java.util.*" %> <% String connectionURL = "jdbc:mysql://localhost:3306/learningtest"; Connection connection = null; Statement statement = null; %> <%@page contentType="text/html"%> <%@page pageEncoding="UTF-8"%> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>Submit Question</title> </head> <body> <h1>Submit Question</h1> <% String questionin = request.getParameter("questionin"); String answerin = request.getParameter("answerin"); String subjectin = request.getParameter("subjectin");%> <td align="right">Question:</td> <td><%=questionin %></td> <br> <td align="right">Answer:</td> <td><%=answerin %></td> <br> <td align="right">Subject:</td> <td><%=subjectin %></td> <% Class.forName("com.mysql.jdbc.Driver").newInstance(); connection = DriverManager.getConnection(connectionURL, "", ""); statement = connection.createStatement(); int UQ=statement.executeUpdate("insert into questions (qid, question, answer, subject) values ('," + questionin + "," + answerin + "," + subjectin + ")"); if (UQ==1) { out.println("Question Added Success"); } else { out.println("Addition failed"); } statement.close(); %> </body> </html> it runs except i get an sql error where the syntax is incorrect at the values being inserted...pls help |
| ||
| Re: Please help with JSP mysql update query the error message: java.sql.SQLException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '',ooo,ppp,Chemistry)' at line 1 |
| ||
| Re: Please help with JSP mysql update query Quote:
|
| ||
| Re: Please help with JSP mysql update query Hi, I think your Html missing some part. Could you please clarify that what is your form doing? Get the question + answer + subject from user... then update to database? kind regards, yup |
| ||
| Re: Please help with JSP mysql update query In the following examples, please substitute your information where the following data is referenced: <server>: enter the MySQL server that you are assigned to, for example, mysql4.safesecureweb.com <username>: enter the username provided for your database <password>: enter the password provided for your database <database>: enter the database name provided for your database <DSN>: enter the DSN name (ColdFusion only) PHP <?php $link = mysql_connect('<server>', '<username>', '<password>'); if (!$link) { die('Could not connect: ' . mysql_error()); } echo 'Connected successfully'; mysql_select_db(<database>); ?> ColdFusion <CFQUERY Name="test" DATASOURCE="<DSN>" USERNAME="<username>" PASSWORD="<password>"> </CFQUERY> Perl #!/usr/bin/perl use DBI; $db = DBI->connect("dbi:mysql:<database>","<username>","<password>") or die("Couldn't connect"); $db->disconnect; JSP <%@ page import="java.sql.*" %> <%@ page import="com.mysql.jdbc.Driver" %> <%! Class.forName("com.mysql.jdbc.Driver").newInstance(); java.sql.Connection conn; conn = DriverManager.getConnection( "jdbc:mysql://<server>/<database>?user=<username>&password=<password>"); %> |
| ||
| Re: Please help with JSP mysql update query Kid, check the dates on threads you're replying to. This one was resolved well over 2 years ago. But do tell, is it a new sport somewhere to create forum accounts just to post nonsense to age old threads? I've been seeing it a lot lately. |
| ||
| Re: Please help with JSP mysql update query Javascript is amazing, I didn't think you could touch mysql with it! Everyone kept telling me to use php with my js to get into sql. HAHA I feel like a million bucks! |
| ||
| Re: Please help with JSP mysql update query Quote:
|
| All times are GMT -4. The time now is 8:05 am. |
Forum system based on vBulletin Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
©2003 - 2009 DaniWeb® LLC