测试数据库的连接

最新推荐文章于 2024-12-27 16:35:58 发布

转载最新推荐文章于 2024-12-27 16:35:58 发布 · 706 阅读

1 篇文章

订阅专栏

import java.util.Iterator;
import java.util.List;
import java.util.Map.Entry;
import java.util.Set;

import com.jfinal.plugin.activerecord.ActiveRecordPlugin;
import com.jfinal.plugin.activerecord.dialect.OracleDialect;
import com.jfinal.plugin.c3p0.C3p0Plugin;
import com.jin.calendar.model.User;


public class test {

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub
		 C3p0Plugin cp = new C3p0Plugin("jdbc:oracle:thin:@localhost:1521:orcl", "scott", "Oracle11g");
		 // 配置Oracle驱动
	        cp.setDriverClass("oracle.jdbc.driver.OracleDriver");
	        ActiveRecordPlugin arp = new ActiveRecordPlugin(cp);
	        // 配置Oracle方言
	        arp.setDialect(new OracleDialect());		 
	        cp.start();
	        arp.start();
	        arp.addMapping("user3", User.class);
	        List<User> drivers = User.dao.find("select * from user3");
	        
	        for(User d:drivers){
	            Set<Entry<String, Object>> set = d.getAttrsEntrySet();
	            Iterator<Entry<String, Object>> it = set.iterator();
	            System.out.println("=================");
	            while(it.hasNext()){
	                Entry<String, Object> next = it.next();
	                System.out.println(next.getKey()+":"+next.getValue());
	            }
	            System.out.println("=================");
	        }
	        
	  

	}

}

最后的结果

=================
NAME:jin
TEL:15102751852
ID:1
EMAIL:jins321@gmail.com
CREATE_DATE:2014-04-26 22:07:37.0
PASSWORD:123
LOGINNAME:jin
=================
=================
NAME:jie
TEL:15105201314
ID:2
EMAIL:5201314@qq.com
CREATE_DATE:2014-04-26 22:07:37.0
PASSWORD:123
LOGINNAME:jie
=================