67,513
社区成员
发帖
与我相关
我的任务
分享
我刚学ibatis
<select id="login" parameterClass="User" resultMap="user">
SELECT * FROM users where userName=#userName# and password=#password#
</select>
<insert id="register" parameterClass="User">
insert into users(uid,userName,password,userType) values
(#uid# ,#userName# ,#password#,#userType#);
</insert>
User user = new User();
// user.setUid(10);
user.setUserName(userName);
user.setPassword(password);
user.setUserType("1");
boolean bool = SpringUtil.getBeans().getUserDao().insert(user);
DROP TABLE IF EXISTS `store`.`users`;
CREATE TABLE `store`.`users` (
`uid` int auto_increment primary key ,
`userName` varchar(20) NOT NULL,
`password` varchar(32) NOT NULL,
`userType` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
<insert id="insertProduct-MYSQL" parameterClass="User">
insert into users values(null,#userName# ,#password#,#userType#);
<selectKey resultClass="int" keyProperty="uid">
SELECT @@IDENTITY AS UID
</selectKey>
</insert>
<insert id="insertUser" parameterClass="User">
insert into t_user values (
null,#username#,#password#,#,#userType#
)
//如果主键是自动生成的,则其返回值可以通过<selectKey>标签来设置
//如果不通过<selectKey>标签来设置,则返回值为空!
<selectKey resultClass="int" keyProperty="id">
SELECT @@IDENTITY AS ID
</selectKey>
</insert>