package com.shi.dao.impl;
import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Component;
import com.shi.dao.UserDao;
import com.shi.entity.User;
@Component("UserDaoImpl")
public class UserDaoImpl implements UserDao {
@Autowired
private JdbcTemplate jdbcTemplate;
public JdbcTemplate getJdbcTemplate() {
return jdbcTemplate;
}
public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
this.jdbcTemplate = jdbcTemplate;
}
@Override
public void delete(Integer id) {
// TODO Auto-generated method stub
String sql="delete from user where id=?";
jdbcTemplate.update(sql, id);
}
@Override
public void update(User user) {
// TODO Auto-generated method stub
String sql="update user set name=? and pwd=? where id=?";
jdbcTemplate.update(sql, user.getName(),user.getPassword(),user.getId());
}
@Override
public void add(User user) {
// TODO Auto-generated method stub
String sql="insert into user(name,pwd) values(?,?)";
jdbcTemplate.update(sql, user.getName(),user.getPassword(),user.getId());
}
@Override
public String selectUserName(Integer id) {
// TODO Auto-generated method stub
String sql="select name from user where id=?";
System.out.println("dddddd"+jdbcTemplate);
String name = jdbcTemplate.queryForObject(sql, String.class, id);
return name;
}
@Override
public User selectUser(Integer id) {
// TODO Auto-generated method stub
String sql="select id,name,pwd from user where id=?";
return null;
}
@Override
public List<User> selectUser() {
// TODO Auto-generated method stub
String sql="select id,name,pwd from user";
return null;
}
}
6.测试类UserDaoTest |
package com.shi.test;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import com.shi.dao.UserDao;
public class UserDaoTest {
public static void main(String[] args) {
ApplicationContext fanctoty = new ClassPathXmlApplicationContext("application.xml");
UserDao dao=(UserDao) fanctoty.getBean("UserDaoImpl");
// System.out.println(dao);
String name = dao.selectUserName(2);
System.out.println(name);
//System.out.println(new JdbcTemplate());
}
}
|
7.工程结构 | |
|