lolliman Posted May 18, 2013 Author Report Share Posted May 18, 2013 [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 Link to comment Share on other sites More sharing options...
innovative Posted May 18, 2013 Report Share Posted May 18, 2013 [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 ... !! Link to comment Share on other sites More sharing options...
innovative Posted May 18, 2013 Report Share Posted May 18, 2013 [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 .. Link to comment Share on other sites More sharing options...
innovative Posted May 18, 2013 Report Share Posted May 18, 2013 [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 .. Link to comment Share on other sites More sharing options...
chinni005 Posted May 18, 2013 Report Share Posted May 18, 2013 Hi Link to comment Share on other sites More sharing options...
innovative Posted May 18, 2013 Report Share Posted May 18, 2013 [quote name='Chinni_' timestamp='1368915104' post='1303770638'] Hi [/quote] Hi hava .. java discussions thread.. u also participate .. Link to comment Share on other sites More sharing options...
pavan_613 Posted May 18, 2013 Report Share Posted May 18, 2013 Okay !! Link to comment Share on other sites More sharing options...
cherlapalli_jailer Posted May 18, 2013 Report Share Posted May 18, 2013 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; Link to comment Share on other sites More sharing options...
cherlapalli_jailer Posted May 18, 2013 Report Share Posted May 18, 2013 down load MYSQL JDBC connector or ORACLE JDBC Connector Link to comment Share on other sites More sharing options...
cherlapalli_jailer Posted May 19, 2013 Report Share Posted May 19, 2013 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 Link to comment Share on other sites More sharing options...
cherlapalli_jailer Posted May 19, 2013 Report Share Posted May 19, 2013 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 Link to comment Share on other sites More sharing options...
cherlapalli_jailer Posted May 19, 2013 Report Share Posted May 19, 2013 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 Link to comment Share on other sites More sharing options...
innovative Posted May 19, 2013 Report Share Posted May 19, 2013 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 .. Link to comment Share on other sites More sharing options...
coca-cola Posted May 19, 2013 Report Share Posted May 19, 2013 soooper ee db lo eenallaki okati panikochdi vachhidhi naaku correct timinggg ki carry on guyss................. ATB guys Link to comment Share on other sites More sharing options...
innovative Posted May 19, 2013 Report Share Posted May 19, 2013 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] Link to comment Share on other sites More sharing options...
Recommended Posts