dtbs1.java

来自「java数据库简明超小程序」· Java 代码 · 共 34 行

import java.sql.*;

public class dtbs1
{
	public static void main(String args[])
	{
		String nm,prc;
		try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		}
		catch(ClassNotFoundException e){}
		try
		{
			Connection con = DriverManager.getConnection("jdbc:odbc:BookPrice");
			Statement stmt = con.createStatement();
			String sql = "SELECT Title, Price FROM Book";
			ResultSet rs = stmt.executeQuery(sql);
			while (rs.next())
			{
				nm= rs.getString("Title");
				prc= rs.getString("Price");
				//System.out.println("书名："+nm);		
				//System.out.println("价格："+prc);		
				//System.out.println("");		
				System.out.println("书名："+nm + "    价格："+prc);		
			}
			rs.close(); 
			stmt.close(); 
			con.close(); 	
		}
		catch(Exception e){}
	}
}