query.java

这是用java实现的一个仓储管理系统

//Query.java
//查询pubs库的publishers表中的所有记录

import java.sql.*;
public class Query
{
    public static void main(String a[])
    {
        Connection con=null;
	Statement stat;
	ResultSet res;
        try
        {
	    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	    con=DriverManager.getConnection("jdbc:odbc:Mypubs","sa","sa");
	    stat=con.createStatement();
	    res=stat.executeQuery("select * from publishers");
	    while(res.next())
	    {
	        System.out.println(res.getString(1)+"  "+res.getString(2)+"  "+res.getString(3)+"  "+res.getString(4));
	    }
        }
        catch(Exception e)
        {
	    System.out.println("Could not query: "+e);
        }
	if (con!=null)
	    con=null;
    }
}