Java/j2Ee Discussions

[lolliman]

[quote name='cherlapalli_jailer' timestamp='1368910793' post='1303770541']
Eclipse : [url="http://www.eclipse.org/downloads/"]http://www.eclipse.org/downloads/[/url]

Tomcat : [url="http://tomcat.apache.org/download-70.cgi"]http://tomcat.apache...download-70.cgi[/url]

MySQL : [url="http://dev.mysql.com/downloads/mysql/"]http://dev.mysql.com/downloads/mysql/[/url]

down load heidisql [url="http://www.heidisql.com/download.php"]http://www.heidisql.com/download.php[/url] ...this is the tool to access MySQL Graphically


NOTE: In order to keep the thread focus on javaa don't reply for the sack of replying..and no sanmanamulu in this thread....jut we focus on the subject....pogadali leka thittali anuunte separate taadu vesi "Maa alludu very good" lo VP(Verity pullayya ) type sanmanam taruvatha cheddamu

if all the four down loads are ready by at least 2 to 3 ppl we can start developing first page login page
[/quote]

Ok done

[innovative]

[quote name='cherlapalli_jailer' timestamp='1368894223' post='1303769708']
both are frame works
and lot of info is available on net with example

still if every one wants to start with that then yes we can do it ...any practice is good practice
[/quote]
[quote name='HannibaL' timestamp='1368907102' post='1303770470']
yaa start cheyyandi vayya edo oka topic or project...
[/quote]
[quote name='cherlapalli_jailer' timestamp='1368910437' post='1303770539']
spring Start Cheddamu ante

all of you down load eclipse latest version / tomcat 7 and MySQL

Spring taruvtha Web Services start cheddamu
[/quote]

ok Springs Start ... !!

[innovative]

[quote name='cherlapalli_jailer' timestamp='1368910793' post='1303770541']
Eclipse : [url="http://www.eclipse.org/downloads/"]http://www.eclipse.org/downloads/[/url]

Tomcat : [url="http://tomcat.apache.org/download-70.cgi"]http://tomcat.apache...download-70.cgi[/url]

MySQL : [url="http://dev.mysql.com/downloads/mysql/"]http://dev.mysql.com/downloads/mysql/[/url]

down load heidisql [url="http://www.heidisql.com/download.php"]http://www.heidisql.com/download.php[/url] ...this is the tool to access MySQL Graphically


NOTE: In order to keep the thread focus on javaa don't reply for the sack of replying..and no sanmanamulu in this thread....jut we focus on the subject....pogadali leka thittali anuunte separate taadu vesi "Maa alludu very good" lo VP(Verity pullayya ) type sanmanam taruvatha cheddamu

if all the four down loads are ready by at least 2 to 3 ppl we can start developing first page login page
[/quote]

Environment already setup iyye vundhi system lo ..
But the only change is I am using oracle DB instead of MySql DB.
And using Sql developer to work with it ..

[innovative]

[quote name='Scrooge' timestamp='1368902808' post='1303770339']
guys.. One advice... B sure at least morethan 2 ppl actively participate in clearing doubts. Otherwise it will b one man thread explaining & no 1 participating.
May b nenu nerchukunta koncham Java
[/quote]

Okay k2s ..

[chinni005]

Hi

[innovative]

[quote name='Chinni_' timestamp='1368915104' post='1303770638']
Hi
[/quote]

Hi hava .. java discussions thread.. u also participate ..

[pavan_613]

Okay !!

[cherlapalli_jailer]

let us start with login page

If oracle is already there then we can use oracle also...i will post MySQL script ..INNO will provide oracle script

For login page to create we need a table called UserCredentials

this is the script for the table in My SQL
Steps: either run the below script or user HeidiSQL to create the table

B4 that first crest the database MYNAME_AFDB

then create table

