Kalde en Stored Procedure med Param
Nogen der kan hjælpe? Mit problem er, at det der står i while løkken ikke bliver skrevet ud....// Stored procedure der skal kaldes.
CallableStatement cs = cnx.prepareCall("{? = call GetACustomerInfo[?]}");
// registrere input parametere
cs.setString(1, "156000");
ResultSet rs = cs.executeQuery();
if (rs.wasNull() == true)
{
System.out.println("ResultSet indeholdet ingen rækker!");
}
while(rs.next())
{
String lastName = rs.getString("lastName");
System.out.println("Efternavn: "+lastName+"\n");
}
-------
Her er min Stored Procedure:
CREATE PROCEDURE GetACustomerInfo (@custId VarChar(10) ) AS
-- SQL Statementet
SELECT dbo.Customer.firstName, dbo.Customer.lastName, dbo.Customer.address, dbo.Customer.zipcode, dbo.Zipcode.city, dbo.Customer.phone,
dbo.Customer.email, dbo.Account.ballance, dbo.Customer.accountNo, dbo.Employee.title, dbo.Employee.firstName AS Expr1,
dbo.Employee.lastName AS Expr2, dbo.Employee.phone AS Expr3, dbo.Employee.email AS Expr4, dbo.Employee.dptNo,
dbo.Department.dptName
FROM dbo.Account INNER JOIN
dbo.Customer ON dbo.Account.accountNo = dbo.Customer.accountNo INNER JOIN
dbo.Employee ON dbo.Customer.employeeNo = dbo.Employee.employeeNo INNER JOIN
dbo.Department ON dbo.Employee.dptNo = dbo.Department.dptNo INNER JOIN
dbo.Zipcode ON dbo.Customer.zipcode = dbo.Zipcode.zipcode
WHERE dbo.Customer.customerNo = @custId
GO
