example15_4.java

来自「java jdbc中的部分可以运行的源代码」· Java 代码 · 共 42 行

import java.sql.*;
public class example15_4
{
	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();
			String condition="SELECT * FROM stu ORDER BY score";
			rs=sql.executeQuery(condition);

			while(rs.next())
			{
			  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);
			}

			con.close();
		}
		catch(SQLException e)
		{System.out.println(e);}
	}

}