sqlexplame.java

用自己写的j2me rms引擎写的电话本 功能是： 1.添加 2.查询 3.列出所有的资料 1.修改 2.删除 3.排序

package org.wuhua.fuck.explame;

import org.wuhua.fuck.core.Query;
import org.wuhua.fuck.core.ResultSet;
import org.wuhua.fuck.core.SQLException;
import org.wuhua.fuck.core.impl.QueryBuilder;

/**
 * <b>类名：SqlExplame.java</b> </br> 
 * 编写日期: 2007-2-9 <br/>
 * 程序功能描述：对数据引擎的大部分操作的例子 <br/>
 * Demo: <br/>
 * Bug: <br/>
 * 
 * 程序变更日期 ：<br/> 
 * 变更作者 ：<br/> 
 * 变更说明 ：<br/>
 * 
 * @author wuhua </br> <a href="mailto:[e-mail]">[e-mail]</a>
 */
public class SqlExplame {
	
	/**
	 * 测试用途
	 * @param arg
	 * @throws SQLException
	 */
	public static  void  test() throws SQLException{
		
		//Query q = QueryBuilder.builder("delete wuhua ");
		//q.execute();
		//dropTable();
		try{
			createTable();
		}catch(SQLException s){
			s.printStackTrace();
		}
		//insert();
		//select();
		
		//update();
		//delete();
		//drop();
	}

	private static void drop() throws SQLException {
		Query q = QueryBuilder.builder("drop wuhua  ");
		q.execute();
		
	}

	private static void createTable() throws SQLException {
		Query q = QueryBuilder.builder("create wuhua f_id f_name f_sex ");
		q.execute();
		
	}
	
	private static void insert() throws SQLException{
		Query q = QueryBuilder.builder("insert wuhua f_id f_sex f_name ");
		q.setString("f_id", "21");
		q.setString("f_sex", "男");
		q.setString("f_name", "路是爬出来的");
		q.execute();
	}
	
	private static void select() throws SQLException{
		Query q = QueryBuilder.builder("select wuhua f_name 路是爬出来的 ");
		 
		ResultSet rs = q.executeQuery();
		
		while(rs.next()){
			System.out.println("F_ID=" + rs.getString("f_id"));
			System.out.println("F_SEX=" + rs.getString("f_sex"));
			System.out.println("F_NAME=" + rs.getString("f_name"));
			
		}
	}
	
	private static void delete()throws SQLException{
		Query q = QueryBuilder.builder("delete wuhua f_name 路是爬出来的 ");
		 
		ResultSet rs = q.executeQuery();
		
		 
	}
	
	private static void update()throws SQLException{
		Query q = QueryBuilder.builder("update wuhua f_name 路是爬出来的 ");
		q.setString("f_name", "wuhua");
		q.setString("f_sex", "sex");
		ResultSet rs = q.executeQuery();
		//根新玩再查找
		select();
		 
	}
	
}