example7.java

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

package chapter17;

import java.sql.*;
import java.text.DateFormat;


public class example7
{
	public static void main(String args[ ])
	{
		String strQuery="SELECT * FROM StudentInfo";
		Connection conn;
		PreparedStatement stat;
		ParameterMetaData prmd;
		ResultSet rs;
		String sSID,sName,sSex,sClass;
		Date dBirth;
		try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			conn=DriverManager.getConnection("jdbc:odbc:Student","sa","");
			
			stat=conn.prepareStatement(strQuery);
			
			prmd=stat.getParameterMetaData();
			System.out.println("参数个数 : "+prmd.getParameterCount());
			
			rs=stat.executeQuery();
			
			
			while(rs.next())
			{
				sSID=rs.getString(1);
				sName=rs.getString(2);
				sSex=rs.getString(3);
				dBirth=rs.getDate(4);
				sClass=rs.getString(5);
				System.out.println(sSID+" "+sName+" "+sSex+" "+dBirth+" "+sClass);
			}
			rs.close();
		}
		catch(Exception err)
		{
			err.printStackTrace();
		}
	}
}