有关JDBC的使用一些编程实例,有关与数据库连接的代码

				DROP TABLE food
				GO
				
				CREATE TABLE food
				    (product CHAR(25),
				     price   MONEY)
				GO
				INSERT INTO food
				    VALUES("Carrot",        $35.00)
				INSERT INTO food
				    VALUES("Cheeseburger",  $50.00)
				INSERT INTO food
				    VALUES("Hamburger",     $75.00)
				INSERT INTO food
				    VALUES("Pork Chop",     $175.00)
				INSERT INTO food
				    VALUES("String Beans",  $7.50)
				INSERT INTO food
				    VALUES("Summer Squash", $11.50)
				INSERT INTO food
				    VALUES("Sweet Potato",  $13.50)
				GO
				
				DROP PROCEDURE max_price
				GO
				
				CREATE PROCEDURE max_price
				  @pattern VARCHAR(50),
				  @retval  VARCHAR(10) OUTPUT
				AS
				BEGIN
				
				  DECLARE @max_price money 
				
				  DECLARE @like_pattern VARCHAR(51)
				  SELECT @like_pattern = RTRIM(@pattern) + '%'
				
				  SELECT @max_price=MAX(price)
				     FROM food
				     WHERE product LIKE @like_pattern
				
				  SELECT @retval = CONVERT(VARCHAR(10), @max_price)
				
				END
				GO