storesystem.java

一个JAVA选人界面

import java.util.Vector;
import java.sql.*;
class storesystem 
{ 
    public Vector getstudent(Connection con,String sql)
    {
        Vector v=new Vector();
        try
        {
            Statement st=con.createStatement();
            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);
            }
            rs.close();
        }
        catch(Exception e)
        {
              e.printStackTrace();
        }
        return v;
    }

    public student getobject(Connection con,String stname)
    {
      student sst=null;
      try
        {
            Statement st=con.createStatement();
            String sql="select * from studentinfo where stname='"+stname+"'";
            ResultSet rs=st.executeQuery(sql);
///通过结果集中的getString方法从数据库中表中提取表字段的数据
///再将提取出来的数据赋值给学生对象。
///最后将学生对象存储到vector数据结构中
            while(rs.next())
            {
                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);
                sst=new student(stname,code);
                sst.setsexy(sexy);
                sst.setmajor(major);
                sst.setbirthday(birthday);
                sst.setaddress(address);
                sst.setage(age);
                sst.setgrade(grade);       
            }
            rs.close();
           
        }
        catch(Exception e)
        {
              e.printStackTrace();
        }
       return sst;
    }
///通过设置数据库的URL,密码，用户名来建立与数据库的连接
    public Connection getConnection()
    {
        Connection con=null;
        String url1="jdbc:odbc:schoolmanage";
        String username="";
        String password="";
        try
        {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            con=DriverManager.getConnection(url1,username,password);
        }
        catch(SQLException e){e.printStackTrace();
        }
        catch(ClassNotFoundException ex){ex.printStackTrace();
        }
        return con;
    } 
}