Java/j2Ee Discussions

[innovative]

[quote name='HannibaL' timestamp='1368936341' post='1303771269']
Thank You... neenu kooda ade link choosthunna.....



and Project lo JSF, Richfaces and Maven for deployment use cheddamaa??
[/quote]

Yes we can use Maven ...

ok converted my current project to Maven proj .. [size=4] [/size]

[size=4]Steps to do this in Eclipse :[/size]

[b][size=4]Project --> Right Click --> Configure --> Convert to Maven Project[/size][/b]

[innovative]

Ok .. after converting the proj to Maven Proj .. my current proj structure is :

[CODE]

AFDBProj
|- src
|-JRE System Library
|- Apache Tomcat
|- build
|- classes
|- target
|- test-classes
|- Web Content
|- META-INF
|- WEB-INF
|- login.html
|- pom.xml

[/CODE]

[Water]

[quote name='innovative' timestamp='1368936966' post='1303771297']
Ok .. after converting the proj to Maven Proj .. my current proj structure is :

[CODE]

AFDBProj
|- src
|-JRE System Library
|- Apache Tomcat
|- build
|- classes
|- target
|- test-classes
|- Web Content
|- META-INF
|- WEB-INF
|- login.html
|- pom.xml

[/CODE]
[/quote]
Hi

[nrikittu]

gp

[cherlapalli_jailer]

[quote name='innovative' timestamp='1368932529' post='1303770994']
Finance project (Banking) iythe koncham complex vuntadhi kada adhi start chedham anna..

Anyways .. good start with AFDB proj .. idhi ayyaka we take on that banking proj ..

Can you list out the tables that you are planning for this proj ... so that we can get an idea ..
[/quote]
i will give all possible tables and linking between tables...

By EOD

As well i will keep some options for enhancements like (change of DP name etc...for later user)

once we have all tables and screens(as we all r familiar) it is use to move on.....

Then i will give the controller class and factory pattern skeleton

and we can move on very fast from there..

A Suggestion: For screen lay out etc... you can use AFDB site it self by going to view source copy the sorce code and past it in notepad++ slightly modify then need not spend much on the lay out

go to internet explorer--> temp files and copy images and js file of AFDB

[innovative]

[quote name='cherlapalli_jailer' timestamp='1368970131' post='1303771850']
i will give all possible tables and linking between tables...

By EOD

As well i will keep some options for enhancements like (change of DP name etc...for later user)

once we have all tables and screens(as we all r familiar) it is use to move on.....

Then i will give the controller class and factory pattern skeleton

and we can move on very fast from there..

[b]A Suggestion: For screen lay out etc... you can use AFDB site it self by going to view source copy the sorce code and past it in notepad++ slightly modify then need not spend much on the lay out

go to internet explorer--> temp files and copy images and js file of AFDB[/b]
[/quote]

Bold : Even i thought so .. but ala chedham ani start chesaka chosthe AFDB login page modal dialogue page ... initial screens ki modal dialogue design endhuku le ani i started with simple login screen with the fields u suggested ..

or else how about this .. index page(welcome file) ippudu vunna [b]andhrafriends.com[/b] page vunchi .. login button click cheyyagane modal dialogue page vachela pedhama .. ??

[cherlapalli_jailer]

[quote name='innovative' timestamp='1368971520' post='1303771879']
Bold : Even i thought so .. but ala chedham ani start chesaka chosthe AFDB login page modal dialogue page ... initial screens ki modal dialogue design endhuku le ani i started with simple login screen with the fields u suggested ..

or else how about this .. index page(welcome file) ippudu vunna [b]andhrafriends.com[/b] page vunchi .. login button click cheyyagane modal dialogue page vachela pedhama .. ??
[/quote]
that we will attach to main page @ later stage once we come to topics and posts..

users can come to home page without login and can view posts..

to post or reply they have to login

Since i need to create all the tables related to posts ..replys..etc..i started with login page..

one we get to the topics page then we will link to login/create account page

[roome6]

hi all, Nenu Java & Hadoop Nerchukundam anukutunna, Purely out of Interest. Manchi books or Resources suggest cheyara for Java.,

[cherlapalli_jailer]

Below is the Group Table
From this table we will brings the groups(home page of our web site)
like
Fun section, recipes, H1 Section

i may not use the last 4 columns from this tables but for safe side i am keeping them

i will use that info from the next table

CREATE TABLE `GroupDetails` (
`GROUP_ID` INT(10) NULL,
`Group_Name` VARCHAR(50) NULL,
`Group_Descriptin` VARCHAR(200) NULL,
`User_id` VARCHAR(50) NULL,
`last_repiled_user_id` VARCHAR(50) NULL,
`Created_date` TIMESTAMP NULL,
`Last_repiled_date` TIMESTAMP NULL,
`No_of_replies` BIGINT NULL,
`No_of_views` BIGINT NULL,
PRIMARY KEY (`GROUP_ID`)
)
COLLATE='latin1_swedish_ci'
ENGINE=InnoDB;

select * from GroupDetails then join the count of topics and views from another table

[cherlapalli_jailer]

This is the table to post the topics


CREATE TABLE `TopicDetails` (
`Topic_ID` INT(10) NULL,
`GROUP_ID` INT(10) NULL,
`topic_name` VARCHAR(100) NULL,
`user_id` VARCHAR(100) NULL,
`last_repiled_user_id` VARCHAR(100) NULL,
`created_date` TIMESTAMP NULL,
`last_modified_date` TIMESTAMP NULL,
`No_of_repiles` BIGINT NULL,
`No_of_views` BIGINT NULL,
`isLocked` CHAR(1) NULL,
`isPinned` CHAR(1) NULL,

`isDeleted` CHAR(1) NULL,
PRIMARY KEY (`Topic_ID`)
)
COLLATE='latin1_swedish_ci'
ENGINE=InnoDB;

[cherlapalli_jailer]

This is for replies

CREATE TABLE `PostsDetails` (
`Post_id` INT(10) NULL,
`Topic_id` INT(10) NULL,
`Message` VARCHAR(80000) NULL,
`user_id` VARCHAR(50) NULL,
`Posted_date` TIMESTAMP NULL,
`isDeleted` CHAR(1) NULL,
[color=#282828][font=helvetica, arial, sans-serif]PRIMARY KEY (`Post_ID`)[/font][/color]
)
COLLATE='latin1_swedish_ci'
ENGINE=InnoDB;

[cherlapalli_jailer]

now with the above 4 tables we can create groups, topics and we can post messages

now we need to first define the form classes

in SRC dir
create packages tructures

com.urname.forum,forms

com.urname.forum,Controllers

com.urname.forum,util

com.urname.forum,factory

com.urname.forum,dao

under we content
create resources folder unnder resources create folders 1) js 2)img 3) css
and in WEB_INF dir

create 2 directors
1) jsp
2)lib

[cherlapalli_jailer]

first we develop home page
and create modules(this one we will limit the access to admin @ later stage)
once a module is created the created topic ....login and and post messages

i will provide SQL later

PS: We can do a particular task in many ways... .the way i am doing neither the only way nor the best way

but this one way ...so pl share the thoughts

[cherlapalli_jailer]

Topics created,post and visited statistics/history table will be created later once we able to create topics and posts

[cherlapalli_jailer]

Topics created,post and visited statistics/history table will be created later once we able to create topics and posts