1. maven依赖配置如下
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.10</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.40</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>4.3.15.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-tx</artifactId>
<version>4.3.15.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context-support</artifactId>
<version>4.3.15.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-aspects</artifactId>
<version>4.3.15.RELEASE</version>
</dependency>
2. 编写java代码连接并查询数据
import dao.template.StudentDao;
import org.junit.Assert;
import org.junit.Test;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.RowMapper;
import org.springframework.jdbc.datasource.DriverManagerDataSource;
import pojo.Student;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;
public class JDBCTemplateTest {
class MyRowMapper implements RowMapper<Student> {
public Student mapRow(ResultSet resultSet, int i) throws SQLException {
Student student = new Student();
student.setName(resultSet.getString("name"));
student.setId(resultSet.getLong("id"));
return student;
}
}
@Test
public void test1() {
DriverManagerDataSource dataSource = new DriverManagerDataSource();
dataSource.setDriverClassName("com.mysql.jdbc.Driver");
dataSource.setUrl("jdbc:mysql://localhost:3306/xz_1");
dataSource.setUsername("root");
dataSource.setPassword("123456");
JdbcTemplate template = new JdbcTemplate(dataSource);
List<Student> list = template.query("select * from student", new MyRowMapper());
int count = (Integer) template.queryForObject("select count(1) from student", Integer.class);
Assert.assertTrue(list.size() > 0);
Assert.assertTrue(count > 0);
for (Student student : list) {
System.out.println(student.getId() + "/" + student.getName());
}
}
}
其他参考文档