Here we are in our lab again. We are going to extract data from the database tables we created previously. We'll be working in school DAO, remember the constructor created the state and the connection objects before for us. We'll leverage those. We initialize the tables with data. Our first method we want you to create is print students, select tool from students, brings back the results set. The [inaudible] next returns a Boolean as data, it will position itself in the first row in the result set. Then we have some options on how to get data out. We can use getObject using the column NAME that will return an object which we would need to cast, in this case to a string. We can use the getDate on the column NAME here, date of birth. That's going to extract the date from that column and pass it through a converter into a Java SQL date. Well, we could use the index one based. I'm getting the third column in the row there. Now, we're not going to know what that column index is all about using this construct that I've got here. But if I actually explicitly say name, date of birth, and gender, Yes, that is the third column in the result set. Print it out using the expression string, string, string, new line, and repeat and get each row. We do the same thing for courses. Select tool from courses. Brings back the results set, [inaudible] next position, the first row, do we have it? Turns a Boolean if we have it, will consume that row. Here we are just using the getString and of course fees is not a string, it's a double. It needs the converter to put it into a Java double, so to speak. We're using the column headers because I used the Asterix there. Again, we just printed it out. String, string, string, 1.2f is the expression for a double, and then line them up here. Then in our [inaudible] unit, we just add in on the school DAO. We want to execute the print students and the print courses method. Now if I run this school DAO test, if that's not there, you know what to do, you can create a new configuration. You say, "Okay, I want it to be your student project." I want to make sure that's five. That's my test. Apply it. Run it. Let's see what we got. Tables created, tables loaded. This is my student print out, and this is my courses print out. So I'm getting data from all loaded tables.
