Java and SQL Integration

Nicholas Mulvihill will be presenting code that is used in Java to allow a program to talk to a SQL database.

Here is the Java class API that Oracle put together for SQL.

To setup a Java class to talk to a SQL database you must have credentials for the DBMS and know the driver for the DB. You can generally talk to your DB administrator for this information if you do not know it. For this demonstration, I will use the Department of Computer Science Oracle Database driver, since I know it and how to connect to it.

A general overview of how to connect to the Database:

• Establish a connection to the Database.
• DriverManager.getConnection(<driver>,<username>,<password>)
• Create a Statement and execute a Query.
• Capture the ResultSet and process returned data
• Close the connection

In class I will show you the details of the above steps and how to process the ResultSet. 

Tech Briefing: Application Testing

Austin March is presenting a powerpoint slide on application testing based on his experience.  It is posted on D2L under Assignments and below.

There is good tutorial by Guru 99 (http://www.guru99.com/) - which offers a very large tutorial library.   Here is the tutorial on the Application Testing Tutorial: Methodology, Tools, Test Plan, Best Practice.

As Austin will explain,

Application Testing is a set of activities conducted through scripts with the motive of finding errors in software. It deals with tests for the entire application.  It helps to enhance the quality of your applications while reducing costs, maximizing ROI, and saving development time.

Application testing can be done in various categories like GUI, functionality, database (backend), load test, etc. 

For Application Testing, the testing lifecycles involve various phases which include requirement analysis, test planning, test analysis, test design, test execution & bug reporting, etc.

Of course Austin has much more to say on this subject!  Here is a link to his presentation.

Austin mentioned IBM Rational software he used to do automated testing.  IBM provides automated testing solutions for multi-platform applications, including regression testing, integration technologies, performance testing and scalability testing.  Here is a link to their automated testing products.  If you look at the IBM rational software suite,  it is all about continuous development, agile and lean, and DevOps.  We may visit this again.

How to Safely Clean Your Dirty, Disgusting Smartphone

I figure you should all read this.  Not earth-shattering, but given there is a flu outbreak, one of the main causes of sickness is germs.  So wash your hands often AND clean your dirty, disgusting smartphone.  It only has 10x more germs per square inch than a public toilet seat, which probably gets cleaned more often than your phone!

Watch the video attached to the link on how to do this. 

Team Blog URLs & First Post

Please comment below with your team name, members, and your team's URLs from the group blogs you created last week, so I can post them on the blog roll for this class.

As you begin to redesign your blog, and search for a client, create a first post on your group blog that is a brief description of your client and some idea of the project you plan to investigate.  You can add more detail about the client and what you will investigate, but keep it to a paragraph for now.
________________

Please remember to add Dr. Suzie and TA, Rhythm Vij to your blog.   To do so, go to Design/Settings/Basic.  Then Add author.  In the blank, add spweisband@gmail.com and rhythm@email.arizona.edu (separated by commas).

Team "Five on Fourth"

Team "Five on Fourth" contains: Kelsey Bushell, Caroline Koss, Hyunhee Hong, Sydelle Harrison, & Insia Noor