ibatis增删改查public List quereyAll();// 查询全部
public Students quereyById(int sid);// 查询单条
void saveStudents(Students students);// 添加
void delStudents(int id);// 删除
void updateStudents(Students students);// 更新
select*
from students
sel...
public List quereyAll();// 查询全部
public Students quereyById(int sid);// 查询单条
void saveStudents(Students students);// 添加
void delStudents(int id);// 删除
void updateStudents(Students students);// 更新
insert into students
(sid,sname,major,birth,score)
values(
#sid#,#sname#,#major#,#birth#,#score#)
update students set
sname=#sname#,
major=#major#,
birth=#birth#,
score=#score#
where sid=#sid#
delete students
where sid =#sid#
private static SqlMapClient sqlMapClient = null;
static {
try {
Reader reader = com.ibatis.common.resources.Resources
.getResourceAsReader("com/cstp/SqlMapConfig.xml");
sqlMapClient = com.ibatis.sqlmap.client.SqlMapClientBuilder
.buildSqlMapClient(reader);
reader.close();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public List quereyAll() {
// TODO Auto-generated method stub
List list = null;
try {
list = sqlMapClient.queryForList("queryAll");
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return list;
}
public Students quereyById(int sid) {
// TODO Auto-generated method stub
Students student = null;
try {
student = (Students) sqlMapClient.queryForObject("queryById", sid);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return student;
}
public void delStudents(int id) {
// TODO Auto-generated method stub
try {
sqlMapClient.delete("delStudents", id);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public void saveStudents(Students students) {
// TODO Auto-generated method stub
try {
sqlMapClient.insert("saveStudents", students);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public void updateStudents(Students students) {
// TODO Auto-generated method stub
try {
sqlMapClient.update("updateStudents", students);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
/**
* {【小破孩儿】版权所有}
*
* @param args
* @author: 张国良
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
StudentsDAO dao = new StudentsDAOImpl();
// 1.全部查询
// List list = dao.quereyAll();
// 2.单个查询
// System.out.println(dao.quereyById(3));
// 3.插入
// Students students = new Students();
// students.setSid(10);
// students.setSname("小破孩儿");
// students.setMajor("QQ");
// students.setBirth(Date.valueOf("1988-8-24"));// 转换成日期类型
// students.setScore(88);
//
// dao.saveStudents(students);
// 4.删除
// dao.delStudents(10);
// 5.修改
// Students students = new Students();
// students.setSid(10);
// students.setSname("小破孩儿");
// students.setMajor("QQ");
// students.setBirth(Date.valueOf("1990-4-17"));// 转换成日期类型
// students.setScore(88);
//
// dao.updateStudents(students);
}
}
文档已经阅读完毕,请返回上一页!