servlet小练习

偏执的太偏执、 2021-12-03 20:19 333阅读 0赞

servlet小练习

package cn.servlet;
    
    import java.io.IOException;
    import java.io.PrintWriter;
    import java.sql.Connection;
    import java.sql.PreparedStatement;
    import java.sql.SQLException;
    
    import javax.servlet.ServletException;
    import javax.servlet.http.HttpServlet;
    import javax.servlet.http.HttpServletRequest;
    import javax.servlet.http.HttpServletResponse;
    
    import cn.servlet.util.DBUtil;
    
    public class CollectBlogPages extends HttpServlet {
    
    	
    	public void doGet(HttpServletRequest request, HttpServletResponse response)
    			throws ServletException, IOException {
    		this.doPost(request, response);
    		
    		
    	}
    
    
    	public void doPost(HttpServletRequest request, HttpServletResponse response)
    			throws ServletException, IOException {
    		System.out.println("成功了");
    		//获取数据
    		String studentName = request.getParameter("studentName");
    		String blogType = request.getParameter("blogType");
    		String blogAddress = request.getParameter("blogAddress");
    		
    		//读取数据到数据库中
    		Connection conn = DBUtil.getConnection();
    		String sql = "insert into studentBlogPages(studentName,blogType,blogAddress) values(?,?,?)";
    		PreparedStatement ps=null;
    		int flag = 0;
    		try {
    			ps = conn.prepareStatement(sql);
    			ps.setString(1, studentName);
    			ps.setString(2, blogType);
    			ps.setString(3, blogAddress);
    			flag = ps.executeUpdate();
    		} catch (SQLException e) {
    			// TODO Auto-generated catch block
    			e.printStackTrace();
    		}finally{
    			DBUtil.close(conn, ps);
    		}
    		
    		if(flag==1){
    			request.getRequestDispatcher("success.html").forward(request, response);
    		}else{
    			request.getRequestDispatcher("collectblogpages.html").forward(request, response);
    		}
    		
    		
    	}
    
    }

html页面

<!DOCTYPE html>
    <html>
      <head>
        <title>collectblogpages.html</title>
    	    
        <meta  charset="UTF-8">
        
      </head>
      
      <body>
      <form action="collectblogpages">
      姓名：<input type="text" name="studentName"/><br/>
      博客类型：<select name="blogType">
     			<option value="知乎">知乎</option>
     			<option value="博客园">博客园</option>
     			<option value="简书">简书</option>
     			<option value="开源中国">开源中国</option>
              </select><br/>
      博客地址：<input type="text" name="blogAddress"><br/>
      		<button type="submit" value="提交博客地址">提交博客地址</button>
      
      </form>
      </body>
    </html>

转载于:https://www.cnblogs.com/heviny/p/10849826.html