javaEE衡量生活質(zhì)量課程設(shè)計報告

1、.PAGE ：.； 設(shè)計時間年月日月日 設(shè)計目的JavaEE課程設(shè)計是對所學(xué)JavaEE與中間件課程的小結(jié)，是提高學(xué)生對所學(xué)知識綜合運用才干的一種方式，是集中實際性環(huán)節(jié)之一。要求同窗們對課程中所學(xué)習(xí)到的知識綜合運用，開發(fā)有一定規(guī)模的Java Web程序。設(shè)計義務(wù)設(shè)計生活質(zhì)量衡量系統(tǒng)衡量規(guī)范闡明：消費有兩種支出：吃飯支出和 其它支出，假設(shè)在一段時間內(nèi)，吃飯支出占總支出的比例超越%，生活質(zhì)量為貧困；假設(shè)在-%之間，為溫飽；假設(shè)低于%，生活質(zhì)量為小康。功能描畫：用戶以合法身份登錄系統(tǒng)后，才干進展一切操作；用戶可以添加、查看和刪除支出情況支出類型有兩種：吃飯支出和其它支出、額度人民幣、日期。添加支出情

2、況查看支出情況刪除支出情況統(tǒng)計在某個時間段內(nèi)，生活質(zhì)量屬于哪個層次 設(shè)計內(nèi)容 . 設(shè)計標(biāo)題生活質(zhì)量衡量系統(tǒng)。 .系統(tǒng)功能要求用只需擁有合法身份才干登錄系統(tǒng)，用以合法身份登錄后才干進展添加、查看和刪除支出情況支出類型有兩種：吃飯支出和其它支出、額度人民幣、日期。. 數(shù)據(jù)庫存儲要求 數(shù)據(jù)的存儲要求：吃飯支出其他支出，日期。.數(shù)據(jù)庫的設(shè)計圖 數(shù)據(jù)庫存儲表圖數(shù)據(jù)庫存儲數(shù)據(jù).系統(tǒng)構(gòu)造關(guān)系 登陸窗口密碼noyes操作界面計算刪除插入查詢 圖jsp頁面構(gòu)造Jsp頁面?zhèn)魉蛥?shù)調(diào)用servlet類參數(shù)計算方法servlet刪除方法servlet查詢方法servlet插入方法servlet刪除方法dao類查詢方法

3、dao類插入方法dao類計算方法dao類圖Java類功能調(diào)用. Jsp 頁面設(shè)計.登錄界面圖登錄界面代碼如下： 歡迎登陸生活質(zhì)量衡量系統(tǒng)！ 用戶稱號： 用戶密碼： .登錄勝利界面 圖登錄勝利查詢界面 登陸勝利！點擊獲得詳細(xì)的信息 .查詢結(jié)果界面圖查詢結(jié)果界面.Java方法設(shè)計.Servlet類密碼驗證的Servlet類的代碼如下：public class LoginServlet extends HttpServlet public void doGet(HttpServletRequest request, HttpServletResponse response)throws Servle

