Using JUnit to test database joins

Using JUnit test database joins 2007-04-13 13:05

Create a database demo in MySQL First, establish a simple database connection class based on MySQL Conmysql.java Import java.sql.Connection; Import Java.sql.DriverManager; public class Conmysql { Public Conmysql () { } PRIVATE Connection conn = null; Private String URL = "Jdbc:mysql://localhost:3306/demo"; Private String user = "root"; Public Connection Conn () { try { Class.forName ("Org.gjt.mm.mysql.Driver"). newinstance (); conn = drivermanager.getconnection (URL, user, ""); Return conn; catch (Exception e) { E.printstacktrace (); return null; } } } Test data connection Import Junit.framework.TestCase; Import java.sql.*; public class TestDB extends TestCase { Public TestDB (String name) { Super (name); } /* * Test method for "Com.test.ConMysql.ConMysql ()" */ public void Testconmysql () { Conmysql con = new Conmysql (); Connection C = Con.conn (); try { Statement stmt = C.createstatement (); String sql = "INSERT into customer values (' 1 ', ' a ', ' M ', ' nn ')"; Stmt.executeupdate (SQL); Assertnotnull (Stmt.executequery ("SELECT * from Customer")); Assertequals (1, Stmt.executequery ("SELECT count (*) from Customer")); catch (SQLException e) { TODO automatically generate catch blocks E.printstacktrace (); } }