根据字段名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"