MVC数据库更新

根据字段名id修改name值

1、在UserBean中写入关键代码

package cn.training.bean;

public class UserBean { private String userId;

public String getUserId() {return userId;}

public void setUserId(String userId) {this.userId = userId;}

private String userName;public String getUserName() {return userName;}

public void setUserName(String userName) {this.userName = userName;}}

2、在UserSqlMap中写入关键代码

<select id="selectUser"parameterClass="cn.training.bean.UserBean"

resultClass="cn.training.bean.UserBean">

SELECT userid as userId, username as userName FROM user WHERE userid = #userId#  "重点查询SQL语句1"

</select>

<insert id="userinsert" parameterClass="cn.training.bean.UserBean">

insert into user(userid) values(#userId#)</insert>

<update id="userupdate" parameterClass="cn.training.bean.UserBean">

UPDATE user SET username=#userName# WHERE userid=#userId#“重点SQl语句2更新语句”

</update>

3、在HelloworldService中键入关键代码

public int update(UserBean frm){return updateDao.execute("User.userupdate", frm);

4、在Helloworldcontroller中键入关键代码

 public String updateLogin(UserBean userBean, Model model) {

    int result= helloWorldService.update(userBean);

    if(result==1) {

    model.addAttribute("message", "ok");

    return "result";

    }else{

    model.addAttribute("message", "false");

    return "result";}

连接数据库在context.xml中写入关键代码

连接本地数据库的写法：

  username="root"

     password="root"

     url="jdbc:mysql://localhost:3306/test"

连接远程数据库

 username="training"

     password="training"

     url="jdbc:mysql://172.30.201.34:3306/agriculture"

转载于:https://my.oschina.net/u/2411775/blog/478751