JSP學生信息管理系統(tǒng)設計

%@ page contentType="text/html" pageEncoding="UTF-8"%>

html>
 head> 
 title>添加新學生/title> 
 /head>

 body>
 form action="stuinsert2.jsp" method="post">
 table border="0" width="238" heigth="252">
 tr>td>學號：/td>td>input type="text" name="id">/td>/tr>
 tr>td>姓名/td>td>input type="text" name="name">/td>/tr>
 tr>td>性別/td>td>input type="text" name="sex">/td>/tr>
 tr>td>年齡/td>td>input type="text" name="age">/td>/tr>
 tr>td>專業(yè)/td>td>input type="text" name="sdept">/td>/tr>
 tr align="center">
 td colspan="2">
 input type="submit" value="提交">nbsp;nbsp;nbsp;
 input type="reset" value="取消">
 /td>
 /tr>
 /table>
 /form>
 /body>
/html>

%@ page language="java" import="java.sql.*" pageEncoding="UTF-8"%>
html>
 head>
 title>添加學生處理程序/title>
 /head>
 body>
 % Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); 
    String url="jdbc:sqlserver://localhost:1433; DatabaseName=p"; 
    String user="sa";
    String password="123456"; 
  Connection conn=DriverManager.getConnection(url,user,password);
  request.setCharacterEncoding("UTF-8");
  String id=request.getParameter("id");
  String name=request.getParameter("name");
  String sex=request.getParameter("sex");
  int age=Integer.parseInt(request.getParameter("age"));
  String sdept=request.getParameter("sdept");
  String sql=String.format("select * from student where Sno=%s",id);
  Statement stmt=conn.createStatement();
  PreparedStatement pstmt;
  ResultSet rs=stmt.executeQuery(sql);
  if(!(rs.next())){
  pstmt=conn.prepareStatement("insert into Student values(?,?,?,?,?)");
  pstmt.setString(1,id);
  pstmt.setString(2,name);
  pstmt.setString(3,sex);
  pstmt.setInt(4,age);
  pstmt.setString(5,sdept);
  pstmt.executeUpdate();
  out.print("添加成功");  
  %>
  a href="stuinsert.jsp" rel="external nofollow" rel="external nofollow" >返回菜單/a>br>
  a href="main.jsp" rel="external nofollow" >/a>
  %}else{
  out.println("該學號已存在");%>
  a href="stuinsert.jsp" rel="external nofollow" rel="external nofollow" >重新添加/a>
  %}%>
 /body>
/html>

%@ page language="java" import="java.sql.*" pageEncoding="UTF-8"%>
%@ page import="javax.sql.*" %>
%@ page import="javax.naming.*" %>
html>
 head>
 title>信息查看頁面/title>
 /head> 
 body>
 center>
 % DataSource ds=null;
  InitialContext ctx=new InitialContext();
  ds=(DataSource)ctx.lookup("java:comp/env/jdbc/sqlserver");
  Connection conn=ds.getConnection();
  PreparedStatement pstmt=conn.prepareStatement("select * from Student");
  ResultSet rs=pstmt.executeQuery();
 %>   
 table border="2" bgcolor="ccceee" width="650">
 tr bgcolor="CCCCCC" align="center">
  td>記錄條數(shù)/td>td>學號/td>td>姓名/td>
  td>性別/td>td>年齡/td>td>專業(yè)/td>
 /tr>
 %
  while(rs.next()){
 %> 
 tr align="center">
 td>%=rs.getRow()%>/td>
 td>%=rs.getString(1)%>/td>
 td>%=rs.getString(2)%>/td>
 td>%=rs.getString(3)%>/td>
 td>%=rs.getString(4)%>/td>
 td>%=rs.getString(5)%>/td>
 /tr>
 %}%>
 /center>
 %if(rs!=null){rs.close();}
  if(pstmt!=null){pstmt.close();}
  if(conn!=null){conn.close();}
  %>
 /table> 
 /body>
/html>

