testdao.java

实现一个简易的租房系统

package com.wepull.zf.dao.test;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;

import com.wepull.zf.dao.IFWXXDAO;
import com.wepull.zf.dao.jdbcImpl.FWXXDAO;
import com.wepull.zf.entity.FWXX;

import junit.framework.TestCase;

public class TestDAO extends TestCase {

	public void testFindAll(){
		try {
			Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
			Connection con=DriverManager.getConnection("jdbc:sqlserver://192.168.1.111:1433;DatabaseName=zf","sa","123");
			System.out.print(con.isClosed());
			IFWXXDAO dao=new FWXXDAO(con);
			List<FWXX> houses=new ArrayList<FWXX>();
//			houses=dao.findAll(2, 3);
			assertTrue(houses.size()>0);
//			Iterator<FWXX> it=houses.iterator();
//			while(it.hasNext()){
//				System.out.println(houses);
//			}
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	public void testDel(){
		try {
			Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
			Connection con=DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=zf","sa","123");
			IFWXXDAO dao=new FWXXDAO(con);
			boolean flag=dao.del(81);
			assertTrue(flag);
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	public void testSave(){
		try {
			Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
			Connection con=DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=zf","sa","123");
			IFWXXDAO dao=new FWXXDAO(con);
			FWXX dto=new FWXX();
			dto.setDate("2009-10");
			dto.setFwid(10);
			dto.setFwxx("alskdfjsdk");
			dto.setJdid(2);
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
}