模块设计
基础模块
SqlSession:
利用mybatis获取jdbc,其中有inter.select,update,select等方法
String resource = "mybatis-config.xml";
InputStream inputStream = Resources.getResourceAsStream(resource);
SqlSessionFactory sqlSessionFactory = new
SqlSessionFactoryBuilder().build(inputStream);
SqlSession sesson = sqlSessionFactory.openSession();
Dao基础模块
所有的dao都继承于BaseDao; 代码
/**
*保存利用mybatis的xml
* model 保存的对象
*id mybatis的id名
*/
Public void Save(BaseModel model,String id){
sesson.inster(id model);
}
……
Model基础模块
所有的模型都继承于BaseModel;
代码片段
/**
*字段编号
*/
Private int id;
Public void setId(String id){
This.id = id;
}
Public String getId(){
Return id;
}
添加书籍
代码片段
Book book = new Book();
book.setId(…..);
……..
Book.setTitle(….);
BooksManageDao bookDao = new BooksManageDao();
bookDao .save(“addBook”,book);
删除书籍
代码片段
BookDao bookDao = new BookDao();
Book book = (Book) bookDao .getModel(id);
BooksManageDao bookDao = new BooksManageDao();
bookDao .delete(“delete Book”,book);
更新书籍
代码片段
BookDao bookDao = new BookDao();
Book book = (Book) bookDao .getModel(id);
book.setId(…..);
……..
Book.setTitle(….);
BooksManageDao bookDao = new BooksManageDao(); bookDao .update(“update Book”,book); 查询书籍
代码片段
//数据库的自定义一页显示10条
Int pageNo = “当前页数”
BooksManageDao bookDao = new BooksManageDao();
bookDao .select(“selectte Book”, pageNo);
添加用户
代码片段
Student student = new Student ();
student.setId(…..);
……..
student.setTitle(….);
StudentDao studentDao = new StudentDao();
studentDao .save(“add Student”,book);
删除用户
代码片段
Int id = “字段编号”
StudentDao studentDao = new StudentDao()
Student student = (Student) studentDao.getModel(id);
student.setId(…..);
StudentDao studentDao = new StudentDao(); studentDao .delete(“deleteStudent”,book); 更新用户
代码片段
Int id = “字段编号”
StudentDao studentDao = new StudentDao()
Student student = (Student) studentDao.getModel(id);
student.setId(…..);
……..
student.setTitle(….);
StudentDao studentDao = new StudentDao(); studentDao .update(“updeteStudent”,book); 查询用户
代码片段
//数据库的自定义一页显示10条
Int pageNo = “当前页数”
StudentDao studentDao = new StudentDao();
studentDao .select(“selectStudent”, pageNo);
借阅书籍
代码片段
Borrow borrow = new Borrow();
Student student = new Student ();
student.setId(…..);
……..
student.setTitle(….);
Book book = newBook();
book.setId(…..);
……..
book.setTitle(….);
borrow .save(“b orrow”,book,student);
归还书籍
代码片段
ReturnNook returnBook = new ReturnNook();
Student student = new Student ();
student.setId(…..);
……..
student.setTitle(….);
Book book = newBook();
book.setId(…..);
……..
book.setTitle(….);
returnBook .save(“returnBook”,book,student);。