%@ page language="java" pageEncoding="UTF-8"%>
html>
 head>
 title>My JSP 'stufind2.jsp' starting page/title>
 /head>
 body>
 請選擇查詢條件hr width="100%" size="3">
 form action="stufind3.jsp" method="post">
 性別input type="radio" value="男" name="sex" checked="checked">男
 input type="radio" value="女" name="sex">女
 年齡范圍：p>nbsp;nbsp;
 最?。篿nput type="text" name="a1">br>br>nbsp;
 最大：input type="text" name="a2">p>
 input type="submit" value="提交">
 input type="reset" value="取消">
 /form>
 /body>
/html>

%@ page contentType="text/html" import="java.sql.*" pageEncoding="UTF-8"%>
html>
 head>
 title>條件查詢處理頁面/title>
 /head>
 body>
 center>
 %Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
 String user="sa";
 String password="123456";
 String url="jdbc:sqlserver://localhost:1433;DatabaseName=p";
 Connection conn=DriverManager.getConnection(url,user,password);
 request.setCharacterEncoding("UTF-8");
 String sex=request.getParameter("sex");
 int age1=Integer.parseInt(request.getParameter("a1"));
 int age2=Integer.parseInt(request.getParameter("a2"));
 String sql="select * from Student where Ssex=? and Sage>=? and Sage=?";
 PreparedStatement pstmt=conn.prepareStatement(sql);
 pstmt.setString(1,sex);
 pstmt.setInt(2,age1);
 pstmt.setInt(3,age2);
 ResultSet rs=pstmt.executeQuery();
 %>
 table border="2" bgcolor="ccceee" width="650">
 tr bgcolcor="CCCCCC" align="center">
 td>記錄條數(shù)/td>td>學號/td>td>姓名/td>
 td>性別/td>td>年齡/td>td>專業(yè)/td>
 /tr>
 %while(rs.next()){ %>
 tr align="center">
 td>%=rs.getRow()%>/td>
 td>%=rs.getString(1)%>/td>
 td>%=rs.getString(2)%>/td>
 td>%=rs.getString(3)%>/td>
 td>%=rs.getString(4)%>/td>
 td>%=rs.getString(5)%>/td>
 /tr>
 %}%>
 /table>
 %if(rs!=null){rs.close();}
  if(pstmt!=null){pstmt.close();}
  if(conn!=null){conn.close();}
 %>
 /center>
 /body>
/html>

%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
html>
 head> 
 title>修改提交頁面/title>
 /head>
 body>
 center>
  請選擇修改記錄所滿足的條件
 form action="stuupdate2.jsp" method="post">
  姓名： input type="text" name="name">br>br>
  性別： 男input type="radio" value="男" name="sex">
      女input type="radio" value="女" name="sex">br>br>
  input type="submit" value="提交">nbsp;nbsp;nbsp;
  input type="reset" value="取消">
 /form>
 /center>
 /body>
/html>

%@ page contentType="text/html" import="java.sql.*" pageEncoding="UTF-8"%>
html>
 head> 
 title>修改編輯頁面/title>
 /head>
 body>
 % Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
  String user="sa";
  String password="123456";
  String url="jdbc:sqlserver://localhost:1433;DatabaseName=p";
  Connection conn=DriverManager.getConnection(url,user,password);
  request.setCharacterEncoding("UTF-8");
  String name=request.getParameter("name");
  String sex=request.getParameter("sex");
  session.setAttribute("sex",sex);
  session.setAttribute("name",name);
  String sql="select * from Student where Ssex=? and Sname=?";
  PreparedStatement pstmt=conn.prepareStatement(sql);
  pstmt.setString(1,sex);
  pstmt.setString(2,name);
  ResultSet rs=pstmt.executeQuery();
  if(rs.next()){
  String id=rs.getString("Sno");
  String name2=rs.getString("Sname");
  String sex2=rs.getString("Ssex");
  int age=rs.getInt("Sage");
  String sdept=rs.getString("Sdept");
  if(pstmt!=null){pstmt.close();}
  if(rs!=null){rs.close();}
  if(conn!=null){conn.close();}
  %>
  form action="stuupdate3.jsp" method="post">
  table border="0" width="238" height="252">
  tr>td>學號:/td>td>input type="text" name="id" value=%=id%>>/td>/tr>
  tr>td>姓名:/td>td>input type="text" name="name2" value=%=name2%>>/td>/tr>
  tr>td>性別:/td>td>input type="text" name="sex2" value=%=sex2%>>/td>/tr>
  tr>td>年齡:/td>td>input type="text" name="age" value=%=age%>>/td>/tr>
  tr>td>專業(yè):/td>td>input type="text" name="sdept" value=%=sdept%>>/td>/tr>
  tr align="center">
  td colspan="2">
  input type="submit" value="提交">nbsp;nbsp;nbsp;
  input type="reset" value="取消">
  /td>
  /tr>
  /table>
  /form>
  %}
  else{%>
      沒有找到合適條件的記錄??！%
   if(rs!=null){rs.close();}
   if(pstmt!=null){pstmt.close();}
   if(conn!=null){conn.close();}
 }%>
 /body>