CREATE TABLE `usercredentials` (
`user_id` VARCHAR(50) NOT NULL DEFAULT '',
`password` VARCHAR(50) NULL DEFAULT NULL,
`email_address` VARCHAR(30) NULL DEFAULT NULL,
`Gender` VARCHAR(10) NULL DEFAULT NULL,
`Location` VARCHAR(100) NULL DEFAULT NULL,
`Interests` VARCHAR(100) NULL DEFAULT NULL,
`Posting_rghts` VARCHAR(1) NULL DEFAULT '1',
`profile_img` VARCHAR(1) NULL DEFAULT '1',
`Posting_images` VARCHAR(1) NULL DEFAULT '0',
`IPAddress` VARCHAR(20) NULL DEFAULT NULL,
`isMod` VARCHAR(1) NULL DEFAULT '0',
`Date_created` VARCHAR(20) NULL DEFAULT NULL,
PRIMARY KEY (`user_id`)
)
COLLATE='latin1_swedish_ci'
ENGINE=InnoDB;

[cherlapalli_jailer]

down load
MYSQL JDBC connector or ORACLE JDBC Connector

[cherlapalli_jailer]

once table is created

i follow following directory structure
C:\work\Projects\Applications --> Eclipse is here
c:\work\Projects\forum\development\workspace --> work space is pointed to this di
so u use ur structure ...but i will refer most the above structure

open eclipse
GOTO Projects
Select DynamicWebProject
TarGetRuntime Select "TOMCAT7"
Browse to the Tomcat Dir

KEEP MODULE version as 3 click next --> next --> then select generate WEB.XML and click finsh

Add lib folder to your project goto workspace
under your project name you will see
bulid
src
webcontent folders

add lib folder and copy the jdbc driver to the lib folder

[cherlapalli_jailer]

Create simple

Login screen with following fields

user_id
password
confirm password
email address

Now in practical (there is an AJAX when user enters user_id and emails --> 2 separate ajax calls so we will add ajax calls at later stage )

we will validate then upon submitting the form for now

no need for security for now

1)Thing to validate on screen is both password and confirm password should be same(java script)

once form is submmited we validate for user_id uniqueness and email_id uniqueness

and posting rights =1
posting images=0
ismod = 0

so this user cannot post images can only post messages
once this screen is successful we have to bring the home page

[cherlapalli_jailer]

AYYO asalu vishayam marchi poyanu
Finance project cheddama leka AFDB ni java cheddama??

Finance project --> little bit tough to do as well as tough to gather user requirements...so it will be advanced.

AFDB total requirements every one of us know

or we can do both in parallel ..

Then Finance --> Banking ??

If Banking ...we can do a web interface for a bank for its customers to login add/manage all the relavent accounts
1)check balance
3) add payee
4) auto or monthly payments to bills
5)statements
6) many other services --> here lot of components are Web Service based

and lot of other features may not be java based also

mor over if any one have user requirments of banking site then it will be very easy to proceed

[innovative]

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 ..

[coca-cola]

soooper ee db lo eenallaki okati panikochdi vachhidhi naaku correct timinggg ki carry on guyss................. ATB guys

[innovative]

Ok .. let me also create table [b][color=#282828][font=helvetica, arial, sans-serif][size=4]usercredentials [/size][/font][/color][/b][color=#282828][font=helvetica, arial, sans-serif][size=4]in Oracle DB. To keep it [/size][/font][/color]consistent[color=#282828][font=helvetica, arial, sans-serif][size=4], I am using the same column names..[/size][/font][/color]

Script for usercredentials table (Oracle DB ) :

[CODE]
CREATE TABLE usercredentials
(
user_id VARCHAR(50) not null,
password VARCHAR(50),
email_address VARCHAR(30),
Gender VARCHAR(10),
Location VARCHAR(100),
Interests VARCHAR(100) ,
Posting_rghts VARCHAR(1),
profile_img VARCHAR(1) ,
Posting_images VARCHAR(1),
IPAddress VARCHAR(20),
isMod VARCHAR(1)
);
[/CODE]