initdatabase.java

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

package util;

import java.io.File;
import java.sql.Timestamp;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

import javax.xml.bind.JAXBContext;
import javax.xml.bind.JAXBException;
import javax.xml.bind.Unmarshaller;

import service.IService;
import service.ServiceImpl;
import xmlbinding.contrats.Contrat;
import xmlbinding.contrats.Contrats;
import xmlbinding.contrats.Passage;
import xmlbinding.journees.Journee;
import xmlbinding.journees.Journees;
import xmlbinding.journees.Plage;
import dao.model.Spot;
import exception.MetieException;


public class InitDatabase {
	public static void initPlages(File file){
		JAXBContext jc;
		Journees journees=null;
		try {
			jc = JAXBContext.newInstance("xmlbinding.journees");
			Unmarshaller u = jc.createUnmarshaller();
			journees=(Journees) u.unmarshal(file);
			IService service=new ServiceImpl();
			for(Journee j:journees.getJournee()){
				String date=j.getId();
				for(Plage p:j.getPlage()){
					String datetime=date+" "+p.getDebut();
					Date d=new SimpleDateFormat("dd/MM/yyyy h:mm").parse(datetime);
					dao.model.Plage plage =new dao.model.Plage();
					Timestamp debut=new Timestamp(d.getTime());
					plage.setDebut(debut);
					plage.setDuree(Integer.parseInt(p.getDuree()));
					plage.setCategorie(p.getCategorie());
					service.addPlage(plage);
				}
				
			}
		} catch (JAXBException e) {
			e.printStackTrace();
		} catch (MetieException e) {
			e.printStackTrace();
		} catch (ParseException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
	}
	public  static List<dao.model.Contrat> initContrats(File file){
		JAXBContext jc;
		Contrats xmlcontrats=null;
		List<dao.model.Contrat> listContrat=new ArrayList<dao.model.Contrat>();
		try {
			jc = JAXBContext.newInstance("xmlbinding.contrats");
			Unmarshaller u = jc.createUnmarshaller();
			xmlcontrats=(Contrats) u.unmarshal(file);
			for(Contrat xmlcontrat:xmlcontrats.getContrat()){
				dao.model.Contrat contrat =new dao.model.Contrat();
				contrat.setNomClient(xmlcontrat.getClient().trim());
				Spot s=new Spot();
				s.setDuree(Integer.parseInt(xmlcontrat.getSpot().getDuree()));
				s.setTheme(xmlcontrat.getSpot().getTheme());
				s.setTitre(xmlcontrat.getSpot().getTitre());
				List<dao.model.Passage> list=new ArrayList<dao.model.Passage>();
				for(Passage xmlpassage:xmlcontrat.getSpot().getPassage()){
					dao.model.Passage passage=new dao.model.Passage();
					passage.setCategorie(xmlpassage.getCategorie());
					passage.setNombre(Integer.parseInt(xmlpassage.getNombre()));
					list.add(passage);
				}
				s.setLesPassages(list);
				contrat.setSpot(s);
				listContrat.add(contrat);
			}
			return listContrat;
	}catch (JAXBException e) {
		e.printStackTrace();
		return  null;
	}
	}
}