SpringMVC的Dao层的DaoImpl.java将数据插入数据库

来源：互联网发布：java注解用处编辑：程序博客网时间：2024/05/28 15:43

这是SpringMVC的Dao层的DaoImpl.java将数据插入数据库的代码

import javax.annotation.Resource;import javax.sql.DataSource;import org.springframework.jdbc.core.support.JdbcDaoSupport;import org.springframework.stereotype.Repository;import com.zx.dao.RegisterDao;import com.zx.entity.UserInfo;@SuppressWarnings("deprecation")@Repositorypublic class RegisterDaoImpl extends JdbcDaoSupport implements RegisterDao {@Resourcepublic final void setSupportDateSource(DataSource dataSource) {super.setDataSource(dataSource);}@Overridepublic void addUserInfo(UserInfo userInfo) {StringBuffer sb = new StringBuffer();  //用流的方式放入数据sb.append("insert into user_info (username,realname,Email,address,birthday,phonenumber,user_id)");sb.append("value(?,?,?,?,?,?,?)");this.getJdbcTemplate().update(sb.toString(),new Object[] { userInfo.getUsername(), userInfo.getRealname(), userInfo.getRealname(),userInfo.getEmail(), userInfo.getAddress(), userInfo.getBirthday(), userInfo.getPhonenumber(),userInfo.getUserLogin().getUserId(), });      //把get到的数据放入数组，必须是object类型的·}@Overridepublic int getUsernameAndCount(String username) {return this.getJdbcTemplate().queryForInt("select count(*) from user_login where username = ? ",new Object[] {username});}}

阅读全文

1 0