每日打卡（一）

package com;

import java.sql.Connection;
import java.sql.PreparedStatement;

public class Interface {
    public boolean add( model){
        String riqi =model.riqi();
        String keyword =model.keyword();
        String zongjie =model.zongjie();
        String inday =model.inday();
        String maxday =model.maxday();

        Util db=new Util();
        try {
            String sql="INSERT INTO day(riqi,keyword,zongjie,inday,maxday) VALUES (?,?,?,?,?)";
            Connection conn=db.getCon();
            PreparedStatement ps=conn.prepareStatement(sql);
            ps.setString(1, riqi);
            ps.setString(2, keyword);
            ps.setString(3, zongjie);
            ps.setString(4, inday);
            ps.setString(5, maxday);
            ps.executeUpdate();
        } catch (Exception e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        return true;

    }
}

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48

package com;   public class model {     private String riqi;     private String keyword;     private String zongjie;     private String inday;     private static String maxday;     public String getRiqi() {         return riqi;     }       public void setRiqi(String riqi) {         this.riqi = riqi;     }       public String getKeyword() {         return keyword;     }       public void setKeyword(String keyword) {         this.keyword = keyword;     }       public String getZongjie() {         return zongjie;     }       public void setZongjie(String zongjie) {         this.zongjie = zongjie;     }       public String getInday() {         return inday;     }       public void setInday(String inday) {         this.inday = inday;     }       public String getMaxday() {         return maxday;     }       public void setMaxday(String maxday) {         this.maxday = maxday;     } }

　　

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27

package com;   import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; public class Util {     private String url="jdbc:mysql://localhost:3306/db-jsp";     private String user="root";     private String password="123456";     private String driver="com.mysql.jdbc.Driver";       public Connection getCon() throws Exception{         Class.forName(driver);         Connection con=DriverManager.getConnection(url, user, password);         return con;       }         public static void getClose(Connection con) throws SQLException{         if(con!=null){             con.close();         }       }   }

　　

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67

package com;   import java.io.IOException; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse;   public class web extends HttpServlet {     Util db=new Util();       private static final long serialVersionUID = 1L;       public PublishServlet() {         super();     }         public void destroy() {         super.destroy(); // Just puts "destroy" string in log         // Put your code here     }         public void doGet(HttpServletRequest request, HttpServletResponse response)             throws ServletException, IOException {         }       public void doPost(HttpServletRequest request, HttpServletResponse response)             throws ServletException, IOException {         request.setCharacterEncoding("UTF-8");         response.setContentType("text/html;charset=UTF-8");           String riqi=request.getParameter("riqi");         String keyword=request.getParameter("keyword");         String zongjie=request.getParameter("zongjie");         String inday=request.getParameter("inday");         String maxday=request.getParameter("maxday");           Interface=new Interface();         Interface.setriqi(riqi);         literature.setEnglishName(EnglishName);         literature.setType(Type);         literature.setAuthor(Author);         literature.setSource(Source);         literature.setChineseAbstract(ChineseAbstract);         literature.setEnglishAbstract(EnglishAbstract);         literature.setChineseKeyword(ChineseKeyword);         literature.setEnglishKeyword(EnglishKeyword);         literature.setReforName(ReforName);         literature.setIncentive(Incentive);         literature.setContent(Content);           LiteratureInterface literatureInter=new LiteratureInterface();         literatureInter.addLiterature(literature);           request.getRequestDispatcher("main.jsp").forward(request, response);     }         public void init() throws ServletException {         // Put your code here     }   }

　　

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45

<%@ page contentType="text/html;charset=UTF-8" language="java" %> <html>   <head>     <title>每日总结打卡</title>   </head>   <body>   <form action="PublishServlet" method="post">     <table>       <tr>         <td>日期：</td>         <td><input type="text" name="riqi" value="${param.riqi}"></td>       </tr>       <tr>         <td>每日关键字：</td>         <td><input type="text" name="keyword" value="${param.keyword}"></td>       </tr>       <tr>         <td>每日总结：</td>         <td><input type="text" name="zongjie" value="${param.zongjie}"></td>       </tr>       <tr>         <td>坚持天数：</td>         <td><input type="text" name="inday" value="${param.inday}"></td>       </tr>       <tr>         <td>连续最长天数：</td>         <td><input type="text" name="maxday" value="${param.maxday}"></td>       </tr>       </tr>       <tr>         <td>           <input type="submit" value="提交">         </td>       </tr>     </table>   </form>   </body> </html>