www.pudn.com > zhaobiao.rar > NewPrice.java

/** 
 *  
 */ 
package com.centralsoft.zhaobiao.admin; 
 
import java.sql.*; 
 
import com.centralsoft.zhaobiao.util.*; 
import com.centralsoft.zhaobiao.admin.*; 
/** 
 * @author zw 
 * 
 */ 
public class NewPrice { 
	public NewPrice() { 
	} 
	/** 
	 * 根据标价id删除该标价记录 
	 * @param price_id 
	 */ 
	public void delPrice(long price_id) { 
		Connection conn = null; 
		dataBase db = new dataBase(); 
		conn = db.getConnection(); 
		PreparedStatement ps = null; 
		String sql = "delete from price where price_id = ?"; 
		try { 
			ps = conn.prepareStatement(sql); 
			ps.setLong(1,price_id); 
			ps.executeUpdate(); 
		} catch (Exception e) { 
			System.out.println(e.getMessage()); 
		} finally { 
			try { 
				if (ps != null) { 
					ps.close(); 
				} 
				db.closeConn(); 
			} catch (Exception e) { 
				System.out.println(e.getMessage()); 
			} 
		} 
	} 
}