62,628
社区成员
发帖
与我相关
我的任务
分享class Student
{
private String name;
private String code;
private String sexy;
private String birthday;
private String address;
private String age;
private String grade;
private String major;
Student(String name,String code)
{
this.name=name;
this.code=code;
}
public String getname()
{
return name;
}
public String getcode()
{
return code;
}
public void setsexy(String sexy)
{
this.sexy=sexy;
}
public void setbirthday(String birthday)
{
this.birthday=birthday;
}
public void setage(String age)
{
this.age=age;
}
public void setaddress(String address)
{
this.address=address;
}
public void setgrade(String grade)
{
this.grade=grade;
}
public void setmajor(String major)
{
this.major=major;
}
public String getsexy()
{
return sexy;
}
public String getbirthday()
{
return birthday;
}
public String getage()
{
return age;
}
public String getaddress()
{
return address;
}
public String getgrade()
{
return grade;
}
public String getmajor()
{
return major;
}
public String toString()
{
String information="学生姓名:"+name+"学号:"+code+"年龄:"+age+"出生年月:"+birthday+"家庭地址:"+address+"班级:"+grade+"专业:"+major;
return information;
}
}
class StoreSystem {
public Vector getstudent(Connection con, String sql) {
Vector v = new Vector();
try {
Statement st = con.createStatement();//创建一个 Statement 对象来将 SQL 语句发送到数据库
ResultSet rs = st.executeQuery(sql);//表示数据库结果集的数据表
while (rs.next()) {
String name = rs.getString(1);//数据库结果集的数据赋给相应的变量
String code = rs.getString(2);
String sexy = rs.getString(3);
String age = rs.getString(4);
String address = rs.getString(5);
String birthday = rs.getString(6);
String grade = rs.getString(7);
String major = rs.getString(8);
Student ss = new Student(name, code);
ss.setsexy(sexy);
ss.setmajor(major);
ss.setbirthday(birthday);
ss.setaddress(address);
ss.setage(age);
ss.setgrade(grade);
v.add(ss);