public class ExcuteDao {
    Connection conn = null;
    Statement stmt = null;
    ResultSet rs = null;
    String sql;
    String username;
    String password;

    public void QueryByID(int testId) throws Exception {
        conn = MysqlConnect.getConnection();
        stmt = (Statement) conn.createStatement();
        sql = "select * from testdata where testid = '"+testId+"'";
        rs = stmt.executeQuery(sql);
        while (rs.next()){
            username = rs.getString("username");
            password = rs.getString("password");
        }

    }
    public String getUsername(){
        return username;
    }
    public String getPassword(){
        return password;
    }
}