Use of Java Variables In A SQL Server Database. Help!!!
Question posted by: dmstn
(Newbie)
on
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. ;)
5
Answers Posted
Come on. Just tell me if this can be done and if yes, how it can be done. I need 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.
I didn't mean to be rude. It's just that I need help as soon as possible.
Have a look at the java.sql.PreparedStatement interface.
kind regards,
Jos
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.
 |
|
|
|
What is Bytes?
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 196,952 network members.
|
