简单学生系统之学生基本信息_学生信息里的title

Student.java

package nuc.select.student;
 
public class Student {
       private String scno;
       private String sno;
       private String sname;
       private String ssex;
       private int  sage;
       public String getScno(){
    	   return scno;
       }
       public void setScno(String scno){
    	   this.scno=scno;
       }
       public String getSno(){
    	   return sno;
       }
       public void setSno(String sno){
    	   this.sno=sno;
       }
       public String getSname(){
    	   return sname;
       }
       public void setSname(String sname){
    	   this.sname=sname;
       }
       public String getSsex(){
    	   return ssex;
       }
       public void setSsex(String ssex){
    	   this.ssex=ssex;
       }
       public int getSage(){
    	   return sage;
       }
       public void setSage(int sage){
    	   this.sage=sage;
       }
}

Coon.java

package nuc.select.coon;
 
import java.sql.*;
 
public class Coon {
     public static final String DBDRIVER="org.gjt.mm.mysql.Driver";
     public static final String DBURL="jdbc:mysql://localhost:3306/select";
     public static final String DBUSER="root";
     public static final String DBPASS="*****";
     Connection coon=null;
      public  Connection getCoon(){
    	  try{
    		  Class.forName(DBDRIVER);
    		  coon=DriverManager.getConnection(DBURL,DBUSER,DBPASS);
    	  }catch(Exception e){
    		e.printStackTrace();
    	  }
    	  return coon;
      }
    
}

StuDao.java

package nuc.select.Dao;
 
import java.sql.*;
 
import nuc.select.coon.Coon;
import nuc.select.student.Student;
 
