Java实现简单Web学生管理系统

新手一枚，本篇属于学习记录。

(一)数据库创建(Oracle)

创建表

create table student(
	sno varchar2(8) primary key,
	sname varchar2(10) not null,
	sex varchar2(2),
	sage number(2),
	brithday date
	);

(二)jdbc连接数据库(Oracle)

public class DBConnect {
   
	Connection connect=null;
	public Connection cnn(){
   
		try{
   
		Driver driver=new OracleDriver();
		DriverManager.deregisterDriver(driver);
		
		Properties pro=new Properties();
		pro.put("user", "library");
		pro.put("password", "library");
		connect=driver.connect("jdbc:oracle:thin:@localhost:1521:orcl", pro);
//		System.out.println("连接成功！");		
	}catch(Exception e){
   
		System.out.println(e.getMessage());
		e.printStackTrace();
	}
		return connect;
	}
	public void cos(){
   
		//关闭数据库
		try{
   
			if(connect!=null){
   
				connect.close();
				//System.out.println("cnn关闭！");
			}
			//System.out.println("数据库连接已关闭！");
		}catch(Exception e){
   
			System.out.println(e.getMessage());
		}
	}

}

(三)创建学生类

public class StudentVo{
   
	private String sno;
	private String sname;
	private int age;
	private Date Birthday;
	private String genger;
	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 int getAge() {
   
		return