syntax error in SQL Insert Statement

Home Answers Viewqa Java-Beginners syntax error in SQL Insert Statement

sushant

syntax error in SQL Insert Statement
1 Answer(s) 3 years and a month ago
Posted in : Java Beginners

private class ButtonListener implements ActionListener{
public void actionPerformed(ActionEvent ae){
//tab1
if(ae.getSource()==bt1ok){
// String date=tf1dob.getText();
// if(isValidDate(date))
// {

int prnnumber=Integer.parseInt(tf1id.getText());
String dateadmi=tf1date.getText();
String lastname=tf1ln.getText();
String firstname=tf1fn.getText();
String midname=tf1mn.getText();
String dateofbirth=tf1dob.getText();
String addressvalue=tf1address.getText();
String cityvalue=tf1city.getText();
String eduvalue=tf1edu.getText();
String percentage=tf1per.getText();
String genderdetail=text.getText();
String contactnum=tf1cont.getText();
int entmarks=Integer.parseInt(tf1ent.getText());
String coursename= jccourse.getSelectedItem().toString();
int coursefees=Integer.parseInt(tf1cfees.getText());
String coursetype=tf1ctype.getText();
//String academicyear= jcayear.getSelectedItem().toString();
// int academicyear=jcayear.getSelectedIndex()+1;
// int coursename = jccourse.getSelectedIndex()+1;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con1 =DriverManager.getConnection("jdbc:odbc:mydsn","","");
Statement stmt=con1.createStatement();
int i=stmt.executeUpdate("insert into newfresher(prn,date,lname,mname,dob,address,city,edu,per, gender,contact,ent,cname,cfees,ctype) values(" + prnnumber + ",'"+dateadmi+"', '"+lastname + "', '" +firstname + "','"+midname+"','"+dateofbirth+"','"+addressvalue+"','"+cityvalue+"','"+eduvalue +"','"+percentage+"','"+genderdetail+"','"+contactnum+"','"+entmarks+"','"+coursename+"',"+coursefees+",'"+coursetype+"')");//,'"+academicyear+"'
/*PreparedStatement stm=con1.prepareStatement("Insert into newfresher(prn,date,lname,fname,mname,dob,address,city,edu,per, gender,contact,ent,cname,cfees,ctype,ayear) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");//'" +dateadmi+ "',
stm.setInt(1, prnnumber);
stm.setString(2,dateadmi);
stm.setString(3,lastname);
stm.setString(4,firstname);
stm.setString(5,midname);
stm.setString(6,dateofbirth);
stm.setString(7,addressvalue);
stm.setString(8,cityvalue);
stm.setString(9,eduvalue);
stm.setString(10,percentage);
stm.setString(11, genderdetail);
stm.setString(12,contactnum);
stm.setInt(13,entmarks);

stm.setString(14, coursename);
stm.setInt(15,coursefees);
stm.setString(16,coursetype);
stm.setString(17, academicyear);
// stm.setInt(16, academicyear);

stm.executeUpdate();*/
JOptionPane.showMessageDialog(null,"Data is successfully inserted into database.");
con1.close();
}//end try
catch(Exception e){
System.out.println(e);
}//end catch*/
//JOptionPane.showMessageDialog(null,"Valid Date","STUDENT INFORMATION SYSTEM",JOptionPane.INFORMATION_MESSAGE);
//}//end if
// else
// {
// JOptionPane.showMessageDialog(null,"Invalid Date.","STUDENT INFORMATION SYSTEM",JOptionPane.INFORMATION_MESSAGE);
// }

}//end source if
}//end action performed
}//end listeners

View Answers

April 10, 2010 at 2:43 PM

Hi Friend,

Your field name 'date' in the database table 'newfresher' contradicts. Therefore change your field name 'date' to 'day' and run the following query:

int i=stmt.executeUpdate("insert into newfresher(prn,day,lname,fname,mname,dob,address,city,edu,per, gender,contact,ent,cname,cfees,ctype) values("+prnnumber+",'"+dateadmi+"','"+lastname+"', '"+firstname + "','"+midname+"','"+dateofbirth+"','"+addressvalue+"','"+cityvalue+"','"+eduvalue +"','"+percentage+"','"+genderdetail+"','"+contactnum+"','"+entmarks+"','"+coursename+"',"+coursefees+",'"+coursetype+"')");//,'"+academicyear+"'

Thanks

syntax error in SQL Insert Statement - Java Beginners
syntax error in SQL Insert Statement Dear Sir ,I have write following code to save data into access databse, but code gives following error code... Access Driver] Syntax error in INSERT INTO statement. plz Help Me Hi

