jsp和serverlet的区别

开始找工作面试的第一家公司,爱思创新 面试题:

1、jsp和serverlet的区别

 简单来说:

jsp:是包含java程序片的html文件
servlet:是包含html的java文件

 

其实说白了JSP和SERVLET到底什么区别呢,JSP就象宾馆前台的服务员,要长的不错,让顾客一看就觉得比较舒服,他主要就是负责显示这个宾馆的形象的.而SERVLET就象部门经理,要处理各种各样的业务和事情,而bean呢就象是高层领导了,他负责从部门经理处获得信息,报告给董事会,或者把董事会的建议和计划吩咐下去.他们分工合作,各干其职.

具体的看下下面吧.
    JSP和SERVLET到底在应用上有什么区别,很多人搞不清楚。我来胡扯几句吧。简单的说,SUN首先发展出SERVLET,其功能比较强劲,体系设计也很先进,只是,它输出HTML语句还是采用了老的CGI方式,是一句一句输出,所以,编写和修改HTML非常不方便。
    后来SUN推出了类似于ASP的镶嵌型的JSP,把JSP TAG镶嵌到HTML语句中,这样,就大大简化和方便了网页的设计和修改。新型的网络语言如ASP,PHP,JSP都是镶嵌型的SCRIPT语言。
    从网络三层结构的角度看,一个网络项目最少分三层:data layer,business layer, presentation layer。当然也可以更复杂。SERVLET用来写business layer是很强大的,但是对于写presentation layer就很不方便。JSP则主要是为了方便写presentati

  • 1
    点赞
  • 18
    收藏
    觉得还不错? 一键收藏
  • 4
    评论
首先,需要创建一个数据库和对应的表。假设我们创建了一个名为“student”的数据库,其中有一个名为“student_info”的表,包含id、name、age和gender四个字段。 接下来,需要创建一个Java Web项目,将mysql-connector-java包添加到项目中。 在项目中创建一个servlet,并在web.xml中进行配置。 在servlet中,使用JDBC连接数据库,并实现增删改查操作。下面是一个示例代码: ``` import java.io.IOException; import java.io.PrintWriter; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; public class StudentServlet extends HttpServlet { private static final long serialVersionUID = 1L; private Connection conn = null; private PreparedStatement pstmt = null; private ResultSet rs = null; // 连接数据库 private void getConnection() { String driver = "com.mysql.jdbc.Driver"; String url = "jdbc:mysql://localhost:3306/student"; String user = "root"; String password = "123456"; try { Class.forName(driver); conn = DriverManager.getConnection(url, user, password); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } } // 关闭资源 private void close() { try { if (rs != null) { rs.close(); } if (pstmt != null) { pstmt.close(); } if (conn != null) { conn.close(); } } catch (SQLException e) { e.printStackTrace(); } } // 查询 private void query(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html;charset=UTF-8"); PrintWriter out = response.getWriter(); getConnection(); String sql = "SELECT * FROM student_info"; try { pstmt = conn.prepareStatement(sql); rs = pstmt.executeQuery(); while (rs.next()) { out.println(rs.getInt("id") + " " + rs.getString("name") + " " + rs.getInt("age") + " " + rs.getString("gender")); } } catch (SQLException e) { e.printStackTrace(); } finally { close(); } } // 插入 private void insert(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html;charset=UTF-8"); PrintWriter out = response.getWriter(); getConnection(); int id = Integer.parseInt(request.getParameter("id")); String name = request.getParameter("name"); int age = Integer.parseInt(request.getParameter("age")); String gender = request.getParameter("gender"); String sql = "INSERT INTO student_info(id, name, age, gender) VALUES(?, ?, ?, ?)"; try { pstmt = conn.prepareStatement(sql); pstmt.setInt(1, id); pstmt.setString(2, name); pstmt.setInt(3, age); pstmt.setString(4, gender); int count = pstmt.executeUpdate(); if (count > 0) { out.println("插入成功!"); } else { out.println("插入失败!"); } } catch (SQLException e) { e.printStackTrace(); } finally { close(); } } // 更新 private void update(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html;charset=UTF-8"); PrintWriter out = response.getWriter(); getConnection(); int id = Integer.parseInt(request.getParameter("id")); String name = request.getParameter("name"); int age = Integer.parseInt(request.getParameter("age")); String gender = request.getParameter("gender"); String sql = "UPDATE student_info SET name=?, age=?, gender=? WHERE id=?"; try { pstmt = conn.prepareStatement(sql); pstmt.setString(1, name); pstmt.setInt(2, age); pstmt.setString(3, gender); pstmt.setInt(4, id); int count = pstmt.executeUpdate(); if (count > 0) { out.println("更新成功!"); } else { out.println("更新失败!"); } } catch (SQLException e) { e.printStackTrace(); } finally { close(); } } // 删除 private void delete(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html;charset=UTF-8"); PrintWriter out = response.getWriter(); getConnection(); int id = Integer.parseInt(request.getParameter("id")); String sql = "DELETE FROM student_info WHERE id=?"; try { pstmt = conn.prepareStatement(sql); pstmt.setInt(1, id); int count = pstmt.executeUpdate(); if (count > 0) { out.println("删除成功!"); } else { out.println("删除失败!"); } } catch (SQLException e) { e.printStackTrace(); } finally { close(); } } protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doPost(request, response); } protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("UTF-8"); String op = request.getParameter("op"); if ("query".equals(op)) { query(request, response); } else if ("insert".equals(op)) { insert(request, response); } else if ("update".equals(op)) { update(request, response); } else if ("delete".equals(op)) { delete(request, response); } } } ``` 在jsp页面中,可以通过表单提交数据,并调用对应的servlet实现增删改查操作。例如: ``` <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>Insert title here</title> </head> <body> <form action="StudentServlet" method="post"> <input type="hidden" name="op" value="insert"> ID:<input type="text" name="id"><br> 姓名:<input type="text" name="name"><br> 年龄:<input type="text" name="age"><br> 性别:<input type="text" name="gender"><br> <input type="submit" value="插入"> </form> <form action="StudentServlet" method="post"> <input type="hidden" name="op" value="query"> <input type="submit" value="查询"> </form> <form action="StudentServlet" method="post"> <input type="hidden" name="op" value="update"> ID:<input type="text" name="id"><br> 姓名:<input type="text" name="name"><br> 年龄:<input type="text" name="age"><br> 性别:<input type="text" name="gender"><br> <input type="submit" value="更新"> </form> <form action="StudentServlet" method="post"> <input type="hidden" name="op" value="delete"> ID:<input type="text" name="id"><br> <input type="submit" value="删除"> </form> </body> </html> ``` 以上代码实现了一个简单的增删改查功能。需要注意的是,这只是一个示例,实际应用中需要根据具体情况进行修改。

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 4
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值