Spring | JdbcTemplate & Mysql 2

.xml配置文件beans.xml<?XML:NAMESPACE PREFIX = O />

<? xml version = "1.0" encoding = "UTF-8" ?>

<! DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd" >

 

< beans >

    < bean id = "dataSource" class = "org.springframework.jdbc.datasource.DriverManagerDataSource" >

       < property name = "driverClassName" >

            < value > com.mysql.jdbc.Driver </ value >

        </ property >

      

       < property name = "url" >

            < value > jdbc:mysql:///students </ value >

        </ property >

       

        < property name = "username" >

            < value > root </ value >

        </ property >

       

        < property name = "password" >

            < value ></ value >

        </ property >

    </ bean >

   

      < bean id = "jdbcTemplate"  class = "org.springframework.jdbc.core.JdbcTemplate" >

        < property name = "dataSource" >

        < ref bean = "dataSource" />

        </ property >

      </ bean >

     

      < bean id = "userDAO" class = "cn.zhd.DAO.Imp.UserDAOImp" >

        < property name = "jt" >

        < ref bean = "jdbcTemplate" />

        </ property >

      </ bean >

     

      < bean id = "user" class = "cn.zhd.Model.User" >

        < property name = "dao" >

        < ref bean = "userDAO" />

        </ property >

        < property name = "name" >

        < value > zjd </ value >

        </ property >

        < property name = "password" >

        < value > 888 </ value >

        </ property >

      </ bean >  

</ beans >

 
.测试类 JavaTest.java
package cn.zhd.Model;

 

import java.util.ArrayList;

import java.util.List;

 

import org.springframework.beans.factory.BeanFactory;

import org.springframework.beans.factory.xml.XmlBeanFactory;

import org.springframework.core.io.ClassPathResource;

import org.springframework.core.io.Resource;

 

 

 

public class UserTest {

     public static void main(String []args){

     //     User u=new   User("zjd","888");

            // 批量插入数据

            List<User> u =  new  ArrayList<User>();

            u.add(new User("haha","123"));

            u.add(new User("hoho","234"));

            u.add(new User("zhansan","345"));

            u.add(new User("lisi","456"));

            u.add(new User("maqi","577"));

            u.add(new User("wo","899"));

            u.add(new User("admin","haha"));

            u.add(new User("fdsdf","675"));

            u.add(new User("werwr","89"));

            Resource resource=new ClassPathResource("beans.xml");

             BeanFactory factory = new XmlBeanFactory(resource);

             User user = (User) factory.getBean("user");

            // user.insert();

            // user.update("update admin set name='zbj' where id=2");

              user.insertBatchData(u);

            // user.selectWithTemp();

            // user.selectById("2");

            // user.getInfo("2");

     }

}

 
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值