文档详情

JDBC实现增删改查.doc

发布：2017-05-26约5.79千字共7页下载文档

文本预览下载声明

public?class?NoteDAOImpl?implements?NoteDAO?{ ?? ????//?增加操作 ?? ????public?void?insert(Note?note)?throws?Exception?{ ?? ????????String?sql?=?INSERT?INTO?note(id,title,author,content)?VALUES(note_sequ.nextVal,?,?,?)?; ?? ????????PreparedStatement?pstmt?爊ull? 牋牋牋牋牋DataBaseConnection燿bc?爊ull? 牋牋牋牋牋dbc?爊ew燚ataBaseConnection()? 牋牋牋牋牋try爗牋牋牋牋牋牋牋pstmt?燿bc.getConnection().prepareStatement(sql)? 牋牋牋牋牋牋牋pstmt.setString(1,note.getTitle())? 牋牋牋牋牋牋牋pstmt.setString(2,note.getAuthor())? 牋牋牋牋牋?牋爌stmt.setString(3,note.getContent())? 牋牋牋牋牋牋牋pstmt.executeUpdate()? 牋牋牋牋牋牋牋pstmt.close()? 牋牋牋牋牋}燾atch?Exception爀)爗牋牋牋牋牋牋牋//燬ystem.out.println(e)? 牋牋牋牋牋????throw?new?Exception(操作中出现错误！！！)?; ?? ????????}?finally?{ ?? ????????????dbc.close()?; ?? ????????} ?? ????} ?? ????//?修改操作 ?? ????public?void?update(Note?note)?throws?Exception?{ ?? ????????String?sql?=?UPDATE?note?SET?title=?,author=?,content=?燱HERE爄d=?? 牋牋牋牋牋PreparedStatement爌stmt?爊ull? 牋牋牋牋牋DataBaseConnection燿bc?爊ull? 牋牋牋牋牋dbc?爊ew燚ataBaseConnection()? 牋牋牋牋牋try爗牋牋牋牋牋牋牋pstmt?燿bc.getConnection().prepareStatement(sql)? 牋牋牋牋牋牋牋pstmt.setString(1,note.getTitle())? 牋牋牋牋牋牋牋pstmt.setString(2,note.getAuthor())? 牋牋牋牋牋牋牋pstmt.setString(3,note.getContent())? 牋牋牋牋牋牋牋pstmt.setInt(4,note.getId())? 牋牋牋牋牋牋牋pstmt.executeUpdate()? 牋牋牋牋牋牋牋pstmt.close()?; ?? ????????}?catch?(Exception?e)?{ ?? ????????????throw?new?Exception(操作中出现错误！！！)?; ?? ????????}?finally?{ ?? ????????????dbc.close()?; ?? ????????} ?? ????} ?? ????//?删除操作 ?? ????public?void?delete(int?id)?throws?Exception?{ ?? ????????String爏ql??DELETE燜ROM爊ote燱HERE爄d=?? 牋牋牋牋牋PreparedStatement爌stmt?爊ull? 牋牋牋牋牋DataBaseConnection燿bc?爊ull? 牋牋牋牋牋dbc?爊ew燚ataBaseConnection()? 牋牋牋牋牋try爗牋牋牋牋牋牋牋pstmt?燿bc.getConnection().prepareStatement(

显示全部

相似文档