菜鸟求教sqlite空指针...

丿渎灬魂 2011-11-01 04:27:32

logcat 打印：



public static final String TAG = "MessageDB";



	// 表名

	public static final String TB_NAME = "IMMessage";

	// 创建表语句

	private static final String CREAT_TABLE = "create table if not EXISTS " + TB_NAME + " (" + UserMessage.ID + " integer primary key AUTOINCREMENT, " + UserMessage.SEND_SCREEN_NAME + " Text," + UserMessage.TO_SCREEN_NAME + " Text," + UserMessage.MESSAGE_CONTENT + " Text," + UserMessage.CREATDATE + " Date," + UserMessage.MSGIDENT + " Text)";



	// 数据库名称

	private static final String DB_NMAE = "sinawbq.db";

	// 当前版本

	private static final int DB_VERSION = 1;



	/**

	 * @param context

	 * @param name

	 * @param factory

	 * @param version

	 */

	public MessageDB(Context context)

	{

		super(context, DB_NMAE, null, DB_VERSION);

		// TODO Auto-generated constructor stub

	}



	@Override

	public void onCreate(SQLiteDatabase db)

	{

		db.execSQL(CREAT_TABLE);

		Log.d("DB-----onCreate", "onCreate");

	}



	/**

	 * 执行更新 oldVersion 老版本号 newVersio 新版本号 onUpgrade 创建方法

	 * 在用户执行调用获取用户数据库管理时例就已经执行

	 * 

	 */

	@Override

	public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion)

	{

		// TODO Auto-generated method stub

		db.execSQL("DROP TABLE IF EXISTS " + TB_NAME);

		onCreate(db);

	}



	@Override

	public void onOpen(SQLiteDatabase db)

	{

		// TODO Auto-generated method stub

		super.onOpen(db);

	}



}





public class MessageDao

{ 

	 private final static String TAG="MessageDao-------------->";

	 

	 

	 

     private MessageDB msgdb;

	 private SQLiteDatabase db; 

	 public MessageDao(Context context)

	       { 

	    	    msgdb=new MessageDB(context); 

	    	    db=msgdb.getWritableDatabase();

	    	  }

	   

	    

	        public void closeAll()

	        {

	        	db.close();

	        	msgdb.close();

	        }

	      /**

	      * 表中添加记录

	      * @param um

	      * @return

	      */

	     public Long addMessage(UserMessage um)

	     {

	    	 

	    	  ContentValues cv=new ContentValues();

	    	  cv.put(UserMessage.SEND_SCREEN_NAME, um.getSend_screen_name());

	    	  cv.put(UserMessage.TO_SCREEN_NAME, um.getTo_screen_name());

	    	  cv.put(UserMessage.MESSAGE_CONTENT, um.getMessage_content());

	    	  cv.put(UserMessage.CREATDATE, um.getCreatDate().toString());

	    	  cv.put(UserMessage.MSGIDENT, um.getMsgident());

	    	  Long insertMessage=db.insert(MessageDB.TB_NAME, null, cv); 

	    	  Log.d(TAG, ">----addMessage");

	    	  return insertMessage;

	     }



Context context;  



class messageContenListenter implements OnEditorActionListener

	{



		public boolean onEditorAction(TextView v, int actionId, KeyEvent event)

		{

			// TODO Auto-generated method stub

			if (actionId == EditorInfo.IME_ACTION_SEND)

			{

				// 消息唯一标识，0为自己发的消息，1为自己收的消息

				String messageContent = message_content.getText().toString();

				message_content.setText("");

				mDao = new MessageDao(context);

				UserMessage um = new UserMessage();

				um.setSend_screen_name(fromuserid);

				um.setTo_screen_name(touserid);

				um.setMessage_content(messageContent);

				Date dateNow = new Date(System.currentTimeMillis());

				um.setCreatDate(dateNow);

				um.setMsgident("0");

				mDao.addMessage(um);



				Log.d("messageContent-------------->", messageContent);



			}

			return false;

		}



	}