newprice.java~2~~1~

对项目

package zhaobiao.db;

import java.util.*;
import java.sql.*;
import zhaobiao.db.*;
import zhaobiao.date.*;
/**
 * <p>Title: 厂商信息管理类</p>
 * <p>Description: 有关厂商信息管理的浏览操作</p>
 * <p>Copyright: Copyright (c) 2003</p>
 * <p>Company: </p>
 * @author unascribed
 * @version 1.0
 */
public class NewPrice {

  public NewPrice() {
  }

  public void addPrice(Price price)
  {
    db=DBConnectionManager.getInstance();
    con=db.getConnection("idb");
    long maxid=0;
    try {
      PreparedStatement ps1 = con.prepareStatement("select max(price_id) as id from price");
      rs =ps1.executeQuery();
      if(rs.next() ){
        maxid = rs.getLong("id")+1 ;
      }
      else
        maxid=1;
      if(ps1!=null)
        ps1.close();
    }
    catch (SQLException ex) {
      ex.printStackTrace() ;
    }
    String sql="insert into price(price_id,t1,t2,t3,t4,t5,t6,t7,t8)values(?,?,?,?,?,?,?,?,?)";
  }
  public static void main(String[] args) {
    NewPrice newPrice1 = new NewPrice();
  }
  /**
 * 释放数据库资源<p>
 *PreparedStatement和ResultSep将关闭，Connection返回给连接池
 * @param      无
  * @repurn     无
  * @exception  SQLException
  *
  */
 public void freeCon(){
   try {
     if (rs!=null)
       rs.close() ;
     if (ps!=null)
       ps.close() ;
   }
   catch (SQLException ex) {
   }
   if (db!=null)
     db.freeConnection("idb",con) ;
 }

 private PreparedStatement ps=null;
 private DBConnectionManager db;
 private Connection con=null;
  private ResultSet rs=null;
}