程序博客网 > 手机必备软件大全2016

mysql+tomcat+jsp增删改查（三）

来源：互联网 发布：手机必备软件大全2016 编辑：程序博客网 时间：2024/06/07 16:21

select_for_age.jsp

 

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>

<%@ page import="java.sql.*"%>

<%

String path = request.getContextPath();

String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";

%>

 

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>

  <head>

    <base href="<%=basePath%>">

    

    <title>按年龄查询</title>

    

<meta http-equiv="pragma" content="no-cache">

<meta http-equiv="cache-control" content="no-cache">

<meta http-equiv="expires" content="0">    

<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">

<meta http-equiv="description" content="This is my page">

<!--

<link rel="stylesheet" type="text/css" href="styles.css">

-->

 

  </head>

  

  <body background="pic/background.jpg">

    <%

    request.setCharacterEncoding("UTF-8");

    String age = request.getParameter("age");

    Connection conn = null;

    Statement stat = null;

    ResultSet rs = null;

    Class.forName("com.mysql.jdbc.Driver");

    String url = "jdbc:mysql://localhost:3306/jsp";

    String user = "root";

    String password = "root";

    conn = DriverManager.getConnection(url,user,password);

    stat = conn.createStatement();

    rs = stat.executeQuery("select * from student where age=" + age + "");

    %>

    <br>

        <h3>符合条件的学生信息</h3><hr>

    <br>

     <table width="450" border="100" cellSpacing=1 style="font-size:15pt;border:dashed 1pt">

    <tr>

    <td>学号</td>

    <td>姓名</td>

    <td>年龄</td>

    <td>性别</td>

    <td>专业</td>

    </tr>

    <%

    while(rs.next())

    {

    out.print("<tr>");

    out.print("<td>" + rs.getInt("id") + "</td>");

    out.print("<td>" + rs.getString("name") + "</td>");

    out.print("<td>" + rs.getInt("age") + "</td>");

    out.print("<td>" + rs.getString("gender") + "</td>");

    out.print("<td>" + rs.getString("major") + "</td>");

        %>

    <td><a href="delete.jsp?id=<%=rs.getInt("id") %>">删除</a></td>

     <td><a href="update.jsp?id=<%=rs.getInt("id") %>">修改</a></td>

    <%

    out.print("</tr>");

    }

  

  

    %>

      </table>

      <br>

      <br>

      <h4><a href=showInfo.jsp>返回查询页面</a></h4>

       <%

    if(rs != null)

    {

        rs.close();

        rs = null;

    }

        if(stat != null)

    {

        stat.close();

        stat = null;

    }

        if(conn != null)

    {

        conn.close();

        conn = null;

    }

    %>

  </body>

</html>

 

 

 

 

 

select_for_gender

 

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>

<%@ page import="java.sql.*"%>

<%

String path = request.getContextPath();

String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";

%>

 

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>

  <head>

    <base href="<%=basePath%>">

    

    <title>按性别查询</title>

    

<meta http-equiv="pragma" content="no-cache">

<meta http-equiv="cache-control" content="no-cache">

<meta http-equiv="expires" content="0">    

<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">

<meta http-equiv="description" content="This is my page">

<!--

<link rel="stylesheet" type="text/css" href="styles.css">

-->

 

  </head>

  

  <body background="pic/background.jpg">

     <%

    request.setCharacterEncoding("UTF-8");

    String gender = request.getParameter("gender");

    Connection conn = null;

    Statement stat = null;

    ResultSet rs = null;

    Class.forName("com.mysql.jdbc.Driver");

    String url = "jdbc:mysql://localhost:3306/jsp";

    String user = "root";

    String password = "root";

    conn = DriverManager.getConnection(url,user,password);

    stat = conn.createStatement();

    rs = stat.executeQuery("select * from student where gender='" + gender + "'");

    %>

    <br>

        <h3>符合条件的学生信息</h3><hr>

    <br>

     <table width="450" border="100" cellSpacing=1 style="font-size:15pt;border:dashed 1pt">

    <tr>

    <td>学号</td>

    <td>姓名</td>

    <td>年龄</td>

    <td>性别</td>

    <td>专业</td>

    </tr>

    <%

    while(rs.next())

    {

    out.print("<tr>");

    out.print("<td>" + rs.getInt("id") + "</td>");

    out.print("<td>" + rs.getString("name") + "</td>");

    out.print("<td>" + rs.getInt("age") + "</td>");

    out.print("<td>" + rs.getString("gender") + "</td>");

    out.print("<td>" + rs.getString("major") + "</td>");

        %>

    <td><a href="delete.jsp?id=<%=rs.getInt("id") %>">删除</a></td>

     <td><a href="update.jsp?id=<%=rs.getInt("id") %>">修改</a></td>

    <%

    out.print("</tr>");

    }

    %>

      </table>

      <br>

      <br>

      <h4><a href=showInfo.jsp>返回查询页面</a></h4>

       <%

    if(rs != null)

    {

        rs.close();

        rs = null;

    }

        if(stat != null)

    {

        stat.close();

        stat = null;

    }

        if(conn != null)

    {

        conn.close();

        conn = null;

    }

    %>

  </body>

