1 2 3 4 5 6 7 8 9 10 11 12 13 14
| - <sqlMap namespace="Articles">
<typeAlias alias="article" type="istia.st.articles.dao.Article" />
- <resultMap id="article" class="article">
<result property="id" column="ID" />
<result property="nom" column="NOM" />
<result property="prix" column="PRIX" />
<result property="stockActuel" column="STOCKACTUEL" />
<result property="stockMinimum" column="STOCKMINIMUM" columnIndex="5" />
</resultMap>
<statement id="getAllArticles" resultMap="article">select id, nom, prix, stockactuel, stockminimum from ARTICLES</statement>
<statement id="clearAllArticles">delete from ARTICLES</statement>
<statement id="insertArticle">insert into ARTICLES (id, nom, prix, stockactuel, stockminimum) values (#id#,#nom#,#prix#,#stockactuel#,#stockminimum#)</statement>
<statement id="deleteArticle">delete FROM ARTICLES where id=#id#</statement>
</sqlMap> |
Partager