example4.java

来自「Java面向对象编程(随书配套源代码) 阐述了面向对象编程的思想」· Java 代码 · 共 34 行

package chapter17;

import java.sql.*;

public class example4 
{
	public static void main(String args[ ])	
	{
		Connection conn;
		CallableStatement stat;
		int rows;
		String strSID="06120401";
		String strName;
		try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			conn=DriverManager.getConnection("jdbc:odbc:Student","sa","");
			stat=conn.prepareCall("{CALL prcGetStudentName(?,?)}");
			stat.setString(1,strSID);
			stat.registerOutParameter(2,java.sql.Types.VARCHAR);		
			rows=stat.executeUpdate();
			if(rows>0)
			{				
				System.out.println(stat.getString(2));
			}
			conn.close();
		}
		catch(Exception err)
		{
			err.printStackTrace();
		}
	}
}