Use of Java Variables In A SQL Server Database. Help!!! 
April 10th, 2007, 12:40 PM
| | Newbie | | Join Date: Feb 2007
Posts: 16
| | |
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. ;)
| 
April 10th, 2007, 04:51 PM
| | Newbie | | Join Date: Feb 2007
Posts: 16
| | | re: Use of Java Variables In A SQL Server Database. Help!!!
Come on. Just tell me if this can be done and if yes, how it can be done. I need help.
| 
April 10th, 2007, 09:54 PM
|  | AdministratorVoR | | Join Date: Feb 2006 Location: South West UK
Posts: 6,117
Provided Answers: 6 | | | re: Use of Java Variables In A SQL Server Database. Help!!! 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.
| 
April 11th, 2007, 10:28 AM
| | Newbie | | Join Date: Feb 2007
Posts: 16
| | | re: Use of Java Variables In A SQL Server Database. Help!!!
I didn't mean to be rude. It's just that I need help as soon as possible.
| 
April 11th, 2007, 11:46 AM
|  | Expert | | Join Date: Mar 2007
Posts: 10,634
Provided Answers: 2 | | | re: Use of Java Variables In A SQL Server Database. Help!!!
Have a look at the java.sql.PreparedStatement interface.
kind regards,
Jos
| 
April 12th, 2007, 10:26 AM
| | Newbie | | Join Date: Feb 2007
Posts: 16
| | | re: Use of Java Variables In A SQL Server Database. Help!!!
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: - 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.
|  | | | | /bytes/about
We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights.
Get the best answers to your questions from over 225,662 network members.
|