javaµ÷Óô洢¹ý³ÌµÄÀý×Ó

package protest;
import java.sql.*;
/**
 create proc proc_select
             @lname varchar(20),
             @address varchar(20) output
as
        select   @address=address from userinfo where loginname=@lname
GO
 */
public class ProExecute {
    public ProExecute() {
    }
    public static void main(String args[]) {
       try{
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");//¼ÓÔØÇý¶¯
        Connection con = DriverManager.getConnection("Jdbc:Odbc:test", "sa", "sa"); //»ñµÃÁ¬½Ó
        String call = "{call proc_select(?,?)}"; //µ÷ÓÃÓï¾ä
        CallableStatement proc = con.prepareCall(call); //µ÷Óô洢¹ý³Ì
        proc.setString(1, "zhangdan"); //¸øÊäÈë²ÎÊý´«Öµ
        proc.registerOutParameter(2,Types.VARCHAR); //ÉùÃ÷Êä³ö²ÎÊýÊÇʲôÀàÐ͵Ä,¶¨ÒåÓÃÓÚ±êʶһ°ã SQL ÀàÐÍ£¨³ÆΪ JDBC ÀàÐÍ£©µÄ³£Á¿µÄÀà
        proc.execute(); //Ö´ÐÐ
        String address = proc.getString(2); //»ñµÃÊä³ö²ÎÊý
        System.out.println(address);
       } catch(Exception e){
            e.printStackTrace();
        }
    }
}