jsp整合各设计模块
1 <%@ page language="java" contentType="text/html; charset=UTF-8" 2 pageEncoding="UTF-8"%> 3 <!DOCTYPE html> 4 <html> 5 <head> 6 <meta charset="UTF-8"> 7 <title>学生身体体质信息管理系统</title> 8 </head> 9 10 <frameset rows="80,*" > 11 <frame src="index_stu_title.jsp" scrolling="no"> 12 <frameset cols="140,*" > 13 <frame src="index_stu_left.jsp" scrolling="no"> 14 <frame src="index_stu_right.jsp" name="right" scrolling="no"> 15 </frameset> 16 </frameset> 17 18 </html>
1 <%@ page language="java" contentType="text/html; charset=UTF-8" 2 pageEncoding="UTF-8"%> 3 <!DOCTYPE html> 4 <html> 5 <head> 6 <meta charset="UTF-8"> 7 <title>页面标题</title> 8 </head> 9 <body> 10 <center> 11 <h1> 12 学生身体体质信息管理系统 13 </h1> 14 </center> 15 </body> 16 </html>
1 <%@ page language="java" contentType="text/html; charset=UTF-8" 2 pageEncoding="UTF-8"%> 3 <!DOCTYPE html> 4 <html> 5 <head> 6 <meta charset="UTF-8"> 7 <title>页面菜单</title> 8 </head> 9 <body> 10 <br><br><br><br><br><br> 11 <p><a href="find_stu_1.jsp" target="right">列出全部学生</a> </p> 12 <p><a href="find_stu_3_tijiao.jsp" target="right">按条件查询学生</a> </p> 13 <p><a href="insert_stu_2_tijiao.jsp" target="right">新添加学生</a> </p> 14 <p><a href="delete_stu_2_tijiao.jsp" target="right">按条件删除学生</a> </p> 15 <p><a href="update_stu_2_tijiao.jsp" target="right">按条件修改学生</a> </p> 16 17 </body> 18 </html>
1 <%@ page language="java" contentType="text/html; charset=UTF-8" 2 pageEncoding="UTF-8"%> 3 <!DOCTYPE html> 4 <html> 5 <head> 6 <meta charset="UTF-8"> 7 <title>信息显示页面</title> 8 </head> 9 <body background="./image/bac.jpg" > 10 11 </body> 12 </html>
1 <%@ page language="java" contentType="text/html; charset=UTF-8" 2 pageEncoding="UTF-8"%> 3 <!DOCTYPE html> 4 <html> 5 <head> 6 <meta charset="UTF-8"> 7 <title>删除条件提交页面</title> 8 </head> 9 <body> 10 请选择删除记录条件<hr width="100%" size="3"> 11 <form action="delete_stu_2.jsp" method="post"> 12 姓名:<input type="texxt" name="name"><br><br> 13 性别:男<input type="radio" value="男" name="sex"> 14 女<input type="radio" value="女" name="sex"> 15 体重范围:<p> 16 最小<input type="text" name="wl"><br><br> 17 最大<input type="text" name="w2"><p> 18 <input type="submit" value="提 交"> 19 <input type="reset" value="取 消"> 20 </form> 21 </body> 22 </html>
1 <%@page import="javax.servlet.jsp.tagext.TryCatchFinally"%> 2 <%@page import="java.sql.DriverManager"%> 3 <%@page import="java.sql.*"%> 4 <%@page import="java.sql.PreparedStatement"%> 5 <%@ page language="java" contentType="text/html; charset=UTF-8" 6 pageEncoding="UTF-8"%> 7 <!DOCTYPE html> 8 <html> 9 <head> 10 <meta charset="UTF-8"> 11 <title>利用提交条件删除记录页面</title> 12 </head> 13 <body> 14 <% 15 String className="com.mysql.jdbc.Driver"; 16 String user="root"; 17 String password="root"; 18 String url="jdbc:mysql://localhost:3306/db_shangke"; 19 Class.forName(className); 20 Connection conn=DriverManager.getConnection(url, user, password); 21 request.setCharacterEncoding("UTF-8"); 22 String name=request.getParameter("name"); 23 String sex=request.getParameter("sex"); 24 String ww1=request.getParameter("w1"); 25 String ww2=request.getParameter("w2"); 26 String s="1=1 "; 27 if(!name.equals("")) s=s+" and name='"+name+"'"; 28 if(sex!=null) s=s+" and sex='"+sex+"'"; 29 float w1,w2; 30 try{ 31 if(!ww1.equals("")) { 32 w1=Float.parseFloat(ww1); 33 s=s+"and weight>="+w1; 34 } 35 if(!ww2.equals("")) { 36 w2=Float.parseFloat(ww2); 37 s=s+"and weight<="+w2; 38 } 39 }catch(Exception e){ 40 e.printStackTrace(); 41 } 42 43 String sql="delete from stu_info where "+s; 44 PreparedStatement pstmt=conn.prepareStatement(sql); 45 46 int n=pstmt.executeUpdate(); 47 if(n==1){ 48 out.print("数据删除成功!"); 49 } 50 else{ 51 out.print("数据删除操作失败!"); 52 } 53 54 55 if(pstmt!=null){ 56 pstmt.close(); 57 } 58 if(conn!=null){ 59 conn.close(); 60 } 61 62 %> 63 </body> 64 </html>
1 <%@page import="java.sql.*"%> 2 <%@ page language="java" contentType="text/html; charset=UTF-8" 3 pageEncoding="UTF-8"%> 4 <!DOCTYPE html> 5 <html> 6 <head> 7 <meta charset="UTF-8"> 8 <title>Insert title here</title> 9 </head> 10 <body> 11 12 13 <% 14 /*String className="oracle.jdbc.OracleDriver"; 15 String url="jdbc:oracle:thin:@localhost:1521:ORCL"; 16 String user="scott"; 17 String password="tiger"; 18 */ 19 String className="com.mysql.jdbc.Driver"; 20 String user="root"; 21 String password="root"; 22 String url="jdbc:mysql://localhost:3306/db_shangke"; 23 Class.forName(className); 24 25 Connection conn = DriverManager.getConnection(url, user, password); 26 String sql="select * from stu_info"; 27 PreparedStatement pstmt=conn.prepareStatement(sql, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE); 28 ResultSet rs=pstmt.executeQuery(); 29 30 rs.last();//移动至最后一条记录 31 32 %>你要查询的学生数据表中共有 33 <font size="5" color="red"> <%=rs.getRow() %></font>人 34 <table border="2" bgcolor="ccceee" width="650"> 35 <tr bgcolor="CCCCCC" align="center"> 36 <td>记录条数 </td> 37 <td>学号 </td> 38 <td>姓名 </td> 39 <td>性别</td> 40 <td>年龄</td> 41 <td>体重</td> 42 <td>身高 </td> 43 </tr> 44 45 <% 46 rs.beforeFirst();//移至第一条记录之前 47 48 while(rs.next()){ 49 %><tr> 50 <td><%=rs.getRow() %> </td> 51 <td><%=rs.getString("id") %></td> 52 <td><%=rs.getString("name") %></td> 53 <td><%=rs.getString("sex") %></td> 54 <td><%=rs.getString("age") %></td> 55 <td><%=rs.getString("weight") %></td> 56 <td><%=rs.getString("height") %></td> 57 </tr> 58 <%} %> 59 </table> 60 61 <% 62 if(rs!=null) { 63 rs.close(); 64 } 65 if(pstmt!=null){ 66 pstmt.close(); 67 } 68 if(conn!=null){ 69 conn.close(); 70 } 71 %> 72 </body> 73 </html>
1 <%@ page language="java" contentType="text/html; charset=UTF-8" 2 pageEncoding="UTF-8"%> 3 <!DOCTYPE html> 4 <html> 5 <head> 6 <meta charset="UTF-8"> 7 <title>查询页面提交</title> 8 </head> 9 <body> 10 请选择查询条件<hr width="100%" size="3"> 11 <form action="find_stu_3.jsp" method="post"> 12 性别:男<input type="radio" value="男" name="sex" checked="checked"> 13 女<input type="radio" value="女" name="sex"><br><br> 14 15 体重范围:<p> 16 最小<input type="text" name="w1" value="0"><br><br> 17 最大<input type="text" name="w2" value="150"><br><br> 18 <input type="submit" value="提 交"> 19 <input type="reset" value="取 消"> 20 21 </form> 22 </body> 23 </html>
1 <%@page import="java.sql.*"%> 2 <%@ page language="java" contentType="text/html; charset=UTF-8" 3 pageEncoding="UTF-8"%> 4 <!DOCTYPE html> 5 <html> 6 <head> 7 <meta charset="UTF-8"> 8 <title>由提交页面获取查询条件并实现查询的页面</title> 9 </head> 10 <body> 11 <center> 12 <% 13 String className="com.mysql.jdbc.Driver"; 14 String user="root"; 15 String password="root"; 16 String url="jdbc:mysql://localhost:3306/db_shangke"; 17 18 Class.forName(className); 19 Connection conn= DriverManager.getConnection(url, user, password); 20 request.setCharacterEncoding("UTF-8"); 21 String sex=request.getParameter("sex"); 22 float weight1=Float.parseFloat(request.getParameter("w1")); 23 float weight2=Float.parseFloat(request.getParameter("w2")); 24 25 String sql="select *from stu_info where sex=? and weight>=? and weight<=?"; 26 PreparedStatement pstmt=conn.prepareStatement(sql); 27 28 pstmt.setString(1, sex); 29 pstmt.setFloat(2, weight1); 30 pstmt.setFloat(3, weight2); 31 32 ResultSet rs=pstmt.executeQuery(); 33 rs.last();%>你要查询的学生数据表中共有 34 <font size="5" color="red"> 35 <%=rs.getRow()%> 36 </font>人 37 <table border="2" bgcolor="ccceee" width="650"> 38 <tr bgcolor="CCCCCC" align="center"> 39 <td>记录条数</td> 40 <td>学号</td> 41 <td>姓名</td> 42 <td>性别</td> 43 <td>年龄</td> 44 <td>体重</td> 45 <td>身高</td> 46 </tr> 47 <% 48 rs.beforeFirst(); 49 while(rs.next()){ 50 51 %> 52 <tr align="center"> 53 <td><%=rs.getRow() %> </td> 54 <td><%=rs.getString("id")%> </td> 55 <td><%=rs.getString("name") %> </td> 56 <td><%=rs.getString("sex")%> </td> 57 <td><%=rs.getInt("age") %> </td> 58 <td><%=rs.getDouble("weight") %> </td> 59 <td><%=rs.getDouble("height")%> </td> 60 </tr> 61 <%} %> 62 </table> 63 </center> 64 <% 65 if(rs!=null){ 66 rs.close(); 67 } 68 if(pstmt!=null){ 69 pstmt.close(); 70 } 71 if(conn!=null){ 72 conn.close(); 73 } 74 %> 75 </body> 76 </html>
1 <%@ page language="java" contentType="text/html; charset=UTF-8" 2 pageEncoding="UTF-8"%> 3 <!DOCTYPE html> 4 <html> 5 <head> 6 <meta charset="UTF-8"> 7 <title>添加任意学生的提交页面</title> 8 </head> 9 <body> 10 <form action="insert_stu_2.jsp" method="post"> 11 <table border="0" width="238" height="252"> 12 <tr> 13 <td>学号</td> 14 <td><input type="text" name="id"> </td> 15 </tr> 16 <tr> 17 <td>姓名</td> 18 <td><input type="text" name="name"> </td> 19 </tr> 20 <tr> 21 <td>性别</td> 22 <td><input type="text" name="sex"> </td> 23 </tr> 24 <tr> 25 <td>年龄</td> 26 <td><input type="text" name="age"> </td> 27 </tr> 28 <tr> 29 <td>体重</td> 30 <td><input type="text" name="weight"> </td> 31 </tr> 32 <tr> 33 <td>身高</td> 34 <td><input type="text" name="height"> </td> 35 </tr> 36 <tr align="center"> 37 <td colspan="2"> 38 <input type="submit" value="提 交"> 39 <input type="reset" value="取 消"> 40 </td> 41 </tr> 42 </table> 43 </form> 44 </body> 45 </html>
1 <%@page import="java.sql.*"%> 2 <%@ page language="java" contentType="text/html; charset=UTF-8" 3 pageEncoding="UTF-8"%> 4 <!DOCTYPE html> 5 <html> 6 <head> 7 <meta charset="UTF-8"> 8 <title>添加一条记录</title> 9 </head> 10 <body> 11 <% 12 String className="com.mysql.jdbc.Driver"; 13 String url="jdbc:mysql://localhost:3306/db_shangke"; 14 String user="root"; 15 String password="root"; 16 Class.forName(className); 17 Connection conn=DriverManager.getConnection(url, user, password); 18 String sql="Insert into stu_info values(?,?,?,?,?,?)"; 19 PreparedStatement pstmt=conn.prepareStatement(sql); 20 request.setCharacterEncoding("utf-8"); 21 int id=Integer.parseInt(request.getParameter("id")); 22 String name=request.getParameter("name"); 23 String sex=request.getParameter("sex"); 24 int age=Integer.parseInt(request.getParameter("age")); 25 int weight=Integer.parseInt(request.getParameter("weight")); 26 int height=Integer.parseInt(request.getParameter("height")); 27 pstmt.setInt(1, id); 28 pstmt.setString(2, name); 29 pstmt.setString(3, sex); 30 pstmt.setInt(4, age); 31 pstmt.setInt(5,weight); 32 pstmt.setInt(6,height); 33 34 int n=pstmt.executeUpdate(); 35 if(n==1){%>数据插入操作成功!<br><%} 36 else{ %>数据插入操作失败!<br> <% } 37 38 if(pstmt!=null){ 39 pstmt.close(); 40 } 41 if(conn!=null){ 42 conn.close(); 43 } 44 %> 45 </body> 46 </html>
1 <%@ page language="java" contentType="text/html; charset=UTF-8" 2 pageEncoding="UTF-8"%> 3 <!DOCTYPE html> 4 <html> 5 <head> 6 <meta charset="UTF-8"> 7 <title>修改记录的条件提交页面</title> 8 </head> 9 <body> 10 请选择修改记录所满足的条件<hr width="100%" size="3"> 11 <form action="update_stu_2_edit.jsp" method="post"> 12 姓名:<input type="text" name="name"><br> <br> 13 性别:男<input type="radio" value="男" name="sex"> 14 女<input type="radio" value="女" name="sex"><br> <br> 15 <input type="submit" value="提 交"> 16 17 <input type="reset" value="取 消"> 18 </form> 19 </body> 20 </html>
1 <%@page import="java.sql.*"%> 2 <%@ page language="java" contentType="text/html; charset=UTF-8" 3 pageEncoding="UTF-8"%> 4 <!DOCTYPE html> 5 <html> 6 <head> 7 <meta charset="UTF-8"> 8 <title>修改编辑页面</title> 9 </head> 10 <body> 11 <% 12 String className="com.mysql.jdbc.Driver"; 13 String url="jdbc:mysql://localhost:3306/db_shangke"; 14 String user="root"; 15 String password="root"; 16 17 Class.forName(className); 18 Connection conn=DriverManager.getConnection(url, user, password); 19 request.setCharacterEncoding("UTF-8"); 20 String sex=request.getParameter("sex"); 21 String name=request.getParameter("name"); 22 23 session.setAttribute("sex", sex); 24 session.setAttribute("name", name); 25 26 String sql="select *from stu_info where sex=? and name=?"; 27 PreparedStatement pstmt=conn.prepareStatement(sql); 28 pstmt.setString(1, sex); 29 pstmt.setString(2, name); 30 ResultSet rs=pstmt.executeQuery(); 31 if(rs.next()){ 32 int id=rs.getInt(1); 33 String name2=rs.getString("name"); 34 String sex2=rs.getString(3); 35 int age=rs.getInt("age"); 36 float weight=rs.getFloat(5); 37 float height=rs.getFloat(6); 38 if(rs!=null){ 39 rs.close(); 40 } 41 if(pstmt!=null){ 42 pstmt.close(); 43 }if(conn!=null){ 44 conn.close(); 45 } 46 47 %> 48 <form action="update_stu_2.jsp" method="post"> 49 <table border="0" width="238" height="252"> 50 <tr> 51 <td> 学号 </td> <td> <input name="id" value=<%=id%>> </td> 52 </tr> 53 <tr> 54 <td> 姓名 </td> <td> <input name="name2" value=<%=name2%>> </td> 55 </tr> 56 <tr> 57 <td> 性别 </td> <td> <input name="sex2" value=<%=sex2%>> </td> 58 </tr> 59 <tr> 60 <td> 年龄 </td> <td> <input name="age" value=<%=age%>> </td> 61 </tr> 62 <tr> 63 <td> 体重 </td> <td> <input name="weight" value=<%=weight%>> </td> 64 </tr> 65 <tr> 66 <td> 身高 </td> <td> <input name="height" value=<%=height%>> </td> 67 </tr> 68 <tr align="center"> 69 <td colspan="2"> 70 <input type="submit" value="提 交"> 71 <input type="reset" value="取 消"> 72 </td> 73 </tr> 74 75 <%} 76 else{ 77 %> 78 没有找到合适的条件记录!! 79 <% 80 if(rs!=null){ 81 rs.close(); 82 } 83 if(pstmt!=null){ 84 pstmt.close(); 85 }if(conn!=null){ 86 conn.close();} 87 } 88 %> 89 90 </table> 91 </form> 92 </body> 93 </html>
1 <%@page import="java.sql.*"%> 2 <%@ page language="java" contentType="text/html; charset=UTF-8" 3 pageEncoding="UTF-8"%> 4 <!DOCTYPE html> 5 <html> 6 <head> 7 <meta charset="UTF-8"> 8 <title>修改后重写记录页面</title> 9 </head> 10 <body> 11 <% 12 String className="com.mysql.jdbc.Driver"; 13 String url="jdbc:mysql://localhost:3306/db_shangke"; 14 String user="root"; 15 String password="root"; 16 17 Class.forName(className); 18 19 Connection conn=DriverManager.getConnection(url, user, password); 20 String sql="update stu_info set id=?,name=?,sex=?,age=?,weight=?,height=? where name=? and sex=?"; 21 22 PreparedStatement pstmt=conn.prepareStatement(sql); 23 24 request.setCharacterEncoding("UTF-8"); 25 int id=Integer.parseInt(request.getParameter("id")); 26 String name2=request.getParameter("name2"); 27 String sex2=request.getParameter("sex2"); 28 int age=Integer.parseInt(request.getParameter("age")); 29 float weight=Float.parseFloat(request.getParameter("weight")); 30 float height=Float.parseFloat(request.getParameter("height")); 31 32 String name=(String)session.getAttribute("name"); 33 String sex=(String)session.getAttribute("sex"); 34 35 pstmt.setInt(1, id); 36 pstmt.setString(2, name2); 37 pstmt.setString(3, sex2); 38 pstmt.setInt(4,age); 39 pstmt.setFloat(5, weight); 40 pstmt.setFloat(6, height); 41 42 43 pstmt.setString(7,name); 44 pstmt.setString(8,sex); 45 46 int n=pstmt.executeUpdate(); 47 //System.out.print(n); 48 if(n>=1){ 49 out.print("重写数据成功!"+"<br>"); 50 } 51 else{ 52 out.print("重写数据失败!"+"<br>"); 53 out.print("n="+n); 54 } 55 56 if(pstmt!=null){ 57 pstmt.close(); 58 } 59 if(conn!=null){ 60 conn.close(); 61 } 62 %> 63 </body> 64 </html>
道阻且长,行则将至
浙公网安备 33010602011771号