spring

public static void main(String[] args) {
ApplicationContext context=new ClassPathXmlApplicationContext("classpath:spring-ibatis-context.xml");
BookService book=(BookService) context.getBean("bookService");
System.out.println(book.getAllBooksPageTotal(1,5));
}

 

public static void main(String[] args) {
ApplicationContext context=new ClassPathXmlApplicationContext("classpath:spring-ibatis-context.xml");
AdminDao adminDao=(AdminDao) context.getBean("adminDao");
System.out.println(adminDao.getUsername(123456));
}

 

<bean id="dataSource"
class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName"
value="com.mysql.jdbc.Driver">
</property>
<property name="url"
value="jdbc:mysql://localhost:3306/db_guahao?characterEncoding=utf-8">
</property>
<property name="username" value="root"></property>
<property name="password" value="root"></property>
</bean>
<!-- zhuyanhua 20200717 -->
<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
<property name="dataSource" ref="dataSource"></property>
</bean>

<bean id="JdbcDAO" class="com.dao.JdbcDAO">
<property name="jdbcTemplate">
<ref bean="jdbcTemplate" />
</property>
</bean>

 

package com.dao;

import java.util.List;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.hibernate.LockMode;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.support.JdbcDaoSupport;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import com.model.TAdmin;

/**
* Data access object (DAO) for domain model class TAdmin.
*
* @see com.model.TAdmin
* @author MyEclipse Persistence Tools
*/

public class JdbcDao extends JdbcDaoSupport {
private static final Log log = LogFactory.getLog(JdbcDao.class);

// property constants
public static final String USER_NAME = "userName";

public static final String USER_PW = "userPw";

protected void initDao() {
// do nothing
}

public void save(TAdmin admin) {
log.debug("saving TAdmin instance");
String sql = "insert into t_admin values('"+"2'"+",'name001"+"','pwd001')";
//System.out.println("-----------"+sql);
this.getJdbcTemplate().update(sql);//, "TEST_001", "TEST_name","PWD_001");
}

public static JdbcDao getFromApplicationContext(ApplicationContext ctx) {
return (JdbcDao) ctx.getBean("TAdminDAO");
}

public static void main(String[] args) {
ApplicationContext context=new ClassPathXmlApplicationContext("classpath:applicationContext.xml");
JdbcDao adminDao=(JdbcDao) context.getBean("JdbcDao");
adminDao.save(null);
}
}