Member Avatar for ramankrishna

hi this is ramakrishna, i am in my 3yr and i want o develop a project for my jwellary shop which would be standalone project connected to 4 systems in our office with following fields as
1)Transaction - Purchase, Sales, Debit/Credit note, Account voucher, Goods Issue recept, issue to Karigar(worker), recept from Karigar, Order entry, Mixing Enrty, Exit.
2)Master - (this is forthe owner to update the details or changes in the prices etc.) - Ledger account, Group of accounts, Jwellary items, jwelary group, karigar accunt etc...
3)View - stock entry, Day stocks, daily balances, order entery Final account, Intrest calculation etc.


similarly many other I WANT TO AUTOMATE JWELLARY SHOP ..

SO can you sujest me which tools should i use to develop so that i can develop this Project
every field should store in database

thanks
u can revert ur sujestions on my mail :

  • 3 Contributors
  • 2 Replies
  • 137 Views
  • 8 Hours Discussion Span
  • Latest Post Latest Post by Jens

Dani AI

Generated

— before choosing an IDE or database, lock down architecture and minimal workflows. and correctly pushed tools and patterns; the next step is to plan how many concurrent writers you will have, which reports must be accurate to the minute, and whether the system must work when the network is down. For four LAN clients a single authoritative database server is the simplest and safest model (avoids file‑sync conflicts). Sketch an ERD and a handful of UI screens, then build a small prototype.

Keep application structure layered: UI (JavaFX), business/service layer, and a persistence layer (DAO or JPA). Use an ORM for faster development but keep raw JDBC knowledge handy for critical transactions. Prototype with an embedded DB (fast to iterate), then run production on a server DB when ready. Recommended reading: JDBC basics and transactions, Hibernate ORM documentation, and the H2 embedded database for prototypes.

Data-model and concurrency tips: use separate master tables (items, groups, vendors/workers, ledgers) and a single normalized transaction table or a set of strongly typed movement tables (stock_in, stock_out). Record an audit trail for every change (user, timestamp, reason) and enforce constraints and foreign keys at the DB level. Always wrap multi-step stock updates in a DB transaction to keep stock and ledger entries consistent — for example:

try (Connection c = dataSource.getConnection()) {
  c.setAutoCommit(false);
  // update stock, insert ledger entries
  c.commit();
} catch (SQLException e) {
  c.rollback();
  throw e;
}

Practical checklist: start with the smallest deliverable (sales+stock), use Git for source control, add unit/integration tests, schedule automated DB backups, and follow basic security (hashed passwords and least-privilege DB accounts — see the OWASP Password Storage Cheat Sheet). Build iteratively; get a working POS flow first, then add vouchers, mixing, and advanced reports.

Recommended Answers

All 2 Replies

Member Avatar for VernonDozier

hi this is ramakrishna, i am in my 3yr and i want o develop a project for my jwellary shop which would be standalone project connected to 4 systems in our office with following fields as
1)Transaction - Purchase, Sales, Debit/Credit note, Account voucher, Goods Issue recept, issue to Karigar(worker), recept from Karigar, Order entry, Mixing Enrty, Exit.
2)Master - (this is forthe owner to update the details or changes in the prices etc.) - Ledger account, Group of accounts, Jwellary items, jwelary group, karigar accunt etc...
3)View - stock entry, Day stocks, daily balances, order entery Final account, Intrest calculation etc.


similarly many other I WANT TO AUTOMATE JWELLARY SHOP ..

SO can you sujest me which tools should i use to develop so that i can develop this Project
every field should store in database

thanks
u can revert ur sujestions on my mail : [email]<snipped email>[/email]

Spell-check and proofread before posting if you want good advice. Your e-mail is likely going to get snipped by a moderator too since everything's supposed to be kept on the forum. As for the tools you need, I guess you need a Java IDE and a database program at minimum. There are a lot of free ones out there, including these (NetBeans, MySQL). There are others too:

http://www.netbeans.org/
http://dev.mysql.com/downloads/mysql/5.0.html

Member Avatar for Jens

Eclipse or IntelliJ might also help, if you are programming this in java.

Aside of development tools, try to study some design patterns. I feel that these kind of applications can be enhanced by using some of these proven solutions. There is no need to invent the wheel again.

Netbeans and mysql (or oracle, oracleXE is a free client and is used more in big businesses I think) are good choices too.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.