</html>

 

 

select_for_id.jsp

 

 

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>

<%@ page import="java.sql.*"%>

<%

String path = request.getContextPath();

String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";

%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>

  <head>

    <base href="<%=basePath%>">

    

    <title>按学号条件查询</title>

    

<meta http-equiv="pragma" content="no-cache">

<meta http-equiv="cache-control" content="no-cache">

<meta http-equiv="expires" content="0">    

<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">

<meta http-equiv="description" content="This is my page">

<!--

<link rel="stylesheet" type="text/css" href="styles.css">

-->

  </head>

  

  <body background="pic/background.jpg">

    <%

    request.setCharacterEncoding("UTF-8");

    String id = request.getParameter("id");

    Connection conn = null;

    Statement stat = null;

    ResultSet rs = null;

    Class.forName("com.mysql.jdbc.Driver");

    String url = "jdbc:mysql://localhost:3306/jsp";

    String user = "root";

    String password = "root";

    conn = DriverManager.getConnection(url,user,password);

    stat = conn.createStatement();

    rs = stat.executeQuery("select * from student where id=" + id + "");

    %>

    <br>

        <h3>符合条件的学生信息</h3><hr>

    <br>

     <table width="450" border="100" cellSpacing=1 style="font-size:15pt;border:dashed 1pt">

    <tr>

    <td>学号</td>

    <td>姓名</td>

    <td>年龄</td>

    <td>性别</td>

    <td>专业</td>

    </tr>

    <%

    if(rs.next())

    {

    out.print("<tr>");

    out.print("<td>" + rs.getInt("id") + "</td>");

    out.print("<td>" + rs.getString("name") + "</td>");

    out.print("<td>" + rs.getInt("age") + "</td>");

    out.print("<td>" + rs.getString("gender") + "</td>");

    out.print("<td>" + rs.getString("major") + "</td>");

        %>

    <td><a href="delete.jsp?id=<%=rs.getInt("id") %>">删除</a></td>

     <td><a href="update.jsp?id=<%=rs.getInt("id") %>">修改</a></td>

    <%

    out.print("</tr>");

    }

    else{

    out.print("<h4>不存在此条件的信息！</h4>");

    }

  

    %>

      </table>

      <br>

      <br>

       <h4><a href=showInfo.jsp>返回查询页面</a></h4>

      <%

    if(rs != null)

    {

        rs.close();

        rs = null;

    }

        if(stat != null)

    {

        stat.close();

        stat = null;

    }

        if(conn != null)

    {

        conn.close();

        conn = null;

    }

    %>

    

  </body>

</html>

 

 

select_for_major.jsp

 

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>

<%@ page import="java.sql.*"%>

<%

String path = request.getContextPath();

String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";

%>

 

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>

  <head>

    <base href="<%=basePath%>">

    

    <title>按专业查询</title>

    

<meta http-equiv="pragma" content="no-cache">

<meta http-equiv="cache-control" content="no-cache">

<meta http-equiv="expires" content="0">    

<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">

<meta http-equiv="description" content="This is my page">

<!--

<link rel="stylesheet" type="text/css" href="styles.css">

-->

 

  </head>

  

  <body background="pic/background.jpg">

     <%

    request.setCharacterEncoding("UTF-8");

   // String id=request.getParameter("id");

  // String name=request.getParameter("name");

   // String age=request.getParameter("age");

   // String gender=request.getParameter("gender");

    String major=request.getParameter("major");

    //major=;

    

    

    Connection conn = null;

    Statement stat = null;

    ResultSet rs = null;

    Class.forName("com.mysql.jdbc.Driver");

    String url = "jdbc:mysql://localhost:3306/jsp";

    String user = "root";

    String password = "root";  

    conn = DriverManager.getConnection(url,user,password);

    stat = conn.createStatement();

    rs = stat.executeQuery("select * from student where major='" + major + "'");

    %>

    <br>

        <h3>符合条件的学生信息</h3><hr>

    <br>

     <table width="450" border="100" cellSpacing=1 style="font-size:15pt;border:dashed 1pt">

    <tr>

    <td>学号</td>

    <td>姓名</td>

    <td>年龄</td>

    <td>性别</td>

    <td>专业</td>

    </tr>

    <%

    while(rs.next())

    {

    out.print("<tr>");

    out.print("<td>" + rs.getInt("id") + "</td>");

    out.print("<td>" + rs.getString("name") + "</td>");

    out.print("<td>" + rs.getInt("age") + "</td>");

    out.print("<td>" + rs.getString("gender") + "</td>");

    out.print("<td>" + rs.getString("major") + "</td>");

        %>

    <td> <a href="delete.jsp?id=<%=rs.getInt("id") %>">删除</a></td>

     <td><a href="update.jsp?id=<%=rs.getInt("id") %>">修改</a></td>

    <%

    out.print("</tr>");

    }

    

    %>

      </table>

      <br>

      <br>

     <h4><a href=showInfo.jsp>返回查询页面</a></h4>

      <%

    if(rs != null)

    {

        rs.close();

        rs = null;

    }

        if(stat != null)

    {

        stat.close();

        stat = null;

    }

        if(conn != null)

    {

        conn.close();

        conn = null;

    }

    %>

  </body>

