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.
