service.java

J2ME的源码！我以前学习J2ME的源码哈！非常适合初学者

/********************************************************************
 * 项目名称				：<b>j2me学习</b>			<br/>
 * 
 * Copyright 2005-2006 Wuhua. All rights reserved
 ********************************************************************/
package org.wuhua.photobook.service;

import org.wuhua.fuck.DataBaseServer;
import org.wuhua.fuck.core.Query;
import org.wuhua.fuck.core.ResultSet;
import org.wuhua.fuck.core.RmsAccessException;
import org.wuhua.fuck.core.SQLException;
import org.wuhua.fuck.core.impl.QueryBuilder;
import org.wuhua.photobook.model.Friend;

/**
 * <b>类名：Service.java</b> </br> 
 * 编写日期: 2007-3-4 <br/>
 * 程序功能描述： <br/>
 * Demo: <br/>
 * Bug: <br/>
 * 
 * 程序变更日期 ：<br/> 
 * 变更作者 ：<br/> 
 * 变更说明 ：<br/>
 * 
 * @author wuhua </br> <a href="mailto:[e-mail]">[e-mail]</a>
 */
public class Service {
	
	private static Service service;
	
	private Service(){
		try {
			createFriendTable();
		} catch (SQLException e) {			 
			e.printStackTrace();
		}
	}
	
	public final static void open(){
		try {
			DataBaseServer.start();
		} catch (RmsAccessException e) {
			e.printStackTrace();
		}
		
	}
	
	public final static Service getInstance(){
		if(service == null){
			service = new Service();
		}
		return service;
	}
	
	
	public Friend addFriend(Friend friend) throws SQLException{
		Query q = QueryBuilder.builder("insert :friend :f_name :f_mobile :f_email: f_address ");
		q.setString("f_name",friend.getName() );
		q.setString("f_mobile", friend.getPhone());
		q.setString("f_email", friend.getEmail());
		q.setString("f_address", friend.getAddress());
		q.execute();
		return friend;
	}
	
	/*
	 * 有个内部超奇怪的问题,为什么会插入四个参数的时候会出现表名加一些特殊的符合
	 * @throws SQLException
	 */
	private void createFriendTable() throws SQLException {
		Query q = QueryBuilder.builder("create :friend: f_name :f_mobile :f_email :f_address");
		q.execute();		
	}
	
	public ResultSet find(String sql){
		Query q;
		ResultSet rs = null;
		try {
			q = QueryBuilder.builder(sql);
			rs = q.executeQuery();
			return rs;
		} catch (SQLException e) {
			e.printStackTrace();
		}
	
		return rs;
		 
		
		
	  
	}
}