springjdbc 手动注入 java工程测试

1.导入相关jar包

2.编写配置文件

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:context="http://www.springframework.org/schema/context"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
  http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.3.xsd">
<context:annotation-config/>
<context:component-scan base-package="com.shi"/>

<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
  <property name="driverClassName" value="com.mysql.jdbc.Driver"></property>
  <property name="url" value="jdbc:mysql://127.0.0.1:3306/hbgcdx"></property>
  <property name="username" value="root"></property>
  <property name="password" value="root"></property>
</bean>

<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
  <property name="dataSource" ref="dataSource"></property>
</bean>

</beans>

3.实体类User

package com.shi.entity;

public class User {
private Integer id;
private String name;
private String password;
public Integer getId() {
  return id;
}
public void setId(Integer id) {
  this.id = id;
}
public String getName() {
  return name;
}
public void setName(String name) {
  this.name = name;
}
public String getPassword() {
  return password;
}
public void setPassword(String password) {
  this.password = password;
}
}

4.编写接口类UserDao

package com.shi.dao;

import java.util.List;

import com.shi.entity.User;

public interface UserDao {
public static void main(String[] args) {
int []a[]=new int[4][];
boolean s=false;
}
void delete(Integer id);
void update(User user);
void add(User user);
String selectUserName(Integer id);
User selectUser(Integer id);
List<User> selectUser();

}

4.编写实现类UserDaoImpl

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.工程结构

springjdbc 手动注入 java工程测试

相关推荐