hibernateÖ´ÐÐÔ­ÉúSqlÓï¾äµÄ·½·¨£¨×ª£©

http://www.thecloud.cn/study/program/java/597.html
hibernate3µÄHQL ÊÇÃæÏò¶ÔÏóµÄÓï·¨,ÒѾ­Ö§³Ö update ,delete fromÓï¾ä,µ«
Ä¿Ç°»¹²»Ö§³Öinsert intoÓï¾ä.
×öÏîÄ¿ÓÐʱºòµÄÈ·ÐèҪдԭÉúµÄsqlÀ´·½±ãweb¿ª·¢.
ÏÂÃæÊÇÎÒ×Ô¼º¹Äµ·³öÀ´µÄ·½·¨,Ï£Íû¶ÔÎÒºÍÅóÓÑÓÐËù°ïÖú.
ÔÚDaoÀïдһ¸ö·½·¨,ÈÃÎÒÃÇÔÚactionÀïµ÷ÓÃËü...
 
public void InsertData(String MytblName,String
Mytitle,String Mycode,String Mycoments){
   
log.debug("insert into dataitems ---drs");
   //ʹÓÃÁËÔ­ÉúsqlÓï¾ä
    try{
   
//½«´«ÈëµÄÀàÃû´¦Àí³É±íÃû ÀýÈç:CTable----¡µC_Table 
   
MytblName = "C_"+MytblName.substring(1,MytblName.length());
    //²åÈë±í µÄ
sql
 
   
String Insert_SQL ="INSERT INTO "+MytblName+
    "
(C_Title,C_Code,C_Comments)"+
    " VALUES
('"+Mytitle+"','"+Mycode+"','"+Mycoments+"')" ;
   
//»ñµÃµ±Ç°sessionµÄÊý¾Ý¿âÁ¬½Ó
    Connection
CurConn   =
getSession().connection();
   
//System.out.println(Insert_SQL);
   
//Éú³ÉÒ»¸öStatement¶ÔÏó
   
PreparedStatement ps = CurConn.prepareStatement(Insert_SQL);
   
    //Ö´Ðвéѯ
   
ps.execute();
   
//¹Ø±Õ¸Ã¶ÔÏó
   
ps.close();
   
getSession().flush();
   
 
   
log.debug("insert into dataitems 
successful");
    }
    catch
(SQLException Re ){ // Òì³£
    
log.error("insert into dataitems failed", Re);
    
Re.printStackTrace();
    }
      
  }