使用Junit测试数据库联接
2007-04-13 13:05
在mysql中建立数据库demo 首先建立一个简单的数据库连接类 基于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; } } } 测试数据连接 import junit.framework.TestCase; import java.sql.*; public class TestDb extends TestCase { public TestDb(String name) { super(name); } /* * “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 自动生成 catch 块 e.printStackTrace(); } } |