jsp简单的学籍管理系统.doc

完成一个简单的学籍管理系统，具体的要求如下： 1、完成数据库及其表的创建 2、创建对应的JavaBean 3、对数据库的连接单独创建一个类 4、在JSP页面完成对应的查询、添加、删除、修改功能。 Student.java package cn.bean; public class Student { private String stuId; private String stuName; private String stuSex; private int stuAge; private String stuJig; private String stuDept; public String getStuId() { return stuId; } public void setStuId(String stuId) { this.stuId = stuId; } public String getStuName() { return stuName; } public void setStuName(String stuName) { this.stuName = stuName; } public String getStuSex() { return stuSex; } public void setStuSex(String stuSex) { this.stuSex = stuSex; } public int getStuAge() { return stuAge; } public void setStuAge(int stuAge) { this.stuAge = stuAge; } public String getStuJig() { return stuJig; } public void setStuJig(String stuJig) { this.stuJig = stuJig; } public String getStuDept() { return stuDept; } public void setStuDept(String stuDept) { this.stuDept = stuDept; } } DBUtil.java package cn.database; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; public class DBUtil { public Connection getConnection(){ String driver=com.microsoft.sqlserver.jdbc.SQLServerDriver; String url=jdbc:sqlserver://localhost:1433;Databasename=students; String user=webuser; String password=webpass; try { Class.forName(driver); } catch (ClassNotFoundException e) { e.printStackTrace(); } try { return DriverManager.getConnection(url, user, password); } catch (SQLException e) { e.printStackTrace(); } return null; } public static void main(String[] args) { DBUtil db= new DBUtil(); System.out.println(db.getConnection()); } } List.jsp %@ page language=java import=java.util.* pageEncoding=GB18030% %@page import=java.sql.* % %@page import=cn.database.* % !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN html head title学籍管理系统/title style type=text/css