queryprep.java

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

//QueryPrep.java
//查询pubs库的publishers表中的pub_id等于从键盘输入的值的记录

import java.sql.*;
import java.io.*;
public class QueryPrep

{
  public static void main(String a[])
  {
      	    Connection con=null;
	    PreparedStatement stat;
	    ResultSet res=null;
	    BufferedReader br = new BufferedReader(new InputStreamReader(System.in));
      try
      {
	    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	    con=DriverManager.getConnection("jdbc:odbc:Mypubs","sa","sa");
	    stat=con.prepareStatement("select * from publishers where pub_id=?");

	    System.out.print("pub_id = ");
	    String ID=br.readLine();  //从键盘读入值存入字串变量中
	    stat.setString(1,(String)ID);  //用值替换SQL语句中的问号参数
	    res=stat.executeQuery();
	    if(res.next())
	        System.out.println(res.getString(1)+"  "+res.getString(2)+"  "+res.getString(3)+"  "+res.getString(4));
	    else
	    {
			System.out.println("No fond.");
	    }
      }
      catch(Exception e)
      {
	    System.out.println("Could not query: "+e);
      }
      if (con!=null)
      	con=null;
  }
}