public class StuDao {
       public int Insert(Student student){
    	   int rst=0;
    	   Coon studentcoon=new Coon();
    	   Connection scoona=studentcoon.getCoon(); 
    	   String sql_insert="insert into student(scno,sno,sname,ssex,sage) values (?,?,?,?,?)";
    	   try {
			PreparedStatement pst=scoona.prepareStatement(sql_insert);
			pst.setString(1,student.getScno());
			pst.setString(2, student.getSno());
			pst.setString(3,student.getSname());
			pst.setString(4,student.getSsex());
			pst.setInt(5,student.getSage());
			rst=pst.executeUpdate();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
    	   return rst;
       }
       public int Delete(Student student){
    	   int rst=0;
    	   Coon studentcoon=new Coon();
    	   Connection scoona=studentcoon.getCoon();
    	   String sql_delete="delete from student where sno=?";
    	   try {
			PreparedStatement pst=scoona.prepareStatement(sql_delete);
			pst.setString(1,student.getSno());
			rst=pst.executeUpdate();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
    	   return rst;
       }
       public ResultSet Query(){
    	   ResultSet rst=null;
    	   Coon studentcoon=new Coon();
    	   Connection scoona=studentcoon.getCoon();
    	   String sql_query="select * from student";
    	   try {
			PreparedStatement pst=scoona.prepareStatement(sql_query);
			rst=pst.executeQuery();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
    	   return rst;
       }
       public int Updates(Student student){
    	   int rst=0;
    	   Coon studentcoon=new Coon();
    	   Connection scoona=studentcoon.getCoon();
    	   String sql_update="update student set scno=?,sname=?,ssex=?,sage=? where sno=?";
    	   try {
			PreparedStatement pst=scoona.prepareStatement(sql_update);
			pst.setString(1,student.getScno());
			pst.setString(2,student.getSname());
			pst.setString(3,student.getSsex());
			pst.setInt(4,student.getSage());
			pst.setString(5,student.getSno());
			rst=pst.executeUpdate();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
    	   return rst;
       }
       public ResultSet Select(Student student){
    	   ResultSet rst=null;
    	   Coon studentcoon=new Coon();
    	   Connection scoona=studentcoon.getCoon();
    	   String sql_query="select * from student where sno=?";
    	   try {
			PreparedStatement pst=scoona.prepareStatement(sql_query);
			pst.setString(1,student.getSno());
			rst=pst.executeQuery();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
    	   return rst;
       }
}

insertStudent.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    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>Insert title here</title>
</head>
<body>
<form action="doinsertStudent.jsp" method="post">
班号<input type="text" name="scno">   
学号<input type="text" name="sno">   
姓名<input type="text" name="sname">   
性别<input type="text" name="ssex">   
年龄<input type="text" name="sage">   
<input type="submit" value="添加">
<input type="reset" value="重置">
</form>
</body>
</html>

doinsertStudent.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
    <%@ page import="java.sql.*" %>
    <%@ page import="nuc.select.student.*" %>
    <%@ page import="nuc.select.Dao.*" %>
<!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>Insert title here</title>
</head>
<body>
<%request.setCharacterEncoding("utf-8"); %>
<jsp:useBean id="students" class="nuc.select.student.Student">
<jsp:setProperty name="students" property="*"/>
</jsp:useBean>
<%
      StuDao stu=new StuDao();
      Student stun=new Student();
      int rt=stu.Insert(students);
      if(rt>0){
    	  out.println("添加成功！");
      }
      else{
    	  out.println("添加失败！");
      }
%>
</body>
</html>

deleteStudent.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
    <%@ page import="java.sql.*" %>
    <%@ page import="nuc.select.student.*" %>
    <%@ page import="nuc.select.Dao.*" %>
<!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>Insert title here</title>
</head>
<body>
<%
    StuDao stu=new StuDao();
    Student stun=new Student();
    stun.setSno(request.getParameter("sno"));
    int rst=stu.Delete(stun);
    if(rst>0){
    	out.println("删除成功！");
    }else{
    	out.println("删除失败！");
    }
%>
</body>
</html>

updateStudent.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
    <%@ page import="java.sql.*" %>
    <%@ page import="nuc.select.student.*" %>
    <%@ page import="nuc.select.Dao.*" %>
<!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>Insert title here</title>
</head>
<body>
 <% 
    request.setCharacterEncoding("utf-8");
	StuDao stu=new StuDao();
 	Student stun=new Student();
 	stun.setSno(request.getParameter("sno"));
 	ResultSet rst=stu.Select(stun);
 	if(rst.next()){
 %>
 <form action="doupdateStudent.jsp?sno=<%=rst.getString("sno") %>" method="post">
班号<input type="text" name="scno" value="<%=rst.getString("scno")%>">   
学号<input type="text" name="sno" value="<%=rst.getString("sno")%>">   
姓名<input type="text" name="sname" value="<%=rst.getString("sname")%>">   
性别<input type="text" name="ssex" value="<%=rst.getString("ssex")%>">   
年龄<input type="text" name="sage" value="<%=rst.getInt("sage")%>">   
<input type="submit" value="修改">
<input type="reset" value="取消">
</form>
 <%} %>
</body>
</html>

doupdateStudent.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
    <%@ page import="java.sql.*" %>
    <%@ page import="nuc.select.student.*" %>
    <%@ page import="nuc.select.Dao.*" %>
<!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>Insert title here</title>
</head>
<body>
<% request.setCharacterEncoding("utf-8"); %>
<jsp:useBean id="std" class="nuc.select.student.Student">
<jsp:setProperty name="std" property="*" />
</jsp:useBean>
<%
	StuDao stu=new StuDao();
	Student stun=new Student();
	stun.setSno(request.getParameter("sno"));
	int rst=stu.Updates(std);
	if(rst>0){
		out.println("修改成功！");
	}else{
		out.println("修改失败！");
	}
%>
</body>
</html>

queryStudent.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
    <%@ page import="java.sql.*" %>
    <%@ page import="nuc.select.student.*" %>
    <%@ page import="nuc.select.Dao.*" %>
<!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>
<style type="text/css">
td{
  text-align:center;
}
a{
  text-decoration:none;
}
</style>
</head>
<body>
<center>
<% 
       StuDao stu=new StuDao();
       Student stun=new Student();
       ResultSet rst=stu.Query();
%>
 
<table border="1" width="500" height="500">
<caption>学生基本信息表</caption>
<tr><td>班号</td><td>学号</td><td>姓名</td><td>性别</td><td>年龄</td><td colspan="2">数据操作</td></tr>
<%
    while(rst.next()){
%>
<tr>
<td><%=rst.getString("scno") %></td>
<td><%=rst.getString("sno") %></td>
<td><%=rst.getString("sname") %></td>
<td><%=rst.getString("ssex") %></td>
<td><%=rst.getString("sage") %></td>
<td><a href="deleteStudent.jsp?sno=<%=rst.getString("sno")%>">删除</a></td>
<td><a href="updateStudent.jsp?sno=<%=rst.getString("sno")%>">修改</a></td>
</tr>
<%    	
    }
%>
</table>
<a href="insertStudent.jsp">添加</a>
</center>
</body>
</html>