/html>

%@ page language="java" import="java.sql.*" pageEncoding="UTF-8"%>
html>
 head> 
 title>修改后重寫頁面/title> 
 /head>
 body>
 % Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); 
  String url="jdbc:sqlserver://localhost:1433; DatabaseName=p"; 
  String user="sa";
  String password="123456"; 
  Connection conn=DriverManager.getConnection(url,user,password);
  String sql="update Student set Sno=?,Sname=?,Ssex=?,Sage=?,Sdept=? where Sname=? and Ssex=?";
  PreparedStatement pstmt=conn.prepareStatement(sql);
  request.setCharacterEncoding("UTF-8");
  String id=request.getParameter("id");
  String name2=request.getParameter("name2");
  String sex2=request.getParameter("sex2");
  int age=Integer.parseInt(request.getParameter("age"));
  String sdept=request.getParameter("sdept");
  String name=(String)session.getAttribute("name");
  String sex=(String)session.getAttribute("sex");
  pstmt.setString(1,id); pstmt.setString(2,name2);
  pstmt.setString(3,sex2); pstmt.setInt(4,age);
  pstmt.setString(5,sdept); pstmt.setString(6,name);
  pstmt.setString(7,sex);
  int n=pstmt.executeUpdate();
  if(n>=1){%>重寫數(shù)據(jù)庫操作成功！br>%}
  else{%>重寫數(shù)據(jù)庫操作失敗！br>%}
  if(pstmt!=null){pstmt.close();}
  if(conn!=null){conn.close();}
 %>
 /body>
/html>

%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
html>
 head> 
 title>條件刪除提交頁面/title>
 /head>
 body>
  請選擇刪除記錄條件hr width="100%" size="3">
  form action="studelete2.jsp" method="post">
  姓名：input type="text" name="name">br>br>
  性別：男input type="radio" value="男" name="sex">
  女input type="radio" value="女" name="sex">br>br>
  年齡范圍：br>p>
  最?。篿nput type="text" name="a1">br>
  最大：input type="text" name="a2">
  /p>
  input type="submit" value="提交">
  input type="reset" value="取消">

  /form>
 /body>
/html>

%@ page language="java" import="java.sql.*" pageEncoding="UTF-8"%>
html>
 head> 
 title>條件刪除處理頁面/title>
 /head> 
 body>
 % Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
  String user="sa";
  String password="123456";
  String url="jdbc:sqlserver://localhost:1433;DatabaseName=p";
  Connection conn=DriverManager.getConnection(url,user,password);
  request.setCharacterEncoding("UTF-8");
  String name=request.getParameter("name");
  String sex=request.getParameter("sex");
  String ag1=request.getParameter("a1");
  String ag2=request.getParameter("a2");
  int a3,a4;
  String sql="delete from Student where Sname=? and Ssex=? and Sage>=? and Sage=?";
  PreparedStatement pstmt=conn.prepareStatement(sql);
  if(!name.equals("")) pstmt.setString(1,name);
  if(sex!=null) pstmt.setString(2,sex);
  if(!ag1.equals("")){a3=Integer.parseInt(ag1); pstmt.setInt(3,a3);}
  if(!ag2.equals("")){a4=Integer.parseInt(ag2); pstmt.setInt(4,a4);}
  int n=pstmt.executeUpdate();
  if(n==1){%>數(shù)據(jù)刪除成功br>%}
  else{%>數(shù)據(jù)刪除失敗！br>%}
  if(pstmt!=null){pstmt.close();}
  if(conn!=null){conn.close();}
 %>
 /body>
/html>