example15_3.java

java jdbc中的部分可以运行的源代码

import java.sql.*;
public class example15_3
{
	public static void main(String args[])
	{
		Connection con;
		Statement sql;
		ResultSet rs;
		try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		}
		catch(ClassNotFoundException e)
		{
			System.out.println(""+e);
		}
		try
		{
			con=DriverManager.getConnection("jdbc:odbc:mmm","mcx","123");
			sql=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
			rs=sql.executeQuery("SELECT * FROM stu ");
			rs.last();
			int num=rs.getRow();
			System.out.println("stu has"+num+"records");
			rs.afterLast();
			while(rs.previous())
			{
			  int number=rs.getInt(1);
			  String name=rs.getString(2);
			  String course=rs.getString("course");
			  int score=rs.getInt("score");
			  System.out.println("学号"+number);
			  System.out.println("姓名"+name);
			  System.out.println("成绩"+score);
			  System.out.println("课程"+course);
			}
			System.out.println("output the second record");
			rs.absolute(2);
			int number2=rs.getInt(1);
		    String name2=rs.getString(2);
			String course2=rs.getString("course");
			int score2=rs.getInt("score");
			System.out.println("学号"+number2);
			System.out.println("姓名"+name2);
			System.out.println("成绩"+score2);
			System.out.println("课程"+course2);
			con.close();
		}
		catch(SQLException e)
		{System.out.println(e);}
	}

}