example3.java

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

package chapter17;

import java.sql.*;

public class example3 
{
	public static void main(String args[ ])	
	{
		Connection conn;
		CallableStatement stat;
		ResultSet rs;
		String strSID="06120401";
		String strName;
		String strSex;
		Date dBirth;
		String strClass;
		try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			conn=DriverManager.getConnection("jdbc:odbc:Student","sa","");
			stat=conn.prepareCall("{CALL prcGetOneStudentInformation(?)}");
			stat.setString(1,strSID);
			rs=stat.executeQuery();
			if(rs.next())
			{			
				strName=rs.getString(2);
				strSex=rs.getString(3);
				dBirth=rs.getDate(4);
				strClass=rs.getString(5);
				System.out.println(strSID+" "+strName+" "+strSex+" "+dBirth+" "+strClass);
			}
			conn.close();
		}
		catch(Exception err)
		{
			err.printStackTrace();
		}
	}
}