4、tException, IOException doPost(request,response);public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException String username = (String)request.getParameter(username);String userpsw = (String)request.getParameter(userpsw);System.out.println(usernam

5、e);String forward = ;if(username.equals() & userpsw.equals()forward = /success.jsp;elseforward = /error.jsp; 顯示一切信息的servlet類代碼設(shè)計如下：public class ListAllThingServlet extends HttpServlet public void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException doPo

6、st(request,response);public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException ThingDAO thingDAO=new ThingDAO();List list=thingDAO.getAllThing();request.setAttribute(allthing, list);request.getRequestDispatcher(/showAllThing.jsp).forward(request

7、, response);控制增刪改操作的servlet類代碼設(shè)計如下：插入支出情況代碼：public class SaveOutServlet extends HttpServlet public void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException doPost(request,response);public void doPost(HttpServletRequest request, HttpServletResponse resp

8、onse)throws ServletException, IOException double x=.; double y=.; x=Double.parseDouble(request.getParameter(eating); y=Double.parseDouble(request.getParameter(others); String times=(String)request.getParameter(times); ThingDAO thingDAO=new ThingDAO(); try thingDAO.saveUser(x,y,times); catch(Exceptio

9、n e) e.printStackTrace(); List list=thingDAO.getAllThing();request.setAttribute(allthing, list);request.getRequestDispatcher(/showAllThing.jsp).forward(request, response);刪除支出情況代碼：public class DeleteOutServlet extends HttpServlet public void doGet(HttpServletRequest request, HttpServletResponse resp

10、onse)throws ServletException, IOException doPost(request,response);public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException double x=.; x=Double.parseDouble(request.getParameter(eating);ThingDAO thingDAO=new ThingDAO();try thingDAO.deleteUser(x

11、);catch(Exception e)e.printStackTrace();List list=thingDAO.getAllThing();request.setAttribute(allthing, list);request.getRequestDispatcher(/showAllThing.jsp).forward(request, response);衡量生活質(zhì)量代碼：public class Caculate extends HttpServlet public void doGet(HttpServletRequest request, HttpServletRespons

12、e response)throws ServletException, IOException doPost(request,response);public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException String time=request.getParameter(time); String time=request.getParameter(time); ThingDAO thingDAO=new ThingDAO();

13、try String resulte=thingDAO.caculate(time, time); request.setAttribute(resulte, resulte);request.getRequestDispatcher(/caculateresulte.jsp).forward(request,response); catch(Exception e) e.printStackTrace(); .Dao類顯示一切支出情況的Dao類代碼設(shè)計如下：public class ThingDAO public List getAllThing()Connection con=DBConn

14、ection.getConnection();List list=new ArrayList();tryStatement ps=con.createStatement();/Statement(select * from moneying);ResultSet rs=ps.executeQuery(select * from moneying);while(rs.next()Thing thing=new Thing();thing.setEating(rs.getDouble();thing.setOthers(rs.getDouble();thing.setTimes(rs.getStr

15、ing();list.add(thing);return list;catch(SQLException e)e.printStackTrace();finallyif(con!=null)trycon.close();catch(SQLException e)e.printStackTrace();return list;添加，刪除和統(tǒng)計生活質(zhì)量的Dao類代碼設(shè)計如下：public boolean saveUser(double m, double n,String q) throws ExceptionConnection con = DBConnection.getConnection(

16、);String listSQL=insert into moneying values (?,?,?);PreparedStatement pstmt=con.prepareStatement(listSQL);trypstmt.setDouble(, m);pstmt.setDouble(, n);pstmt.setString(, q);pstmt.executeUpdate();conmit();return true;catch (SQLException e)con.rollback();e.printStackTrace();finallycon.close();return f

17、alse;public boolean deleteUser(double x)throws ExceptionConnection con=DBConnection.getConnection(); PreparedStatement pstmt=con.prepareStatement(delete from moneying where eating=?); try pstmt.setDouble(, x); pstmt.executeUpdate(); conmit(); return true; catch(SQLException e) con.rollback(); e.prin

18、tStackTrace(); finally con.close(); return false; public String caculate(String x,String x)/計算式溫飽還是小康生活程度Connection con=DBConnection.getConnection();int i=;int j=;String SQL=select id from moneying where times=x;String SQL=select id from moneying where times=x;tryPreparedStatement psmt=con.prepareSt

19、atement(SQL);PreparedStatement psmt=con.prepareStatement(SQL);ResultSet rs=psmt.executeQuery();ResultSet rs=psmt.executeQuery();if(rs.next()i=rs.getInt();if(rs.next()j=rs.getInt();catch(SQLException e)e.printStackTrace();double eatingtotal=.;double total=.;int k=;for(k=i;k=j;k+)String SQL=seclect ea

20、ting,others from moneying where id=k;tryPreparedStatement psmt=con.prepareStatement(SQL);ResultSet rs=psmt.executeQuery();eatingtotal=eatingtotal+rs.getDouble();total=total+rs.getDouble()+rs.getDouble();catch(SQLException e)e.printStackTrace();if(eatingtotal/total.)return pinkun;elsereturnwenbao;.數(shù)據(jù)

21、庫銜接類數(shù)據(jù)庫銜接代碼如下：public class DBConnection public static Connection getConnection()final String driverName=com.microsoft.jdbc.sqlserver.SQLServerDriver;final String url=jdbc:microsoft:sqlserverlocalhost:;databasename=mydb;tryClass.forName(driverName);catch(ClassNotFoundException e)e.printStackTrace();tryConnection con=Driver