2023.11.4每日总结

public boolean ModifyGrades(String stuid,int grade)throws Exception
{
    String sql="update examination set grade=? where stuid=?";
    PreparedStatement pre = connect.prepareStatement(sql);
    pre.setInt(1,grade);
    pre.setString(2,stuid);
    int count=pre.executeUpdate();
    pre.close();
    if(count>=1)
        return true;
    else
        return false;
}
public examination[] EveryLesson(String examname)throws Exception
{
    String sql="select * from examination where examname = ?";
    PreparedStatement pre = connect.prepareStatement(sql,ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);//改成可以改位置
    pre.setString(1,examname);
    ResultSet rs = pre.executeQuery();
    rs.last();//光标移到最后
    int rowCount=rs.getRow();//当前行是第几行
    rs.beforeFirst();//移回去
    examination[] examinations=new examination[rowCount];
    int i=0;
    while(rs.next())
    {
        examinations[i]=new examination();
        examinations[i].stuid=rs.getString("stuid");
        examinations[i].examname=rs.getString("examname");
        examinations[i].grade=rs.getInt("grade");
        i++;
    }
    pre.close();
    return examinations;
}
public teacher oneTeacher(String teaid)throws Exception
{
    teacher oneTeacher=new teacher();
    String sql="select * from teacher where teaid = ?";
    PreparedStatement pre = connect.prepareStatement(sql);
    pre.setString(1,teaid);
    ResultSet resultSet= pre.executeQuery();
    while(resultSet.next())
    {
        oneTeacher.teaid=resultSet.getString("teaid");
        oneTeacher.teaname=resultSet.getString("teaname");
        oneTeacher.tealesson1=resultSet.getString("tealesson1");
        oneTeacher.tealesson2=resultSet.getString("tealesson2");
        oneTeacher.tealesson3=resultSet.getString("tealesson3");
        oneTeacher.teapwd=resultSet.getString("teapwd");
    }
    pre.close();
    return oneTeacher;
}
public boolean ModifyStudent(String stuid,String stuname,String stuyear,String stuclass,String stupwd)throws Exception
{
    String sql="update student set stuname=?,stuyear=?,stuclass=?,stupwd=? where stuid=?";
    PreparedStatement pre = connect.prepareStatement(sql);
    pre.setString(1,stuname);
    pre.setString(2,stuyear);
    pre.setString(3,stuclass);
    pre.setString(4,stupwd);
    pre.setString(5,stuid);
    int count=pre.executeUpdate();
    pre.close();
    if(count>=1)
        return true;
    else
        return false;
}
public student oneStudent(String stuid)throws Exception
{
        student oneStudent=new student();
        String sql="select * from student where stuid = ?";
        PreparedStatement pre = connect.prepareStatement(sql);
        pre.setString(1,stuid);
        ResultSet resultSet= pre.executeQuery();
        while(resultSet.next())
        {
            oneStudent.stuid=resultSet.getString("stuid");
            oneStudent.stuname=resultSet.getString("stuname");
            oneStudent.stuclass=resultSet.getString("stuclass");
            oneStudent.stupwd=resultSet.getString("stupwd");
            oneStudent.stuyear=resultSet.getString("stuyear");
        }
        pre.close();
        return oneStudent;
}
public examination[] MyGrade(String stuid)throws Exception
{
    String sql="select * from examination where stuid = ?";
    PreparedStatement pre = connect.prepareStatement(sql,ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);//改成可以改位置
    pre.setString(1,stuid);
    ResultSet rs = pre.executeQuery();
    rs.last();//光标移到最后
    int rowCount=rs.getRow();//当前行是第几行
    rs.beforeFirst();//移回去
    examination[] examinations=new examination[rowCount];
    int i=0;
    while(rs.next())
    {
        examinations[i]=new examination();
        examinations[i].stuid=rs.getString("stuid");
        examinations[i].examname=rs.getString("examname");
        examinations[i].grade=rs.getInt("grade");
        i++;
    }
    pre.close();
    return examinations;
}