<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
FONT-SIZE: 10pt;
FONT-FAMILY:Tahoma
}
</style>
</head>
<body class='hmmessage'>
$B:d0f$G$9!#(B<br><br>$B$*@$OC$K$J$j$^$9!#:rF|$N(BUPDATE$B$rMxMQ$7$?(BSQL$B%U%!%$%k$NH/9T$O(B<br>$B@.8y$7$?$N$G$9$,!"(Binsert$B$G$bF1$8>I>u$,$G$F$7$^$C$F$$$^$9!#(B<br>$B0lBN$J$K$,0-$/$F%(%i!<$,=P$F$$$k$N$+$,J,$+$j$^$;$s!#(B<br>$B!J(BUPDATE$B$b;n9T:x8m$G$J$s$H$+F0$-$^$7$?$,!"$J$K$,$h$/$FF0$$$F$$$k$N$+$o$+$i$J$$>uBV!K(B<br>$B2?B4$465<x$*4j$$$$$?$7$^$9!#(B<br><br><br>$B"((BDAO<br><br>@S2Dao(bean = Profile.class)<br>public interface ProfileDao {<br> <br> public static final String insertData_ARGS ="profile";<br> <br> <br> public Profile[] selectAll();<br> <br> public Profile[] select(Profile p);<br><br> @Arguments("ID")<br> public Profile selectById(int id);<br><br> @Arguments("USER_ID")<br> public Profile selectByUserId(String userId);<br> <br> //@SqlFile<br> //public int insert(Profile profile);<br> <br> //@SqlFile<br> public int insertMember(Profile profile);<br> <br> public int insertData(Profile profile);<br> <br> @NoPersistentProperty( { "createUserId", "createDate" })<br> public int update(Profile profile);<br><br> public int delete(Profile profile);<br>}<br><br>$B"((BSQL$B%U%!%$%k(B<br><br>insert into profile (user_id, password, name, sex)<br>values (/*page.userid*/, /*page.password*/ , /*page.name*/ , /*page.sex*/)<br><br><br>$B"(0z?t$H$7$FEO$7$F$$$k(BEntity$B%U%!%$%k(B<br><br>@Bean(table="PROFILE")<br>public class Profile {<br><br> private int id;<br><br> private String userId;<br> <br> private String password;<br><br> private String name;<br><br> private String sex;<br><br> private String birthDay;<br><br> private String introdunctionText;<br><br> private String img;<br><br> private String publicDiv;<br><br> private String createUserId;<br><br> private String updateUserId;<br><br> private Timestamp createDate;<br><br> private Timestamp updateDate;<br><br> private Integer versionId;<br><br> public int getId() {<br> return id;<br> }<br><br> public void setId(int id) {<br> this.id = id;<br> }<br><br> @Column("USER_ID")<br> public String getUserId() {<br> return userId;<br> }<br><br> public void setUserId(String userId) {<br> System.out.println("this is Profile.java$B$N(BsetUserID");<br> this.userId = userId;<br> }<br><br> public String getName() {<br> System.out.println("this is Profile.java$B$N(BgetUserID");<br> System.out.println(name);<br> return name;<br> }<br><br> public void setName(String name) {<br> System.out.println("this is Profile.java$B$N(BsetUserID");<br> System.out.println(name);<br> this.name = name;<br> }<br><br> public String getSex() {<br> return sex;<br> }<br><br> public void setSex(String sex) {<br> this.sex = sex;<br> }<br><br> @Column("BIRTH_DAY")<br> public String getBirthDay() {<br> return birthDay;<br> }<br><br> public void setBirthDay(String birthDay) {<br> this.birthDay = birthDay;<br> }<br><br> @Column("INTRODUNCTION_TEXT")<br> public String getIntrodunctionText() {<br> return introdunctionText;<br> }<br><br> public void setIntrodunctionText(String introdunctionText) {<br> this.introdunctionText = introdunctionText;<br> }<br><br> public String getImg() {<br> return img;<br> }<br><br> public void setImg(String img) {<br> this.img = img;<br> }<br><br> @Column("PUBLIC_DIV")<br> public String getPublicDiv() {<br> return publicDiv;<br> }<br><br> public void setPublicDiv(String publicDiv) {<br> this.publicDiv = publicDiv;<br> }<br><br> @Column("CREATE_USER_ID")<br> public String getCreateUserId() {<br> return createUserId;<br> }<br><br> public void setCreateUserId(String createUserId) {<br> this.createUserId = createUserId;<br> }<br><br> @Column("UPDATE_USER_ID")<br> public String getUpdateUserId() {<br> return updateUserId;<br> }<br><br> public void setUpdateUserId(String updateUserId) {<br> this.updateUserId = updateUserId;<br> }<br><br> @Column("CREATE_DATE")<br> public Timestamp getCreateDate() {<br> return createDate;<br> }<br><br> public void setCreateDate(Timestamp createDate) {<br> this.createDate = createDate;<br> }<br><br> @Column("UPDATE_DATE")<br> public Timestamp getUpdateDate() {<br> return updateDate;<br> }<br><br> public void setUpdateDate(Timestamp updateDate) {<br> this.updateDate = updateDate;<br> }<br><br> @Column("VERSION_ID")<br> public Integer getVersionId() {<br> return versionId;<br> }<br><br> public void setVersionId(Integer versionId) {<br> this.versionId = versionId;<br> }<br><br> @Column("PASSWORD")<br> public String getPassword() {<br> return password;<br> }<br><br> public void setPassword(String password) {<br> this.password = password;<br> }<br><br>}<br><br>$B"((BDDL<br><br>create table profile(<br> id integer, <br> user_id varchar(255), <br> name varchar(255),<br> sex varchar(1), <br> birth_day varchar(8), <br> introdunction_text varchar(255), <br> img varchar(255), <br> public_div varchar(1), <br> create_user_id varchar(255), <br> update_user_id varchar(255), <br> create_date timestamp, <br> update_date timestamp, <br> version_id integer,<br> primary key (id)<br>);<br>CREATE SEQUENCE profile_id INCREMENT 1 START 1;<br><br><br><br /><hr />$B!V%Z%C%H$NG:$_!"$_$s$J$K$-$$$?$i2r7h$7$?!#!W0B?4$N%Z%C%H%i%$%U$K(BMSN$BAjCLH"(B <a href='http://clk.atdmt.com/GBL/go/msnjpqjl0040000021gbl/direct/01/' target='_new'>http://questionbox.msn.co.jp/c531.html</a></body>
</html>