</html>

 

 

select_for_name.jsp

 

 

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>

<%@ page import="java.sql.*"%>

<%

String path = request.getContextPath();

String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";

%>

 

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>

  <head>

    <base href="<%=basePath%>">

    

    <title>按姓名查询</title>

    

<meta http-equiv="pragma" content="no-cache">

<meta http-equiv="cache-control" content="no-cache">

<meta http-equiv="expires" content="0">    

<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">

<meta http-equiv="description" content="This is my page">

<!--

<link rel="stylesheet" type="text/css" href="styles.css">

-->

  </head>

  

  <body background="pic/background.jpg">

    <%

    request.setCharacterEncoding("UTF-8");

    String name = request.getParameter("name");

    Connection conn = null;

    Statement stat = null;

    ResultSet rs = null;

    Class.forName("com.mysql.jdbc.Driver");

    String url="jdbc:mysql://localhost:3306/jsp";

    String user = "root";

    String password = "root";

    conn = DriverManager.getConnection(url,user,password);

    stat = conn.createStatement();

    rs = stat.executeQuery("select * from student where name='" + name + "'");

    %>

    <br>

        <h3>符合条件的学生信息</h3><hr>

    <br>

     <table width="450" border="100" cellSpacing=1 style="font-size:15pt;border:dashed 1pt">

    <tr>

    <td>学号</td>

    <td>姓名</td>

    <td>年龄</td>

    <td>性别</td>

    <td>专业</td>

    </tr>

    <%

    while(rs.next())

    {

    out.print("<tr>");

    out.print("<td>" + rs.getInt("id") + "</td>");

    out.print("<td>" + rs.getString("name") + "</td>");

    out.print("<td>" + rs.getInt("age") + "</td>");

    out.print("<td>" + rs.getString("gender") + "</td>");

    out.print("<td>" + rs.getString("major") + "</td>");

        %>

    <td><a href="delete.jsp?id=<%=rs.getInt("id") %>">删除</a></td>

     <td><a href="update.jsp?id=<%=rs.getInt("id") %>">修改</a></td>

    <%

    out.print("</tr>");

    }

   

    %>

      </table>

      <br>

      <br>

      <h4><a href=showInfo.jsp>返回查询页面</a></h4>

    <%

    if(rs != null)

    {

        rs.close();

        rs = null;

    }

        if(stat != null)

    {

        stat.close();

        stat = null;

    }

        if(conn != null)

    {

        conn.close();

        conn = null;

    }

    %>

  </body>

</html>

 

 

 

 

showInfo.jsp

 

 

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>

<%@ page import="java.sql.*"%>

<%

String path = request.getContextPath();

String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";

%>

 

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>

  <head>

    <base href="<%=basePath%>">

    

    <title>学生信息</title>

    

<meta http-equiv="pragma" content="no-cache">

<meta http-equiv="cache-control" content="no-cache">

<meta http-equiv="expires" content="0">    

<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">

<meta http-equiv="description" content="This is my page">

<!--

<link rel="stylesheet" type="text/css" href="styles.css">

