纯jsp模式

Xdi

于 2019-04-19 23:54:26 发布

阅读量321

点赞数

分类专栏： servlet与jsp

本文链接：https://blog.csdn.net/qq_41575219/article/details/89410044

版权

servlet与jsp 专栏收录该内容

9 篇文章 1 订阅

订阅专栏

1 eclipse（MySQL+JSP）

2数据添加

2.1：

<%@ page language="java" pageEncoding="utf-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>增加数据form</title>
</head>
<body>
<form action="insertsql.jsp" method="post">
学号：<input type="text" name="id" ><br>
姓名：<input type="text" name="name" ><br>
年龄：<input type="text" name="age"><br>
<input type="submit" value="提交">
</form>

</body>
</html>

:2.2

<%@page import="java.sql.* "%>
<%@ page language="java" pageEncoding="utf-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>数据新增</title>
</head>
<body>
<%! String driver="com.mysql.jdbc.Driver";
    String url="jdbc:mysql://localhost:3306/test";
    String user="root";
    String password="123456";
    String sql;
    %>
<%
try {
   Class.forName(driver);
   request.setCharacterEncoding("utf-8");
   String id=request.getParameter("id");
   String name=request.getParameter("name");
   String age=request.getParameter("age");
   sql="insert into students(id,name,age) values('"+id+"','"+name+"','"+age+"') ";
   System.out.println(id);
   Connection coon=DriverManager.getConnection(url, user, password);
    PreparedStatement stat=coon.prepareStatement(sql);
    System.out.println("到此4");
    int rs=stat.executeUpdate();
    if(rs!=0)
    {
       out.println("新增成功");
    }
    %>
    <jsp:forward page="query.jsp"></jsp:forward>

   <% }catch(Exception e)
{
          out.println(e);
}
      %>
</table>
</body>
</html>

3. 显示数据

<%@page import="javax.websocket.Session"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.Connection"%>
<%@page import="java.sql.DriverManager"%>
<%@ page language="java" pageEncoding="utf-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>数据显示</title>
</head>
<body>
<%! String driver="com.mysql.jdbc.Driver";
    String url="jdbc:mysql://localhost:3306/test";
    String user="root";
    String password="123456";
    String sql="select * from students";
    %>
<%
try {
   request.setCharacterEncoding("utf-8");
   Class.forName(driver);
   Connection coon=DriverManager.getConnection(url, user, password);
    Statement stat=coon.createStatement();
    System.out.println("到此1");

    ResultSet rs=stat.executeQuery(sql);
    %>
    <table border="1" width="100%">
    <tr>
    <th>学号</th>
    <th>姓名</th>
    <th>年龄</th>
    <th colspan="3" align="center">数据操作</th>
    </tr>
<% while(rs.next()){
     %>
   <tr>
   <td><%=rs.getInt("id")%></td>

   <td><%=rs.getString("name") %></td>
   <td><%=rs.getInt("age") %></td>
   <td><a href="delete.jsp?id=<%=rs.getInt("id")%>">删除数据</a></td>
   <td><a href="updata.jsp?id=<%=rs.getInt("id")%>&name=<%=rs.getString("name")%>&age=<%=rs.getInt("age")%>">数据更新</a></td>
   <td><a href="insertform.jsp">新增数据</a></td>
   </tr>
<%
      } }catch(Exception e)
{
          out.println(e);
   }
%>
</table>
</body>
</html>

4.删除操作

   Connection coon=DriverManager.getConnection(url, user, password);
    PreparedStatement stat=coon.prepareStatement(sql);
    System.out.println("到此1");
    int rs=stat.executeUpdate();
    if(rs!=0)
    {
       out.println("删除成功");
    }
    %>
    <jsp:forward page="query.jsp"></jsp:forward>

   <% }catch(Exception e)
{
          out.println(e);
}
      %>
</table>
</body>
</html>

5.更新操作

5.1：

<%@ page language="java" contentType="text/html; charset=utf-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>更新数据form</title>
</head>
<body>
<form action="updatasql.jsp" method="post">
学号：<input type="text" name="id" value="<%=request.getParameter("id")%>"><br>
姓名：<input type="text" name="name" value="<%=request.getParameter("name")%>"><br>
年龄：<input type="text" name="age" value="<%=request.getParameter("age")%>"><br>
<input type="submit" value="提交">
</form>
</body>
</html>

5.2：

<%@page import="java.sql.* "%>
<%@ page language="java" pageEncoding="utf-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>数据更新</title>
</head>
<body>
<%! String driver="com.mysql.jdbc.Driver";
    String url="jdbc:mysql://localhost:3306/test";
    String user="root";
    String password="123456";
    String sql;
    %>
<%
try {
   Class.forName(driver);
   request.setCharacterEncoding("utf-8");
   String id=request.getParameter("id");
   String name=request.getParameter("name");
   String age=request.getParameter("age");
   sql="update students set name='"+name+"',age='"+age+"'where id='"+id+"' ";
   System.out.println(id);
   Connection coon=DriverManager.getConnection(url, user, password);
    PreparedStatement stat=coon.prepareStatement(sql);
    System.out.println("到此3");
    int rs=stat.executeUpdate();
    if(rs!=0)
    {
       out.println("更新成功");
    }
    %>
    <jsp:forward page="query.jsp"></jsp:forward>

   <% }catch(Exception e)
{
          out.println(e);
}
      %>
</table>
</body>
</html>

6总结：

不足之处：没有注意主键的无关性，纯JSP模式早已被淘汰，只为初学者入门，欢迎讨论。

Xdi

关注

0
点赞
踩
1

收藏

觉得还不错? 一键收藏
0
评论
纯jsp模式

1 eclipse（MySQL+JSP）2数据添加2.1：<%@ page language="java" pageEncoding="utf-8"%><!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">...
复制链接

扫一扫