• Post Reply Bookmark Topic Watch Topic
  • New Topic

chat room  RSS feed

 
joka badi
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi everyone!!..am working with java project concern chat room...am not much good in java so can anyone help me how to start code because have prepared the database with 3 table(registration(user_id_pk),conversation(c_id_pk),conversation_reply(r_id_pk))...so am asking for assistance please.
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 37507
554
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You've create a database table. You could write the database access layer as the next step. What methods do you need? Adding data to the database and selecting data from the database spring to mind. Try using JDBC to write some code. Or ask a more specific question here.
 
joka badi
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
have already put the data to database and what are need is query which will help me to list available inbox or a complete code for listing the inbox...And below is my table and attributes.
Table for registration




...
can you help me plzz.
 
Ulf Dittmer
Rancher
Posts: 42972
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What seems to be missing is a field that keeps track of which messages have already been seen by the user - maybe a boolean in the conversation_reply table.

I don't understand why the conversation table is necessary. Could there be more than one conversation between two users? Not even Skype has that. You could have a "from" and a "to" userID FK in the message table instead.

...or a complete code for listing the inbox...

No, giving out code is not how this site works. But we'll help you write the code yourself.
 
joka badi
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
yes there will be more than one conversation between the users....but can you show me the right way of do this?
 
Ulf Dittmer
Rancher
Posts: 42972
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Tell us about what you're unsure, and we can address specific points. As it is, we know too little about the project to make general comments.
 
joka badi
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
ky!!!...i need to list the available inbox but i have problem with complex querying.
 
Ulf Dittmer
Rancher
Posts: 42972
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What do you have so far (post it), and where are you stuck making progress?
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!