User Manual
Contents
1. change password of self user Note Only level admin just create new edit and delete account Admin only delete account but not change password of account Every user or admin only can change themselves s password Contact Management System List Account About Us LS seame f Admin A pue Yooo A Tuan fA tuanbs It o G EE EE J Change Your Password B nS Ee Change Your Password x User Name Old Password New Password Confirm New Password2. System UserName admin Password eeeeee User Manual 1 Launch After connect successful a form login appear Default UserName admin Password 123456 Application has 4 tabs List Sale Report and System A Tab List Tab List has 4 sub tab List Customer List Category Customer List Product and List Category Product List Customer store list of customer You can search for any customers according to their names by input any character in filed search table will show peoples who has first name or last name begin with inputed character EEX List Category Product S ID amg Birthda Address Email Home Phonel Work Phong Cell Phone Category C 2 Van uan 1985 09 23 33 Quan s jag amailc 08385610 12323456 O9OT737755 F y 000000 B lLeVanA 1985 09 23 Q3 Le Van A yahoo c 34567690 33245678 4445456567R N T TanyanB 1986 10 16 9Pnu Nhu B yahoo c 34534567 34333456 45566FF7T88F 8 Nguyen apc 1988 09 01 G Tan Binh c wahoo c 67467864 43567899 4344455656 F 22 WanfienDung 1965 01 01 G Ba Dinh dung yah 12349875 76543345 ouer ME You can search for any customers by combining both name and the customer s category BEE List Customer List Category Customer List Product List Category Product amp Gan Category ID Hame Birthda Address Email Home Phone Work Phone Cell Phone atego C 7 Duongan Tuan 1985 09 23 33 Quan s laf amailr 08385810 1239239458 090
3. 77377 RR EU 00O BC FT Tman anf 1986 10 16 O Phu Nhu B yahoo c 34534567 34333456 455667778 B NauyefiamC 1988 09 01 IO Tan Binh c wahoo c 1874678964 43567899 Et You can create new customer edit customer and delete customer by click button new edit delete When you click button New a Dialog name Create New Customer appear Customer only saved when you input information correctly E g February is not the day 30 and only leap year just has the day 29 P Create New Customer Name Duong Van Tuan Date Of Birth C g85 2 30 vyyy mm dd Address 33 Quan Su P11 211 Email dunondvantuanBaiwahono taFm Home Phone 558115 B ell U9UT 2 P54 Information Home Page Category Fri Remarks Note only users who have level admin can delete customer List Category Customer Have 3 category customers by default Client Friend and Relative And discount correspond them is 0 2 and 3 You can add new edit or delete category customer NOTICE If you delete any category customer then all customers who belongs this category will be delete too Contact Management System List Customer List Category Customer List Product List Category Product List Category Customer SE Customer Code Catego Customer Namet Discount t Client Feng H Relative D m N Fa Create New Category Customer Eg Category Code Ir Category Name Discount List Product an
4. Personal Manager Application User Guide Installation Guide I System Requirement a Hardware Pentium III or higher with 1G of RAM b Software Java SE 6 SQL Server 2005 or higher NetBean 6 0 II Launch 1 Create database ContactManagementSystem by double click file SQLQuery in folder and execute commands of file SQLQuery to create database Or you can use Example database in source code folder and attach it in your SQL Server A Attach Database KL a ap Microsoft SOL Server Management Studio File Edt View Tools Window Community Help D bject Explorer Connect SU m A e E L TUANMAP SQL Server 9 0 1399 sal ES l E Security New Database Databases fg Server I Atach TU amp NMAF Databases 13 lems 9 Replical 9 Manage 9 Notfical 2o Mame H SOLSe Refresh CE System Databases T Database Snapshots T Adventureworks T Adventurew orks IW T Contacts T ContactsM anagementSystem Ly LE Patents nfoSystem T Demo T kidzzone School KidsZoneSchoal T Reports erver T Reports erver T emplb T Studentki anager Restore Database Restore Files and Filegroups Then click button Add and you choose path Source Code Example Database ContactsManagementSystem_log B Or you can create database Double click file Source Code SQLQuery1 Then select all commands and click Execute Microsoft SQL S
5. ce Quanti O Fea O e Biore 000 3 Verg deo tal hoo Be Kem Chong Nang Sunp 00 00 Television 2000 Go Ba C Tab Report This tab has 2 sub tab Revenue by customer and Revenue by product Revenue By Customer You can view revenue by specific date You can view revenue by customer corresponding all or each of category customer With each of customer you can view him her buy most what products by clicking on one customer in the first table then details will shown in the second table Contact Management System Revenue By Customer Revenue By Product Date From rg E was KE wn lt ome S a ET ve ES oo L NC hanp Cent 17 Te NS Hung Thuan Pen D n Se ag reuse Eed ES So Nguyen Hu Poe Client E 18 ester Fem OM aa ma mmm d S Customer Mame Category Customer dh Tual Money lt hone Duong Ngoc Huynh elaine FOAD o System m rien Products Bought Most ao on Product Name Category Product G C ewent O EE Ring Deo Mat Jewellery EL O ER Television ewellery o MBI o O Dong Ho Casino beweley 2 o o KemBiore Cosmetiess M o o NuocHoa Cosmetics Al e O ai aam e EE Revenue By Product You can view revenue by specific date You can view revenue by product corresponding all or each of category product D Tab System This tab used to view list account create new account and edit account by level admin and
6. d List Category Product The same List Customer and List Category Customer J contact zeessen oystem wg ox Admin List Customer List Category Customer List Product List Category Product Product ID Product Name Category Product Price hi 1 Kem Biore E 1000 2000 500 3 Bonmoilipiee e oo 5000 B In Deo MaL MN 2000 Fo KemlamTrangDaPondJe NM H Television H oo 8 No Hot Create New Product E Product ID TE Product Name me EI am em jo BEd conaca Management System List Customer List Category Customer List Product List Category Product List Category Product a Category Product Code Category Product Name LC Cosmetics So Meweliery Create New Category Product Eg Category Name B Tab Sale Tab Sale has 2 sub tab Sale Product and Bill Detail Sale Product This tab used to buy product to customer Function search is the same Tab List This tab will create new bill automatically when you finish sale You can sale more products in one bill each product you can choose more quantity To sale you add products into bill by choosing product in table and click button Add All bought products will be shown in the table named Product Detail Total price of bought products will be shown in red field Click button Remove to remove any one bought product You can change customer with bought products in bill and Total Price will be changed correspond discount of change
7. d customer Finally to save this bill you have to enough information of bill like name of customer in filed name of bought product in third table Note You choose customer and product by clicking on the table WT Contact Management System Cy Sale Report oy System Bill Detail Olai Sale Product Bill Detail Bill No 22 Created Date 2009 04 20 Customer Name Ngoc Anh Category ID Mame Birthda Address Email Home Phone Work Phone Cell 3 Nguyen Hu 1989 02 24 Thu Duc huuphuoc 1234567 09097263 08091 D fLeWanA 1985 09 23 O3Le Van A wahoo c 34567890 33245678 4445 4 een ne Product ID Product Name Category Product Price i 1 Kem Biore K 1000 Ee ee ee ae N You can view the list of bill by specific date choose date from date to and click button View or all date check into checkbox All Date You can search any bill in table and delete bill Only user has level admin can delete You can view details of bill in second table by clicking on one bill in first table L Contact Management System Sale Product Bill Detail Day DREI Month nls Year Report List Bill System Bill No Created Di Date Bill Customer ID Customer Name Discount se Mone Sept 02 14 a o 7 Yan Tuan Gesig Myhanh 230 EE nen EE EE E Duong Ngoc Huynh 2 EE Information 009 04 16 yp EE EE Product Name Pri
8. erwer Management studio TUANMAP master GL Duer sol iO INSERT INTO Cat Customer CatCustCode CatCustName Discount EE ebe GG INSEET INTO cat ah Eer NG EN IE EE EIE NE 1 slal DEEN Et Discount V ALLURS LT CT Client EE GG INSEET INTO cat Product 1 al 1 te Le CatProMame det ive AT MES LT EL Cosmetics ed Kee GG INSERT INTO Cat Product CatProcCode CatProName Active KH S T QT Jewellery EH GO INSERT INTO Account UserName Password VALUES Admin IATE i G KO K lt gt ER Connected TUAHMAP AORTM salEi master 00 00 00 Orows 2 After attach or create database execute file Exec eProject_Tuan jar in folder Source Code Appear form connect to database Then enter your Server Name Default localhost UserName default sa password database default ContactManagementSystem and port default 1433 EE Connect to Server Microsoft AR Windows Server System SQL Server 2005 Server type Database Engine wi Server name Authentication SQL Server Authentication ka Login sa Password C Remember password P Connect Database Connect To Database Server Name UserName Password Database Conta ctsManagementSysterm comet ea NOTE 1 If after connect appear following Dialog P Connect Database Connect To Database UserName SOLEXception occured Password Database Conta ctsManagementSystem mee ee This dialog appear because of your
9. port in SQL Server not 1433 To resolve it please do following steps a Click Start Microsoft SQL Server 2005 Configuration Tools SQL Server Configuration Manager Then select Protocols of MSSQLServer right click TCP IP and choose Properties Then input 1433 in TCP Port choose Apply OK Er GUL Server Configuration Manager File Acton View Help de DEI EE A SOL Server Configuration Manager Local Protocol Name Status E SOL Server 2005 Services Shared Memory Enabled Se SOL Server 2005 Network Configuration S Named Pipes oe Protocols for MSSOLSERVER OPT Enabled _ 3 Protocols for SALEAPRE 35 VIA Disabled ER SQL Native Chent Configuration TCP IP Properties Protocol IP Addresses IP Active Enabled IP Address 127 0 0 1 TCP Dynamic Ports TCP Part 1433 H IFAI TCP Dynamic Ports b Finally you must Restart to refresh it And please try connect it again Fee j KH Er SQL Server Configuration Manager Meld File Acton View Help e OSB 600 8 SQL Server Configuration Manager Local Name j ER SL Server 2005 Services JH SQL Server Integration Services SOL Server 2005 Network Configuration 4 SOL Server FullText Search MSSQLSERVER Ee Protocols for MSSQLSERVWER Ry SOL Server SQLEXPRESS Protocols tor SULEAFRE 25 Se SOL Server MSSULSERVER d 8 SOL Native Client Configuration A EETA op GD SHL Server Reporting Service stop Zei SOL Server Browser Gees fm SOL Se
10. rver Agent IMSSOLSE CS Restart Properties Help lt ti gt Restart stop and then start selected service 2 If after connect appear following Dialog Happen seldom if ever P Connect Database Connect To Database Database Conta ctsManagementSystem This dialog appears because application doesn t recognize Driver 4 in project So please open netBean 6 0 to remove Driver 4 and add it again Driver 4 is a file named sqljdbc4 jar in folder Source Code Exec lib Finally execute application in netBean 6 0 E eProject_Tuan NetBeans IDE 6 0 File Edit View Navigate Source Refactor Build amp PEL zc i EERS e Serva en TEE Files erg Es 4552 DvyTuan Ges 4552 DvyTuan Ges 4553 DyTuan Es demoSearch ES eProject Tuan 0 9 Source Packages H Test Packages eProject_Tuan agljdbc4 d Libraries o Ei Pae Add OE Ca Test Lib Add Library Add JARIF older Files of type Classpath Entry folder ZIP or JAR F ze Cancel oo Regular Exp If you login successful a Dialog will show massage Connect successful and a form login will appear You only click OK with default username admin and password 123456 L Connect Database Connect To Database Connect Database Connect To Database Server Nan Tree T UserName Password Database Contact Management System Log out vi List System is is S Login Login Contacts Management
Download Pdf Manuals
Related Search