package com.zkdz.test;

import java.sql.ResultSet;
import java.sql.SQLException;

import com.zkdz.core.ConnDB;

import junit.framework.TestCase;

public class TestConnDB extends TestCase {
	
	public void testconn(){
		ConnDB db=new ConnDB();
		db.getConnection();
		ResultSet rs=db.executeQuary("select * from userinfo");
		try {
			while(rs.next()){
				System.out.println(rs.getInt(1));
				System.out.println(rs.getString(2));
				System.out.println(rs.getString(3));
			}
		} catch (SQLException e) {
			System.out.println("迭代錯誤！");
		}
		//db.executeUpdate("delete from  tb_manager where id=5");
		//db.executeUpdate("insert into tb_manager values(7,'love','love')");
		db.close();
	}
	
	

}