newprice.java

自己做的一个企业招标系统,B/S结构。开发工具Eclipse

/**
 * 
 */
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());
			}
		}
	}
}