MVC.rar_mvc

package model; import java.sql.*; import java.util.*; public class Student extends DBOper{ String sno; String sname; int sage; public Student(){} public Student(String sno,String sname,int sage) { this.sno=sno; this.sname=sname; this.sage=sage; } public ArrayList getStudentByClass(String cno) throws SQLException { ArrayList list=new ArrayList(); ResultSet rs=super.executeQuery("select * from student where cno='"+cno+"'"); try{ while(rs.next()) { String sno=rs.getString(1); String sname=rs.getString(2); int sage=rs.getInt(3); Student stu=new Student(sno,sname,sage); list.add(stu); } }catch(Exception e){} return list; } public int getSage() { return sage; } public void setSage(int sage) { this.sage = sage; } public String getSname() { return sname; } public void setSname(String sname) { this.sname = sname; } public String getSno() { return sno; } public void setSno(String sno) { this.sno = sno; } }