Use of Java Variables In A SQL Server Database. Help!!!

dmstn · #1 April 10th, 2007, 12:40 PM

My question is:
Is there a way to use the value of a java variable in a SQL query??
I mean. There is a java program. Can I retrieve the value of that variable and use it in a SQL query? Your help will be so much appreciated.

Thanks in advance. ;)

dmstn · #2 April 10th, 2007, 04:51 PM

Come on. Just tell me if this can be done and if yes, how it can be done. I need help.

Banfa · #3 April 10th, 2007, 09:54 PM

Quote:

Originally Posted by dmstn

Come on. Just tell me if this can be done and if yes, how it can be done. I need help.

Please do not be impatient, it is rude. Please do remember that the people answering you are not necessarily in the same timezone as you are.

dmstn · #4 April 11th, 2007, 10:28 AM

I didn't mean to be rude. It's just that I need help as soon as possible.

JosAH · #5 April 11th, 2007, 11:46 AM

Have a look at the java.sql.PreparedStatement interface.

kind regards,

Jos

dmstn · #6 April 12th, 2007, 10:26 AM

Thanks for the heads up.
I'm having a look at that at the moment. I think that the getParameterMetaData() function could help me retrieve the value of that variable and use it in the SQL query. I tried to use it but I can't find a solution. Okay I'll post my code:

This java program connects to a SQL Server Database. It wants us to insert a Customer Code and then delete that customer. That's what I've done so far:

Expand|Select|Wrap|Line Numbers

 import java.sql.*;

import java.util.Scanner;
 
class Sample {
 
    public static void main (String[] args) {
 
        /* variables declaration */

        Connection con = null ;

        Statement stmt = null;

        ResultSet rs = null;

        String url = "jdbc:odbc:mydata";

        DatabaseMetaData meta = null;
 
        try {

        // Step 1: Load the ODBC driver.

            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

                System.out.println("Driver Loaded successfully!");

        } catch(Exception e1) {

                System.out.println("An error occur while loading the Driver : "+e1.getMessage());

        System.out.println("Check ODBC");

        }
 
        try {

        // Step 2: Establish the connection to the database.

        con = DriverManager.getConnection(url,"","");

                System.out.println("Connection Established!");
 
        } catch(Exception e2) {

        System.out.println("Could not establish the Connection : "+e2.getMessage());

                System.out.println("Check username or password");

    }
 
    try {

        // Step 3: Get the Customer Code and Delete that customer from the database

        Scanner x = new Scanner(System.in);

        stmt = con.createStatement();

        rs = stmt.executeQuery("Select * from Pelates ");

        System.out.print("Please enter Client Number:");

        int number = x.nextInt();

        int code = 0;
 
        while (rs.next()) {

        code = rs.getInt("Code_Pel");
 
        }
 
        if(code == number) {

            PreparedStatement pstmt = con.prepareStatement("Delete From Pelates Where Code_Pel = ? ");

               pstmt.setInt(1, number);
 
            System.out.println("Client Deleted");

        }
 
        rs.close();
 
        stmt.close();

        con.close();

        } catch(Exception e3) {

        System.out.println("Could not get data : "+e3.getMessage());

    }

    }

}

Step 3 is important.

Use of Java Variables In A SQL Server Database. Help!!!

re: Use of Java Variables In A SQL Server Database. Help!!!

re: Use of Java Variables In A SQL Server Database. Help!!!

re: Use of Java Variables In A SQL Server Database. Help!!!

re: Use of Java Variables In A SQL Server Database. Help!!!

re: Use of Java Variables In A SQL Server Database. Help!!!

/bytes/development

/bytes/it

/bytes/about