Spring整合Hibernate
配置文件方式
- <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://127.0.0.1:3306/spring_orm?characterEncoding=gbk</value>
- </property>
- <property name="username">
- <value>root</value>
- </property>
- <property name="password">
- <value>123456</value>
- </property>
- </bean>
非配置文件方式
- package dao;
- import java.util.List;
- import org.springframework.jdbc.core.JdbcTemplate;
- import org.springframework.jdbc.datasource.DriverManagerDataSource;
- publicclass TestJdbcTemplate {
- publicstaticvoid main(String[] args) {
- JdbcTemplate template = new JdbcTemplate();
- //SQLServerDriver ddd;
- //JdbcTemplate需要一个DataSource
- DriverManagerDataSource ds = new DriverManagerDataSource();
- ds.setDriverClassName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
- ds.setUrl("jdbc:sqlserver://localhost:1433;selectmethod=cursor;");
- ds.setUsername("sa");
- ds.setPassword("123456");
- template.setDataSource(ds);
- //现在就可以调用template的方法操作数据库
- List list = template.queryForList("select * from book");
- System.out.println(list.size());
- template.update("insert into book (id, name, author, price) values(?,?,?,?)",
- new Object[]{"001234","Javascript bible","Jamse Sun",12.3});
- }
- }