syntax error in SQL Insert Statement - Java Beginners
syntax error in SQL Insert Statement private class ButtonListener...","",""); Statement stmt=con1.createStatement(); int i=stmt.executeUpdate("insert into newfresher(prn,date,lname,mname,dob,address,city

sql syntax error help
sql syntax error help this query show syntax error .. i am unable to figure it out insert into order (orderdate, dpname, paymethod, tamount...') where is the error ? Please send the error details and the datatype

The INSERT INTO Statement, SQL Tutorial
The INSERT INTO Statement The INSERT INTO statement is used to insert or add a record... values then we should use the following SQL statement

error : not an sql expression statement
error : not an sql expression statement hii I am gettin followin error in connecting to database SQLserver 2005 in Jdeveloper,i m usin struts... { Connection conn = DatabaseManager.getConnection(); Statement stmt

SQL And Statement
SQL AND Statement ... with Example The Tutorial illustrates an example from SQL AND Statement... AND Operator Syntax The SQL AND Operator Syntax return you a filter

PHP SQL Insert Statement
PHP SQL Insert Statement PHP SQL Insert Statement show you the message when the records... The Tutorial illustrate an example from 'PHP SQL Insert Statement'. To understand

The INSERT INTO Statement
The INSERT INTO Statement The INSERT INTO statement is used to insert or add a record... statement: INSERT INTO employee (emp_name

java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement. String sql = "UPDATE emp_details SET empEname... = ?"; PreparedStatement pst = connection.prepareStatement(sql); pst.setString

The INSERT INTO Statements in SQL?
The INSERT INTO Statements in SQL? The INSERT INTO Statements in SQL? Hi, The INSERT INTO statement is used to insert a new row or multiple rows into a table. SQL INSERT INTO Syntax INSERT INTO table_name VALUES

Syntax error in my UPDATE..please advise
Syntax error in my UPDATE..please advise Hi experts, I tested my... in your SQL syntax; check the manual that corresponds to your MySQL server version...) And here's my UPDATE Statement: String sql = "UPDATE members SET strNRICNO

oracle insert statement error - JDBC
oracle insert statement error hi.. please help me to insert a image into oracle 11g database and please say me how can i insert image from directory like G:\imagefolder\ultrasoundimage\02us02.jpeg please help me

SET Syntax
; The general syntax of SET statement is : SET variable_assignment [, variable... INSERT or ALTER TABLE statement when inserting an AUTO_INCREMENT values. Example..._packet=2; ERROR 1382 (HY000): The 'SET ONE_SHOT' syntax is reserved for purposes

SQL SELECT DISTINCT Statement
or rows into table 'Stu_Table'. SQL statement to insert data into table... SQL SELECT DISTINCT Statement ... with the select statement. The SQL Distinct clause is used with the Select statement

to write an SQL query using insert statement
to write an SQL query using insert statement I need to write an sql query for the below using InSERT command.pls help. Insert 5-star ratings by James Cameron for all movies in the database. Leave the review date as NULL

SQL Avg Syntax
SQL Avg Syntax SQL Avg Syntax is used to compute the average of the records in a table. Understand with Example The Tutorial illustrate an example from 'SQL Average Syntax

SQL QUERY ERROR
SQL QUERY ERROR Im writing a query which shows error of INVALID CHARACTER The Query is Insert into PMST_EMP_MST(PMSNUM_EMP_ID,PMSSTR_EMP... IN THE DATABASE. PLEASE HELP ME. Syntax of insert query is: INSERT

JDBC Batch Example With SQL Insert Statement
JDBC Batch Example With SQL Insert Statement: In this tutorial, we are discuss about insert SQL statement with the jdbc batch. First of all, we... SQL insert statement for save data in the datasource and add

SQL AND Statement
SQL AND Statement ... with Example The Tutorial illustrates an example from SQL AND Statement... AND Operator Syntax The SQL AND Operator Syntax return you a filter

SQL SELECT DISTINCT Statement
'Stu_Table'. SQL statement to insert data into table... SQL SELECT DISTINCT Statement ... with the select statement. The SQL Distinct clause is used with the Select statement

JDBC Prepared Statement Insert
JDBC Prepared Statement Insert ... Statement Insert. In this Tutorial the code describe the include a class... the given below code, we declare String variable sql,that is used to hold the insert

Jdbc Insert Statement
JDBC Insert Statement Add a row to a existing table using insert statement in JDBC. The tutorial illustrates an example from JDBC Insert Statement. In this program

Select Statement in SQL, SQL Tutorial
The SELECT statement for SQL SELECT key word is used to select data from a table. Syntax: SELECT column_name(s

What is the syntax for a CREATE TABLE statement?
What is the syntax for a CREATE TABLE statement? What is the syntax for a CREATE TABLE statement

SQL Backup query with where statement
SQL Backup query with where statement SQL Backup query with where statement ...()); Insert Data Into Stu_Table Insert into statement add the records

My Sql Error - Development process
My Sql Error Hello Sir ,I have Created Table with following Query... =DriverManager.getConnection("jdbc:odbc:access","",""); Statement st=con.createStatement(); int i=st.executeUpdate("insert into timetable(busno

The UPDATE Statement, SQL Tutorial
a specified criteria. In the given syntax of update statement the keyword SET... statement : Syntax: UPDATE 'table_name' SET 'field_name... The UPDATE Statement

Php Sql Query Insert
Php Sql Query Insert This example illustrates how to execute insert... for insert statement with separate values in the database table. The table before...; die('Could not connect: ' . mysql_error());

insertion in SQL - SQL
. it is showing error. invalid syntax near.. i know that we are not supposed to place... on Insert Query visit to : http://www.roseindia.net/sql/insert.shtml Thanks...insertion in SQL Hi! Everybody... i have a problem with sql

The DELETE Statement, SQL Tutorial
The DELETE Statement The DELETE statement is used to delete rows from a table. database will update that is why deletion and insertion of data will be done. Syntax

SQL GROUP BY Example
SQL GROUP BY Example In this section we will discuss about the group by statement in SQL. In this tutorial we will use MySQL for using the SQL statements... either of the following syntax as per your requirements : SQL GROUP

help with JDateChooser to insert date into sql
?¦ Statement stmt=con.createStatement(); stmt.executeUpdate("insert into special...help with JDateChooser to insert date into sql TextField3 = new com.toedter.calendar.JDateChooser(); TextField3.setDateFormatString("MM-d-yâ

Difference between Normal Insert and BLOB insert
Difference between Normal Insert and BLOB insert I have sql database... = System.Drawing.Image.FromStream(returnValue);** // Error if id=1 used i.e normal insert bytearray... insert than it gives error that invalid Parmeter but if i use id 2 it runs properly

insert and retrive data and time - SQL
insert and retrive data and time hello everybody . Is there any method in java so that we can insert current system time and then it can... default NULL, PRIMARY KEY (`id`) ) To insert current date and time

Create After Insert Trigger in SQL
Create After Insert Trigger in SQL ... from 'Create After Insert Trigger in SQL'. In this Example, we create... inside the begin-end statement. The insert into add the records or rows value

PHP SQL Injection Attack
;]; $sql="insert into stu(name,class) values('".$name."'... Error".mysql_error()); mysql_close($connection); } $sql="Select...;Sql Error".mysql_error()); $sql_num=mysql_num_rows($sql_result); echo "

PHP Code Syntax
PHP Code Syntax PHP syntax is the set of rules which need to be followed to to write properly structured PHP code. Given below Some rules of PHP syntax... use html, text, SQL queries with in a PHP file. You can place PHP script

prepared statement in for loop - JDBC
prepared statement in for loop Hi all, I am reding data from a jsp page and inserting into a table. For this i am using prepared statement... into the table. While updating second row, it is throwing an SQL Exception as follows

Use HANDLER Statement in Cursors
open the cur1 which built a result set. The repeat statement in SQL include... Use HANDLER Statement in Cursors Use HANDLER Statement in Cursor is used to define

insert into statement in sql using servlets
insert into statement in sql using servlets ... insert a value from a html form in the table stored in the database. ... we are going to insert the values. Now make one jsp page or html page

PHP SQL Insert
PHP SQL Insert PHP SQL Insert is used to insert the record from HTML page to Mysql ... an example from PHP SQL Insert . To understand the example, firstly we need

correct the sql error
correct the sql error i am getting a SQL Error while retriving data...(null,"Please enter the Student ID to Search","Error",0); } else { try...:odbc:college"); Statement st=con.createStatement

JSP SQL Error
JSP SQL Error Hi While trying to execute the below code i'm getting the following error "java.sql.SQLException: Io exception: Got minus one from...:oracle:thin:@localhost:8084:dsn","system","tiger"); Statement st=null

SQL error - JSP-Servlet
SQL error Hello friends, Can we update a column...(url+dbname,userName,password); try{ Statement st...){ System.out.println("Error occured while updating!!!"); } con.close

SQL Create View
is created, The insert into statement of SQL is used to insert the records or rows... is defined as a virtual table outcome as a result of an SQL statement. A view... 6 Tanuj 10 SQL CREATE VIEW Syntax

SQL AND Operators
. In this Tutorial, Table Stu_Table is created using create table statement. The insert... AND Operator Syntax The SQL AND Operator Syntax return you the filter... SQL AND Operators

hibernate sql error - Hibernate
hibernate sql error Hibernate: insert into EMPLOYE1 (firstName, lastName, age, p-type, EMP_ID) values (?, ?, ?, 'e', ?) Exception in thread "main.../index.shtml http://www.roseindia.net/hibernate/insert-data-database.shtml Hope

SQL OR Operators
Komal 10 SQL OR Operator Syntax The SQL... is true or the second condition is true. The Syntax used for SQL OR Operator... SQL OR Operators

how to insert value in dynamic table
sql server showing a syntax error. my code is as follows:- PreparedStatement ps1... showing an error invalid syntax on year. please help me to solve...how to insert value in dynamic table i am creating a project

SQL _ Wildcards
statement. The insert into add records or rows into the table. When you want... SQL _ Wildcards SQL wildcards are used for searching one or more characters

Ask Questions?

If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.

Ask your questions, our development team will try to give answers to your questions.

Tutorial Topics