学生信息管理系统毕业设计(7)

[键入文字]

public Student findStudent(String stu_id) throws SQLException {

Student stu=new Student();

String sql=\+stu_id+\; this.pstmt=this.conn.prepareStatement(sql); ResultSet rs=this.pstmt.executeQuery(); if(rs.next()) //判断rs是否查找到内容 {

stu.setStu_id(rs.getString(\)); stu.setPass(rs.getString(\)); stu.setName(rs.getString(\)); stu.setSex(rs.getString(\)); stu.setZy(rs.getString(\)); stu.setMz(rs.getString(\));

stu.setZzmm(rs.getString(\)); stu.setSfz(rs.getString(\)); stu.setJg(rs.getString(\));

stu.setJkzk(rs.getString(\)); stu.setRxnf(rs.getString(\)); stu.setLxfs(rs.getString(\)); stu.setEmail(rs.getString(\)); stu.setQtlxfs(rs.getString(\)); stu.setBz(rs.getString(\)); stu.setCym(rs.getString(\)); stu.setCsrq(rs.getString(\)); stu.setJtdz(rs.getString(\)); stu.setJtdh(rs.getString(\)); stu.setYzbm(rs.getString(\)); }

this.conn.close(); return stu; }

//学生修改自身信息

public boolean updateStudentbyself(Student stu,String stu_id) throws SQLException {

String sql=\+stu.getCym()+\ sfz='\+stu.getSfz()+\+stu.getCsrq()+\ jg='\+stu.getJg()+\+stu.getJkzk()+\

rxnf='\+stu.getRxnf()+\+stu.getJtdz()+\ jtdh='\+stu.getJtdh()+\+stu.getYzbm()+\ lxfs='\+stu.getLxfs()+\+stu.getEmail()+\ qtlxfs='\+stu.getQtlxfs()+\+stu.getBz()+\ where stu_id='\+stu_id+\;

this.pstmt=this.conn.prepareStatement(sql);

25

[键入文字]

if(this.pstmt.executeUpdate()>0) {

this.flag=true; }

this.conn.close(); return this.flag; }

5.3.3成绩查询

学生可以查看自己所学基础课程的成绩，省了寄成绩单的麻烦。

图5-6 学生成绩查询界面

5.3.4查看必修课表

学生可以查看并清楚地知道自身需要学习的基础课程有哪些。

26

[键入文字]

功能实现主要代码： //输出必修课程表

public List findallBixiuke() throws SQLException {

ArrayList al=new ArrayList(); String sql=\;

this.pstmt=this.conn.prepareStatement(sql); ResultSet rs=this.pstmt.executeQuery(); while(rs.next()) {

Bixiuke kecheng=new Bixiuke();

kecheng.setKch(rs.getString(\)); kecheng.setKcm(rs.getString(\)); kecheng.setZjjs(rs.getString(\)); kecheng.setXqh(rs.getString(\)); kecheng.setXf(rs.getString(\)); al.add(kecheng); }

this.conn.close(); return al; }

5.3.5 查看选修课表并进行选修和退选

学生可以在该页面进行查看已有的选修课程，并进行选修。

27

[键入文字]

图5-7 学生未选修课程界面

功能实现主要代码：

//输出未选课程表

public List findKecheng(String stu_id) SQLException {

ArrayList al=new ArrayList(); String sql=\;

this.pstmt=this.conn.prepareStatement(sql); ResultSet rs=this.pstmt.executeQuery(); while(rs.next()) {

Xianxiuke kecheng=new Xianxiuke(); String kch=rs.getString(\); String extrasql=\* from xianke stu_id='\+stu_id+\+kch+\; PreparedStatement

extrapstmt=this.conn.prepareStatement(extrasql);

ResultSet extrars=extrapstmt.executeQuery(); if(!extrars.next()) {

kecheng.setKch(rs.getString(\)); kecheng.setKcm(rs.getString(\)); kecheng.setRkjs(rs.getString(\)); kecheng.setXq(rs.getString(\));

kecheng.setTime(rs.getString(\)); kecheng.setSkjs(rs.getString(\)); al.add(kecheng); } }

this.conn.close(); return al; }

28

throws

where

[键入文字]

图5-8 查看已选课程并退选界面

功能实现主要代码有： //输出已选 课程表

public List findKechenged(String stu_id) throws SQLException {

ArrayList al=new ArrayList();

String sql=\+stu_id+\; this.pstmt=this.conn.prepareStatement(sql); ResultSet rs=this.pstmt.executeQuery(); while(rs.next()) {

Xianxiuke kecheng=new Xianxiuke(); String kch=rs.getString(\); String extrasql=\* from xianxiuke where kch='\+kch+\; PreparedStatement

extrapstmt=this.conn.prepareStatement(extrasql);

ResultSet extrars=extrapstmt.executeQuery(); if(extrars.next()) {

kecheng.setKch(extrars.getString(\)); kecheng.setKcm(extrars.getString(\)); kecheng.setRkjs(extrars.getString(\)); kecheng.setXq(extrars.getString(\));

kecheng.setTime(extrars.getString(\)); kecheng.setSkjs(extrars.getString(\)); al.add(kecheng); } }

this.conn.close(); return al; }

选修与退选课程操作实现主要代码：

//删除学生选课

public boolean deleteXianke(String stu_id,String kch) throws SQLException

29

百度搜索“77cn”或“免费范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读，免费范文网，提供经典小说综合文库学生信息管理系统毕业设计(7)在线全文阅读。