@Test
public void testSave() throws Exception {

	SmsContent smsContent = new SmsContent("Test Sms", "13917677725");
	smsContentDAO.save(smsContent);
	
	Statement stat = conn.createStatement();
	ResultSet rs = stat.executeQuery("select * from sms_content where content = 'Test Sms' and mobile = '13917677725'");
	rs.next();
	Assert.assertNotNull(rs.getLong("id"));
	Assert.assertEquals("Test Sms", rs.getString("content"));
	Assert.assertEquals("13917677725", rs.getString("mobile"));
	Assert.assertEquals(5, rs.getInt("priority"));
	Assert.assertNull(rs.getString("type"));
	Assert.assertNotNull(rs.getDate("send_date"));
	Assert.assertEquals(0, rs.getInt("failure"));
	
	if (rs.next()) {
		fail("插入了多条数据!");
	}
}