Changes from Version 1 of test/dbunit/TestDbUnit

작성자:

anonymous (IP: 221.150.127.103)

날짜/시간:

2013-12-22 PM 11:32:53 (12 년 전)

설명:

--

test/dbunit/TestDbUnit

@@ +1 @@
+
+{{{
+public class TestDbUnit extends DatabaseTestCase{
+        public static final String TABLE_LOGIN = "login";
+        private FlatXmlDataSet loadedDataSet;
+
+        protected IDatabaseConnection getConnection() throws Exception{
+                Class.forName("com.mysql.jdbc.Driver");
+                Connection jdbcConnection = DriverManager.getConnection("jdbc:mysql://locatlhost:3306");
+                return new DatabaseConnection(jdbcConnection);
+        }
+
+        protected IDataSet getDataSet() throws Exception{
+                loadedDataSet = new FlatXmlDataSet(this.getClass().getResourceAsStream("input.xml"));
+                return loadedDataSet;
+        }
+
+        public void testCheckLoginDataLoaded() throws Exception{
+                assertNotNull(loadedDataSet);
+                int rowCount = loadedDataSet.getTable(TABLE_LOGIN).getRowCount();
+                assertEquals(3,rowCount);
+        }
+}
+
+<dataset>
+        <login id="1" empcode="E005" loginname="chandan" password="chandan" loginenabled="y"/>
+        <login id="2" empcode="E006" loginname="chandan" password="chandan" loginenabled="y"/>
+        <login id="3" empcode="E007" loginname="chandan" password="chandan" loginenabled="y"/>
+</dataset>
+}}}