-->

 

  </head>

  

  <body background="pic/background.jpg">

 <%

    response.setCharacterEncoding("UTF-8");

    request.setCharacterEncoding("UTF-8");

    String id = request.getParameter("id");

    String name = request.getParameter("name");

    String age = request.getParameter("age");

    String gender = request.getParameter("gender");

    String major = request.getParameter("major");

    Connection conn = null;

    Statement stat = null;

    ResultSet rs = null;

    Class.forName("com.mysql.jdbc.Driver");

    String url = "jdbc:mysql://localhost:3306/jsp";

    String user = "root";

    String password = "root";

    conn = DriverManager.getConnection(url,user,password);

    stat = conn.createStatement();

    rs = stat.executeQuery("select * from student");

  %>

  <br>

    <h2>学生信息</h2>  <hr>    

    <br>

  <h3>全部学生信息如下</h3>

   <table width="450" border="100" cellSpacing=3 style="font-size:15pt;border:dashed 1pt">

    <tr>

    <td>学号</td>

    <td>姓名</td>

    <td>年龄</td>

    <td>性别</td>

    <td>专业</td>

    </tr>

    <%

    while(rs.next())

    {

    out.print("<tr>");

    out.print("<td>" + rs.getInt("id") + "</td>");

    out.print("<td>" + rs.getString("name") + "</td>");

    out.print("<td>" + rs.getInt("age") + "</td>");

    out.print("<td>" + rs.getString("gender") + "</td>");

    out.print("<td>" + rs.getString("major") + "</td>");

    %>

    <td><a href="delete.jsp?id=<%=rs.getInt("id") %>">删除</a></td>

    <td><a href="update.jsp?id=<%=rs.getInt("id") %>">修改</a></td>

    <%

    out.print("</tr>");

    }

  

    %>

      </table>

      

      <br>

    <form action="select_for_id.jsp" method="post">

   

  <h3>按学号查询:<input type="text" name="id"  value="" title="学号不能为空" ></input>

    <input type="submit" value="查询"/></h3>

    <br>

    </form>

    

    <form action="select_for_name.jsp" method="post">

    <h3>按姓名查询:<input type="text" name="name" value="" title="姓名不能为空"></input>

    <input type="submit" value="查询" /></h3>

    <br>

    </form>

    

    <form action="select_for_age.jsp" method="post">

   <h3> 按年龄查询:<input type="text" name="age" value="" title="年龄不能为空"></input>

    <input type="submit" value="查询"/></h3>

    <br>

    </form>

    

    <form action="select_for_gender.jsp" method="post">

   <h3>  按性别查询:<input type="text" name="gender" value="" title="性别不能为空"></input>

    <input type="submit" value="查询"/></h3>

    <br>

    </form>

    

    <form action="select_for_major.jsp" method="post">

    <h3> 按专业查询:<input type="text" name="major" value="" title="专业不能为空"></input>

    <input type="submit" value="查询"/></h3>

    <br>

    </form>

<br>

<h3><a href=addStuInfo.jsp>返回添加学生信息页面</a></h3>

<br>

 

      <%

    if(rs != null)

    {

        rs.close();

        rs = null;

    }

        if(stat != null)

    {

        stat.close();

        stat = null;

    }

        if(conn != null)

    {

        conn.close();

        conn = null;

    }

    %>

   

  </body>

</html>

 楼主QQ：496056171

0 0
手机必备软件大全2016 手机必备软件大全2016
原创粉丝点击
热门IT博客
toad for oracle mactoad for oracle mac
国家电网照片采集软件国家电网照片采集软件
电视直播点播软件
linux 模糊查找文件
it售后工程师岗位职责
太阳帆轨迹优化
刘邦打仗知乎
太空工程师 编程
java商城系统源码下载
网络销售卖什么好?
外星人调节灯光软件
tensorflow ocr
godaddy域名赎回
用ps做淘宝店长图
域名怎么注册
golang和go的区别
oracle插数据
hadoop2.7.3源码下载
淘宝对电子商务的意义
地暖好吗知乎
热门问题 老师的惩罚 人脸识别 我在镇武司摸鱼那些年 重生之率土为王 我在大康的咸鱼生活 盘龙之生命进化 天生仙种 凡人之先天五行 春回大明朝 姑娘不必设防，我是瞎子 华侨城温泉 东部华侨城天麓 东部华侨城 住宿 广东深圳东部华侨城 东部华侨城一天 深圳东部华侨城电话 东部华侨城温泉 华侨城东部华侨城 深圳东部华侨城怎么玩 东部华侨城 旅游 深圳东部华侨城门票优惠 深圳东部华侨城附近住宿 去深圳东部华侨城 张梦圆 叶梦圆 李梦圆 张梦圆绵羊队 梦圆 徐梦圆资料 放飞梦想梦圆冬奥征文 徐梦圆是怎么火起来的 缘梦圆床垫 陈梦圆 青岛海梦圆大饭店 绵羊队队长张梦圆 王昱珩老婆张梦圆 泰国华欣地产 华歌尔 华歌尔 黛安芬 蜜桃派 华歌尔 华歌尔 歌瑞尔 华哥尔 华歌尔文胸 华歌尔内衣多少钱 华歌尔文胸价格 华歌尔文胸怎么样 华歌尔工厂 华歌尔塑身内衣 华歌尔淘宝旗舰店 华歌尔塑身衣 华歌尔运动内衣

程序博客网，程序员的互联网技术博客家园。csdn论坛精品 msdn技术资料都在这里