package db;
import java.sql.*;
import java.util.*;


public class DbConnectio {
    //獲取連接方法
    public Connection getCon()
    {
        Connection con=null;
        try
        {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
             con=DriverManager.getConnection("jdbc:odbc:testtable");
        }catch(Exception e)
        {
            e.printStackTrace();
        }
        return con;
    }
    //存放學生的信息
    public Vector getData()
    {
        Connection con=null;
        ResultSet rs=null;
        Statement st=null;
        Vector vd=new Vector();
        String sql="select * from stu";
        con=this.getCon();
        try
        {
             st = con.createStatement();
            rs = st.executeQuery(sql);
            while(rs.next())
            {
                //vx存放一個學生的信息
                Vector vx=new Vector();
                vx.add(rs.getString(1));
                vx.add(rs.getString(2));
                vx.add(rs.getString(3));
                vd.add(vx);
            }
        }catch(Exception e)
        {
            e.printStackTrace();
        }
        finally
        {
            try
            {
                rs.close();
                st.close();
                con.close();
            }catch(Exception e)
            {
                e.printStackTrace();
            }
        }

        return vd;

    }
    //存放表頭信息
    public Vector getColumnNames()
    {
        Vector ve=new Vector();
        ve.add("學號");
        ve.add("姓名");
        ve.add("成績");
        return ve;
    }
    //根據學號刪除數據
    public int delStu(int num)
    {
       Connection con=null;
      // Statement st=null;
       PreparedStatement ps=null;
       int i=0;
       String sql="delete from stu where stuid=?";
       con=this.getCon();
       try
       {
           ps = con.prepareStatement(sql);
           ps.setInt(1,num);
           i=ps.executeUpdate();

       }catch(Exception e)
       {
           e.printStackTrace();
       }
       return i;



    }



}