模块设计基础模块SqlSession:利用mybatis获取jdbc,其中有inter.select,update,select等方法Stringresource="mybatis-config.xml";InputStreaminputStream=Resources.getResourceAsStream(resource);SqlSessionFactorysqlSessionFactory=newSqlSessionFactoryBuilder().build(inputStream);SqlSessionsesson=sqlSessionFactory.openSession();Dao基础模块所有的dao都继承于BaseDao;代码/***保存利用mybatis的xml*model保存的对象*idmybatis的id名*/PublicvoidSave(BaseModelmodel,Stringid){sesson.inster(idmodel);}……Model基础模块所有的模型都继承于BaseModel;代码片段/***字段编号*/Privateintid;PublicvoidsetId(Stringid){This.id=id;}PublicStringgetId(){Returnid;}添加书籍代码片段Bookbook=newBook();book.setId(…..);……..Book.setTitle(….);BooksManageDaobookDao=newBooksManageDao();bookDao.save(“addBook”,book);删除书籍代码片段BookDaobookDao=newBookDao();Bookbook=(Book)bookDao.getModel(id);BooksManageDaobookDao=newBooksManageDao();bookDao.delete(“deleteBook”,book);更新书籍代码片段BookDaobookDao=newBookDao();Bookbook=(Book)bookDao.getModel(id);book.setId(…..);……..Book.setTitle(….);BooksManageDaobookDao=newBooksManageDao();bookDao.update(“updateBook”,book);查询书籍代码片段//数据库的自定义一页显示10条IntpageNo=“当前页数”BooksManageDaobookDao=newBooksManageDao();bookDao.select(“selectteBook”,pageNo);添加用户代码片段Studentstudent=newStudent();student.setId(…..);……..student.setTitle(….);StudentDaostudentDao=newStudentDao();studentDao.save(“addStudent”,book);删除用户代码片段Intid=“字段编号”StudentDaostudentDao=newStudentDao()Studentstudent=(Student)studentDao.getModel(id);student.setId(…..);StudentDaostudentDao=newStudentDao();studentDao.delete(“deleteStudent”,book);更新用户代码片段Intid=“字段编号”StudentDaostudentDao=newStudentDao()Studentstudent=(Student)studentDao.getModel(id);student.setId(…..);……..student.setTitle(….);StudentDaostudentDao=newStudentDao();studentDao.update(“updeteStudent”,book);查询用户代码片段//数据库的自定义一页显示10条IntpageNo=“当前页数”StudentDaostudentDao=newStudentDao();studentDao.select(“selectStudent”,pageNo);借阅书籍代码片段Borrowborrow=newBorrow();Studentstudent=newStudent();student.setId(…..);……..student.setTitle(….);Bookbook=newBook();book.setId(…..);……..book.setTitle(….);borrow.save(“borrow”,book,student);归还书籍代码片段ReturnNookreturnBook=newReturnNook();Studentstudent=newStudent();student.setId(…..);……..student.setTitle(….);Bookbook=newBook();book.setId(…..);……..book.setTitle(….);returnBook.save(“returnBook”,book,student);
