categoriedao.java

用xml+swing+jdbc(hsqldb)写的电视广告管理软件 客户定义好广告的具体信息

package dao;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;




import dao.model.Categorie;



public class CategorieDao extends BaseDao{

	private static final String SQL_INSERT_CATEGORIE="" +
			"insert into categorie values(?,?)";
	private static final String SQL_UPDATE_CATEGORIE="" +
			"UPDATE categorie set prix =? where nom = ?";
	private static final String SQL_SELECT_CATEGORIE="" +
			"SELECT * FROM CATEGORIE WHERE NOM =? ";
	private static final String SQL_ALL_CATEGORIE="" +
			"SELECT * FROM CATEGORIE";
	public void insert (Categorie c){
		PreparedStatement ps ;
			try {
				ps = getConnection().prepareStatement(SQL_INSERT_CATEGORIE);
				ps.setString(1,c.getNom());
				ps.setBigDecimal(2, c.getPrix());
				ps.executeUpdate();
				
			} catch (SQLException e) {
				e.printStackTrace();
			} 
			}
		
	public void update(Categorie c){
		PreparedStatement ps;
		try{
			ps = getConnection().prepareStatement(SQL_UPDATE_CATEGORIE);
			ps.setBigDecimal(1, c.getPrix());
			ps.setString(2, c.getNom());
			ps.execute();
		}catch (SQLException e) {
			e.printStackTrace();
		} 
	}
	
	public Categorie rechercher(String nom){
		PreparedStatement ps;
		Categorie c = new Categorie();
		try{
			ps = getConnection().prepareStatement(SQL_SELECT_CATEGORIE);
			ps.setString(1, nom);
			ResultSet rs=ps.executeQuery();
			if(rs.next()){
				
				c.setNom(rs.getString(1));
				c.setPrix(rs.getBigDecimal(2));
				
			}
		}catch (SQLException e) {
			e.printStackTrace();
		}
		return c; 
	}
	
	public List<Categorie> listage(){
		
		List<Categorie> l = new ArrayList<Categorie>();
		PreparedStatement ps;
		try{
			ps=getConnection().prepareStatement(SQL_ALL_CATEGORIE);
			ResultSet rs=ps.executeQuery();
			while(rs.next()){
				Categorie c = new Categorie();
				c.setNom(rs.getString(1));
				c.setPrix(rs.getBigDecimal(2));
				l.add(c);
			}
		}catch(SQLException e){
			e.printStackTrace();
		}
		return l;
	}
		}