package com.hhwy.spring2018;
import org.junit.Before;
import org.junit.Test;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import org.springframework.jdbc.core.JdbcTemplate;
import com.hhwy.spring2018.domain.Employee;
import com.hhwy.spring2018.service.Caculate;
import com.hhwy.spring2018.service.testQuery;
public class TestHelloworld {
ClassPathXmlApplicationContext ioc;
@Before
public void test1(){
ioc=new ClassPathXmlApplicationContext("applicationContext.xml");
}
@Test
public void test3(){
Caculate caculate=ioc.getBean(Caculate.class);
int c=caculate.add(5, 6);
System.out.println(c);
}
@Test
public void test4(){
Object db=ioc.getBean("dataSource");
System.out.print(db);
}
@Test
public void test5(){
JdbcTemplate j=ioc.getBean(JdbcTemplate.class);
String sql="insert into employees(id,username,age) values(22,2,2)";
String sql2="delete from employees where id=22";
String sql3="update employees set username='zhang',age='2222' where id=1";
String sql4="select * from employees where id=1";
j.execute(sql4);
}
@Test
public void test6(){
testQuery test=ioc.getBean(testQuery.class);
test.update("2", "2", "222");;
}
@Test
public void test7(){
Employee e=ioc.getBean(Employee.class);
System.out.println(e.toString());
System.out.println(e.getId()+" "+e.getUsername()+" "+e.getAge()+" "+e.getMyleader().getLeadername());
}
}
import org.junit.Before;
import org.junit.Test;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import org.springframework.jdbc.core.JdbcTemplate;
import com.hhwy.spring2018.domain.Employee;
import com.hhwy.spring2018.service.Caculate;
import com.hhwy.spring2018.service.testQuery;
public class TestHelloworld {
ClassPathXmlApplicationContext ioc;
@Before
public void test1(){
ioc=new ClassPathXmlApplicationContext("applicationContext.xml");
}
@Test
public void test3(){
Caculate caculate=ioc.getBean(Caculate.class);
int c=caculate.add(5, 6);
System.out.println(c);
}
@Test
public void test4(){
Object db=ioc.getBean("dataSource");
System.out.print(db);
}
@Test
public void test5(){
JdbcTemplate j=ioc.getBean(JdbcTemplate.class);
String sql="insert into employees(id,username,age) values(22,2,2)";
String sql2="delete from employees where id=22";
String sql3="update employees set username='zhang',age='2222' where id=1";
String sql4="select * from employees where id=1";
j.execute(sql4);
}
@Test
public void test6(){
testQuery test=ioc.getBean(testQuery.class);
test.update("2", "2", "222");;
}
@Test
public void test7(){
Employee e=ioc.getBean(Employee.class);
System.out.println(e.toString());
System.out.println(e.getId()+" "+e.getUsername()+" "+e.getAge()+" "+e.getMyleader().getLeadername());
}
}