1 java 類型，???????????? hibernate 類型?????? sql
? java .lang.String?????? string?????????????? varchar
? java.lang.String??????? text???????????????? Text
? int???????????????????? int????????????????? INT
? char??????????????????? character???????????? char(1)
? boolean???????????????? boolean????????????? bit
? byte[]????????????????? binary?????????????? blob
? java.sql.Date?????????? date???????????????? Date
? java.sql.Timestamp????? timestamp??????????? Timestamp (載數(shù)據(jù)庫中如果插入為null，數(shù)據(jù)庫系統(tǒng)自動(dòng)插入為當(dāng)前值)
2 表述層－－》業(yè)務(wù)邏輯層－》hibernate－》database
3
? Configuration config=new Configuration();
? config.add(Customer.class);
? sessionFactory=conf.buildSessionFactory();
? Session session=sessionFactory.openSession();
? Transaction tx;
? try{
?? tx=session.beginTransaction();
?? tx.commit();
? }catch(Exception e){
??? if(tx!=null){
????? tx.rollback();
??? }
? }finally{
??? session.close();
? }
4 數(shù)據(jù)庫存取blob 對(duì)象
?1
?? InputStream in=this.getClass().getResourceAsStream("photo.gif");
?? byte[] buffer=new byte[in.available()]'
?? in.read(buffer);
?? customer.setImage(buffer);
?2 byte[] buffer=customer.get.getImage();
?? File OutputStream fout=new fileOutStream("photo.gif");
?? fout.write(buffer);
?? fout.close();