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>