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

《jsp简单的学籍管理系统方案.doc》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、......完成一个简单的学籍管理系统，具体的要求如下：1、完成数据库及其表的创建2、创建对应的JavaBean3、对数据库的连接单独创建一个类4、在JSP页面完成对应的查询、添加、删除、修改功能。学习好帮手......Student.javapackagecn.bean;publicclassStudent{privateStringstuId;privateStringstuName;privateStringstuSex;privateintstuAge;privateStringstuJig;private

2、StringstuDept;publicStringgetStuId(){returnstuId;}publicvoidsetStuId(StringstuId){this.stuId=stuId;}publicStringgetStuName(){returnstuName;}publicvoidsetStuName(StringstuName){this.stuName=stuName;}publicStringgetStuSex(){returnstuSex;}publicvoidsetStuSex(Stri

3、ngstuSex){this.stuSex=stuSex;}publicintgetStuAge(){returnstuAge;}publicvoidsetStuAge(intstuAge){this.stuAge=stuAge;}publicStringgetStuJig(){returnstuJig;}publicvoidsetStuJig(StringstuJig){this.stuJig=stuJig;学习好帮手......}publicStringgetStuDept(){returnstuDept;}p

4、ublicvoidsetStuDept(StringstuDept){this.stuDept=stuDept;}}DBUtil.javapackagecn.database;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.SQLException;publicclassDBUtil{publicConnectiongetConnection(){Stringdriver="com.microsoft.sqlserver.j

5、dbc.SQLServerDriver";Stringurl="jdbc:sqlserver://localhost:1433;Databasename=students";Stringuser="webuser";Stringpassword="webpass";try{Class.forName(driver);}catch(ClassNotFoundExceptione){e.printStackTrace();}try{returnDriverManager.getConnection(url,user,p

6、assword);}catch(SQLExceptione){e.printStackTrace();}returnnull;}publicstaticvoidmain(String[]args){DBUtildb=newDBUtil();System.out.println(db.getConnection());学习好帮手......}}List.jsp<%@pagelanguage="java"import="java.util.*"pageEncoding="GB18030"%><%@pageimport=

7、"java.sql.*"%><%@pageimport="cn.database.*"%>#title{text-align:center;color:#000;font-size:30px;}td{text-align:center;}

8、#ffffff"><%!Stringurl,sql;%><%!Connectionconn;//定义数据库连接对象%><%!ResultSetrs;//定义结果集对象%><%!Statementstmt;//定义SQL语句对象%><%!inti;%>学籍管理系统