chat room

[joka badi]

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]

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]

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

user_id 	int(11) 			No Null 	Primary key	auto_increment 	
	username 	varchar(30) 	      no null        unique
	firstname 	varchar(30)             not null
	lastname 	varchar(30)             not null
	password 	varchar(50) 	     not null
	reg_no 	varchar(30) 	     not null
	email 	varchar(100) 	     not null
	gender 	varchar(20) 	     not null
	access_level 	varchar(30) 	not null

Table conversation` (
`c_id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
`user_one` int(11) NOT NULL,
`user_two` int(11) NOT NULL,
`ip` varchar(30) DEFAULT NULL,
`time` int(11) DEFAULT NULL,
FOREIGN KEY (user_one) REFERENCES users(user_id),
FOREIGN KEY (user_two) REFERENCES users(user_id)

table conversation_reply` (
`cr_id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
`reply` text,
`user_id_fk` int(11) NOT NULL,
`ip` varchar(30) NOT NULL,
`time` int(11) NOT NULL,
`c_id_fk` int(11) NOT NULL,
FOREIGN KEY (user_id_fk) REFERENCES users(user_id),
FOREIGN KEY (c_id_fk) REFERENCES conversation(c_id)

...
can you help me plzz.

[Ulf Dittmer]

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]

yes there will be more than one conversation between the users....but can you show me the right way of do this?

[Ulf Dittmer]

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]

ky!!!...i need to list the available inbox but i have problem with complex querying.

[Ulf Dittmer]

What do you have so far (post it), and where are you stuck making progress?