Java to SQL Server Connectivity

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
sql connectivity through java
sql connectivity through java  i want an example for java db through sql connection. Thanks in advance
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 connectivity with MySQL
Java connectivity with MySQL  Java connectivity with MySQL
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
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  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 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
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
Merge databases in SQL SErver 2005
Merge databases in SQL SErver 2005  Please help me to merge databases in SQL server 2005
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
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
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.
Maven dependency for com.themodernway - themodernway-server-sql version 1.2.10-RELEASE is released. Learn to use themodernway-server-sql version 1.2.10-RELEASE in Maven based Java projects
( com.themodernway - themodernway-server-sql version 1.2.10-RELEASE ) in their Java...; com.themodernway - themodernway-server-sql version 1.2.10-RELEASE in Java projects... - themodernway-server-sql version 1.2.10-RELEASE java library in your project. Now you
Maven dependency for com.themodernway - themodernway-server-sql version 1.2.25-RELEASE is released. Learn to use themodernway-server-sql version 1.2.25-RELEASE in Maven based Java projects
( com.themodernway - themodernway-server-sql version 1.2.25-RELEASE ) in their Java...; com.themodernway - themodernway-server-sql version 1.2.25-RELEASE in Java projects... - themodernway-server-sql version 1.2.25-RELEASE java library in your project. Now you
Maven dependency for com.themodernway - themodernway-server-sql version 2.1.6-RELEASE is released. Learn to use themodernway-server-sql version 2.1.6-RELEASE in Maven based Java projects
( com.themodernway - themodernway-server-sql version 2.1.6-RELEASE ) in their Java...; com.themodernway - themodernway-server-sql version 2.1.6-RELEASE in Java projects...-server-sql version 2.1.6-RELEASE java library in your project. Now you can save
Maven dependency for com.themodernway - themodernway-server-sql version 2.0.3-RELEASE is released. Learn to use themodernway-server-sql version 2.0.3-RELEASE in Maven based Java projects
( com.themodernway - themodernway-server-sql version 2.0.3-RELEASE ) in their Java...; com.themodernway - themodernway-server-sql version 2.0.3-RELEASE in Java projects...-server-sql version 2.0.3-RELEASE java library in your project. Now you can save
Maven dependency for com.themodernway - themodernway-server-sql version 1.2.27-RELEASE is released. Learn to use themodernway-server-sql version 1.2.27-RELEASE in Maven based Java projects
( com.themodernway - themodernway-server-sql version 1.2.27-RELEASE ) in their Java...; com.themodernway - themodernway-server-sql version 1.2.27-RELEASE in Java projects... - themodernway-server-sql version 1.2.27-RELEASE java library in your project. Now you
Maven dependency for com.themodernway - themodernway-server-sql version 1.0.3-RELEASE is released. Learn to use themodernway-server-sql version 1.0.3-RELEASE in Maven based Java projects
( com.themodernway - themodernway-server-sql version 1.0.3-RELEASE ) in their Java...; com.themodernway - themodernway-server-sql version 1.0.3-RELEASE in Java projects...-server-sql version 1.0.3-RELEASE java library in your project. Now you can save
connectivity
connectivity  how to connect java with database
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
connect sql server 2005 using php
connect sql server 2005 using php  how to connect sql server 2005 using php program. how mssql_connect will work
Version of com.themodernway>themodernway-server-sql dependency
List of Version of com.themodernway>themodernway-server-sql dependency
database connectivity
database connectivity  how to create database connectivity between HTML and sql server2005
ModuleNotFoundError: No module named 'django-sql-server-bcp'
ModuleNotFoundError: No module named 'django-sql-server-bcp'  Hi...: No module named 'django-sql-server-bcp' How to remove the ModuleNotFoundError: No module named 'django-sql-server-bcp' error? Thanks   Hi
how to connect SQL Server 2005 using php
how to connect SQL Server 2005 using php  i need to connect SQL Server 2005 using php. how can i connect . how to use mssql_connect function
Version of com.ahome-it>ahome-tooling-server-sql dependency
List of Version of com.ahome-it>ahome-tooling-server-sql dependency

Ads