stu_management.java

在线判作业系统

/*
 * Stu_management.java
 *
 * Created on 2007年3月27日, 下午6:55
 *
 * To change this template, choose Tools | Template Manager
 * and open the template in the editor.
 */

package teachmanage.Student_management;

import teachmanage.DB_management.DB;
import teachmanage.Entities.Student;
import java.sql.*;
import java.util.Vector;

/**
 *
 * @author CASE
 */
public class Stu_management
{

      /** Creates a new instance of Stu_management */
      public Stu_management()
      {
      }


      public Vector SearchStudent(String sno)
      {
            String sql = "SELECT * FROM Student where Sno = '"+sno+"'";
            DB db = new DB();
            ResultSet rs = db.search(sql);
            Vector vecstr = new Vector();
            try
            {
                  while(rs.next())
                  {
                        Student stu=new Student();
                        stu.Set_Instance(rs);
                        vecstr.add(stu);
                  }
                  db.dbclose();
            }
            catch(SQLException e)
            {
                  e.printStackTrace();
            }
            return vecstr;

      }
     public static void main(String[] args)
     {
           Student stu=new Student();

     }

}