javaee大作业 - 图文(3)

conn.close(); }

}

catch(Exception ex) { System.out.println(ex.getMessage()); } } }

学生实体类：

package cn.bean;

public class Student {

private String id; private String name; private String sex; private int age ; private String collage; private String grade;

public String getId() { }

public void setId(String id) { }

public String getName() { }

public void setName(String name) { }

public String getSex() { }

public void setSex(String sex)

return sex; this.name = name; return name; this.id = id; return id;

}

{ }

public int getAge() { }

public void setAge(int age) { }

public String getCollage() { }

public void setCollage(String collage) { }

public String getGrade() { }

public void setGrade(String grade) { }

public Student(String id, String name, String sex, int age, String { }

public Student() { }

super(); super(); this.id = id; this.name = name; this.sex = sex; this.age = age;

this.collage = collage; this.grade = grade; this.grade = grade; return grade;

this.collage = collage; return collage; this.age = age; return age; this.sex = sex;

collage, String grade)

对数据的增删查改实现的代码：

package cn.dao.impl;

import java.sql.Connection;

import java.sql.PreparedStatement; import java.sql.ResultSet;

import java.sql.SQLException; import java.util.ArrayList; import java.util.List;

import cn.bean.Student; import cn.dao.StudentDao; import cn.dbc.BaseDao;

public class StudentDaoImpl implements StudentDao {

BaseDao bs=new BaseDao(); Connection conn=null;

PreparedStatement pstmt=null; public ArrayList findAll() { // 查看整个学生表 ArrayList AL =new ArrayList(); String sql=\ ResultSet rs=null; conn=bs.getConnection(); try { pstmt=conn.prepareStatement(sql); rs=pstmt.executeQuery(); System.out.println(\学号\姓名\年龄\性别\年级\学院\ while(rs.next()) { Student stu=new Student();

stu.setId(rs.getString(1)); stu.setName(rs.getString(2)); stu.setAge(rs.getInt(3)); stu.setSex(rs.getString(4)); stu.setGrade(rs.getString(5)); stu.setCollage(rs.getString(6)); AL.add(stu); } for(int i=0;i

stu.setId(id); stu.setName(rs.getString(2)); stu.setAge(rs.getInt(3)); stu.setSex(rs.getString(4)); stu.setGrade(rs.getString(5)); stu.setCollage(rs.getString(6)); } System.out.println(stu.getId()+\stu.getGrade()+\ } catch (SQLException e) { // TODO 自动生成的 catch 块 e.printStackTrace(); } finally { bs.closeConn(conn, pstmt, rs); } return stu; } public boolean delStudent(String id)//根据id删除学生信息 { boolean isflag=false; conn=bs.getConnection(); String sql=\ from student where id=? \ try { pstmt=conn.prepareStatement(sql); pstmt.setString(1, id); int num=pstmt.executeUpdate(); if(num>0) { isflag=true; System.out.println(\删除成功！\ System.out.println(\