新手入门
- API关键字:
QueryRunner
insert(String sql,ResultSetHandle,Object… args):添加操作
query(String sql,ResultSetHandle,Object… args):查询操作
update(String sql,Object… args)
ResultSetHandler:把ResultSet转对象
BeanHandle(Class type);
BeanListHandle(Class type);
- 编写StuDao步骤
1.创建实体类student
2.stuDao接口,并先定义方法
3.创建实现类studentDaoImpl
4.使用BDUtils中的QueryRunner类
5.QueryRunner在实例化的时候需要数据源
6.创建c3p0数据源(c3p0-config.xml)文件放在src
编写实体类
package cn.kgc.demo.day04demo.BDUtils;
import java.util.Date;
public class student {
private String s_id;
private String s_name;
private String s_sex;
private Date s_birthday;
private String s_class;
public String getS_id() {
return s_id;
}
public void setS_id(String s_id) {
this.s_id = s_id;
}
public String getS_name() {