Java to SQL Server Connectivity
Hi, heres my code
private void bookedButton()
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager.getConnection("jdbc:odbc:BUS","","");
Statement stmt= conn.createStatement();
// stmt.execute("Set identity_insert customers on");
String current_status="BOOKED";
emp =conn.prepareStatement("INSERT INTO customers (cust_name,cust_nic,cust_contact,cust_address,seat_no,departure_date,amount,total_amount,advance,remaining_amount,booking_date,checkin_date,current_status) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,'"+ current_status+"')");
emp.setString(1, text1.getText());
emp.setString(2, text2.getText());
emp.setString(3, text4.getText());
emp.setString(4, text3.getText());
emp.setString(5, rtext2.getText());
emp.setString(6, ctext2.getText());
emp.setString(7, rtext3.getText());
emp.setString(8, rtext4.getText());
emp.setString(9, rtext5.getText());
emp.setString(10, rtext6.getText());
emp.setString(11, ctext1.getText());
emp.setString(12, ctext3.getText());
emp.executeUpdate();
// JOptionPane.showMessageDialog( this, "BOOKING SUCCESSFUL!","BOOKING RESULT", JOptionPane.PLAIN_MESSAGE );
// dispose();
}
catch(Exception e)
{
JOptionPane.showMessageDialog( this, "BOOKING UNSUCCESSFUL!\n\nAll Fields Mandatory\n\nCheck Either Seat is Available or Not","Error", JOptionPane.ERROR_MESSAGE );
System.out.println(e.getMessage());
}
}
Im making a ticket reservation system with sql server connectivity at the background to save the data.
Now, after entering the data in the fields, i get two "General Eroor". I don't know if i made the connectivity wrong.
Kindly help me resolve this issue ASAP.
Thank you.
View Answers
Ads
Related Tutorials/Questions & Answers:
Java to SQL Server Connectivity
Java to
SQL Server Connectivity Hi, heres my code
private void... with
sql server connectivity at the background to save the data.
Now, after... the
connectivity wrong.
Kindly help me resolve this issue ASAP.
Thank you
Advertisements
jsp sql server 2005 connectivity
jsp
sql server 2005 connectivity your jsp mysql tutorial is very help full.Please tell me how to connect jsp with
SQL server 2005
Java servlet with jsp on sql server
Java servlet with jsp on
sql server How to delete a user by an admin with check box in
Java Servlet with jsp on
Sql Server?
Here is a jsp example that can delete the multiple record from the database by selecting
java connectivity
java connectivity hi........
Can u help me to do
connectivity between
java and weka???????
weka is a data mining tool which allows to do prediction, classification etc....
i want to do
connectivity between weka and
java can u
Error while SQL Server connection to Java
Error while
SQL Server connection to Java import java.sql.*;
public...");
con=DriverManager.getConnection("jdbc:odbc:
SQL_
SERVER;user=DTHOTA;password...("password", " ");
con=DriverManager.getConnection("jdbc:odbc:
SQL_
SERVER", prop
Error while SQL Server connection to Java
Error while
SQL Server connection to Java import java.sql.*;
public...");
con=DriverManager.getConnection("jdbc:odbc:
SQL_
SERVER;user=DTHOTA;password...("password", " ");
con=DriverManager.getConnection("jdbc:odbc:
SQL_
SERVER", prop
java connectivity
java connectivity i am trying to add dyanamic rows in the jsp page, when i add the new row the dropdown control value is not coming from database..please help me to overcome this problem
jdbc odbc sql server exception
jdbc odbc
sql server exception Hi,
I am trying to use
sql server with
java jdbc odbc but I am getting this exception
java.sql.SQLException: [Microsoft][
SQL Server Native Client 10.0][
SQL Server]Incorrect syntax near '@P1
java servlet connectivity problem with access
java servlet
connectivity problem with access Import java.sql
javax.servlet
//all packages entered
try {
Class.forName... an
SQL query, get a ResultSet
ResultSet rs = st.executeQuery("SELECT NAME
SQL SERVER 2008
SQL SERVER 2008 when i am fill the all fields in the form.but when i am retrive from the database it shows only firstname,age,address.remaining fields was shows as null.and it shows the gender as the on.i can't understand what
Sql Server like with
Sql Server like with SELECT username FROM login WHERE CONTAINS(RelatedWords,'""Insurance"""');
How can we handle this ,throwing error like
Syntax error near 'Insurance' in the full-text search condition '""Insurance
Java database connectivity
Java database connectivity Hi sir
I need a code to create an application where user enter name in text box and that should be stored in database.
Plz help me out its very urgent.
import java.sql.*;
import java.awt.
Sql Server 2008 with textbox
Sql Server 2008 with textbox **Hi, I tried to insert into DB using textbox in a form using vb by visual studio 2010 but its always catch an error...
myconn = New SqlConnection("
server=localhost;" & "Initial Catalog=4
Data Conversion In Sql Server 2005
Data Conversion In
Sql Server 2005 Hi
I am working vb.net &
sql server 2005 database. I am storing date (MM/DD/YYYY) format. now I have problem in
sql date conversion (DD/MM/YYYY). Can you help how to convert date
How to read textfile and create SQL server table ?
How to read textfile and create
SQL server table ? hi sir, your site... trying to read textfile and create table in
sql server but it gives error.../questions/16415498/creating-a-table-in-
sql-database-by-reading-textfile-in-
java
sql,java
sql,java i am writing some code in java.that values are stored in database.plz send me one example for this for example taking the fields as s.no,category,name of the candidate,age,title of the project,video uploading,photo
java .sql
java .sql where are the interfaces of java.sql like STATEMENT,CONNECTION are defined
JAVA to SQL
JAVA to SQL package abhijeet;
import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStream;
import...;
}
}
plzzz help mw wid dis...
1: i hav read and Excel file in
java
SQL Server row comparison using two tables
SQL Server row comparison using two tables insertion process are completed in table1.string comparison using table2 to table1 if any changes in these tables and then upadated
Online exam using c# and SQL server
Online exam using c# and
SQL server hello, i'm making the (window based)online examination system using C#.net and
SQL SERVER. my database is stored on
server. my question is: if during the examination
server gets failed
JDBC Connectivity Code In Java
JDBC
Connectivity Code In
Java
In this Tutorial we want to describe you a code
that helps you in understanding JDBC
Connectivity Code in
Java. In this
program, the code