分类：
2007-05-21 21:50:17
<%@ page contentType="text/html;charset=gb2312"%><%@ page import="java.sql.*"%><html> <body> <% Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver") .newInstance(); String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs"; //pubs为你的数据库的 String user = "sa"; String password = ""; Connection conn = DriverManager.getConnection(url, user, password); //不带参数的存储过程，并且返回结果集 CallableStatement stmt = conn.prepareCall("{call ghy_proc}"); stmt.execute(); ResultSet rs = stmt.getResultSet();
while (rs.next()) 
{
out.println(rs.getString(1));
} out.println(" //带参数的存储过程，并且返回值 stmt = conn.prepareCall("{call ghy_proc_return(?,?)}"); stmt.registerOutParameter(1, Types.INTEGER); stmt.registerOutParameter(2, Types.INTEGER); stmt.setInt(1, 10); stmt.setInt(2, 10); stmt.execute(); out.println("加1的值是：" + stmt.getString(1) + " out.println("减1的值是：" + stmt.getString(2) + " //带参数的存储过程，并且返回结果集 stmt = conn.prepareCall("{call ghy_proc_var(?)}"); stmt.setInt(1, 14); stmt.execute(); rs = stmt.getResultSet(); while (rs.next()) { out.println("job_id value is：" + rs.getString(1) + " out.println("job_desc value is：" + rs.getString(2) + " } %> body>html>CREATE PROCEDURE ghy_proc AS select * from jobsGOCREATE PROCEDURE ghy_proc_return (@max int output,@min int output)AS select @max=@max+1select @min=@min-1GOCREATE PROCEDURE ghy_proc_var (@id int)ASselect * from jobs where job_id=@idGO