spring 内置的jdbc支持可以简化jdbc的操作

User 实体类

public class User {
 private int userid;
 private String username;
 private String password;

?

UserDao接口

public interface UserDao {
 List findAll();
 User getUserById(int id);
 boolean addUser(User user);
 boolean deleteUser(User user);
 boolean updateUser(User user);
}

?UserDaoImpl实现类

public class UserDaoImpl implements UserDao {
 private JdbcTemplate jdt = null;
 @Override
 public boolean addUser(User user) {
  String sql = "insert into user values(?,?,?)";
  Object [] args = {user.getUserid(),user.getUsername(),user.getPassword()};
  jdt.update(sql, args);
  return false;
 }
}

?配置文件
?

<bean id="datasrc" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
  <property name="driverClassName" value="com.mysql.jdbc.Driver"></property>
  <property name="username" value="root"></property>
  <property name="password" value=""></property>
  <property name="url" value="jdbc:mysql://localhost:3306/spring"></property>
 </bean>
 <bean id="jdbctemplate" class="org.springframework.jdbc.core.JdbcTemplate">
  <property name="dataSource" ref="datasrc"></property>
 </bean>  
 <bean id="userdaoimpl" class="com.dowebber.dao.impl.UserDaoImpl">
  <property name="jdt" ref="jdbctemplate"></property>
 </bean>

?测试类:

?

public static void main(String[] args) {
  ApplicationContext context = new ClassPathXmlApplicationContext("spring.xml");
  
  UserDaoImpl udi = (UserDaoImpl) context.getBean("userdaoimpl");
  
  User user = new User();
  
  user.setUserid(1);
  user.setUsername("namezhou");
  user.setPassword("thepass");
  
  udi.addUser(user);
  
  System.out.println("done...");
 }

?总结:
此程序没有启用事务,需要为实现类增加一个工具属性

并通过JdbcTemplate的对象来实现jdbc的轻量级封装,构造jdbctemplate对象需要DataSource对象

DataSource对象包含连接数据库需要的最基本信息

?