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
Related Tutorials/Questions & Answers:
Java to SQL Server ConnectivityJava 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 connectivityjsp
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 sql connectivity error - JSP-ServletJava servlet
sql connectivity error Hi,
I have been trying to connect to
sql database via the servlet program in java.I have not been successful so far. However when i try to connect to
sql through a normal
java program
Connectivity with sql in detail - JDBCConnectivity with
sql in detail Sir/Madam,
I am unable to connect the
sql with
Java. Please tell me in detail that how to connect.
Thankyou. Hi Friend,
Put mysql-connector
JDBC, Java Database Connectivity
have in our site roseindia.net. Our website is very famous for JDBC and
Java
tutorials.
Java Database
Connectivity or JDBC for short is
Java bases API...
Connectivity or JDBC for short is a standard API in
Java
for accessing
SQL ServerSQL Server Hii,
What is
SQL Server ?
hello,ADS_TO_REPLACE_1
SQL Server is a DBMS system provided by Microsoft
sql server - SQLsql server How many no of tables can be joined in same
sql server jsp page connectivity with oracle - SQLjsp page
connectivity with oracle I am unable to database
connectivity jsp with oracle.
Please send the code for solving problem.
thanks Hi Friend,
1)Import the packages:
2)Load the oracle driver
java connectivityjava 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
Sql Server - SQLsql server trigger example Can any one tell me the live example of triggers in
SQL Server? if u click pistal trigger ,it auotmatically shoot bullet it's like newtons 3rd law (every action s having an equal reaction
Java servlet with jsp on sql serverJava 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 and sql server NOT Mysql - JSP-Servletjava and
sql server NOT Mysql Hi guys.
Thank you all for the various helps you render to everyone. Please the question I asked the last time... image from MS
SQL server NOT MySQL. Or is it not possible to do it in MS
SQL server java connectivityjava 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
Error while SQL Server connection to JavaError 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 JavaError 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
date problem in sql server - SQLdate problem in
sql server select count(*) from xxxx_tbl where emplid="+emplid+" and work_dt=#"+work_date+"#"; work_date is in string ,Backend is
sql server 2000.i am getting the date problem when using in jsp page.
XML in SQL ServerXML in
SQL Server Hi.....
please anyone tell me about
What is the purpose of FOR XML in
SQL Server?ADS_TO_REPLACE_1
Thanks
jdbc odbc sql server exceptionjdbc 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 accessjava 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 2008SQL 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
database connectivity in java - JDBCdatabase
connectivity in java import java.io.*;
import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
import java.sql.*;
class Project implements ActionListener
{
JFrame f;
JPanel p1,p2,p3;
JTabbedPane
Java database connectivityJava 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 textboxSql 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 2005Data 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 Java and SQL - SQLJava and SQL i have a problem with regard to connecting my
java code in getting a data to
SQL. my problem is on how to come up with a pop up alert message in the user interface where in the message will be coming from the
SQL database connectivitydatabase connectivity how to create database
connectivity between HTML and
sql server2005
create a xml from sql server 2005 - XMLcreate a xml from
sql server 2005 hello Dear,
i want to know how we create a xml file which retrieve data from
Sql server 2005 using
java.
i am briefing my problem as follows.
let i have a table in
sql server 2005