• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Devaka Cooray
  • Knute Snortum
  • Paul Clapham
  • Tim Cooke
Sheriffs:
  • Liutauras Vilda
  • Jeanne Boyarsky
  • Bear Bibeault
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Ron McLeod
  • Piet Souris
  • Frits Walraven
Bartenders:
  • Ganesh Patekar
  • Tim Holloway
  • salvin francis

chat room  RSS feed

 
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.
 
author & internet detective
Posts: 39285
727
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.
 
Rancher
Posts: 43009
76
  • 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: 43009
76
  • 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: 43009
76
  • 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?
 
You didn't tell me he was so big. Unlike this tiny ad:
how do I do my own kindle-like thing - without amazon
https://coderanch.com/t/711421/engineering/kindle-amazon
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!