http://java

searchcoilSoftware and s/w Development

Aug 15, 2012 (5 years and 3 months ago)

164 views

In this project, we created application
using Java, MS SQL Server
2005 and related technologies.

WHY CHOOSE JAVA

Java has been tested, refined, extended, and proven by a dedicated
community. And numbering more than 6.5 million developers, it's the
largest

and most active on the planet. With its versatility, efficiency, and
portability, Java has become invaluable to developers by enabling them to:



Write software on one platform and run it on virtually any other
platform



Create programs to run within a Web
browser and Web services



Develop server
-
side applications for online forums, stores, polls,
HTML forms processing, and more



Combine applications or services using the Java language to create
highly customized applications or services



Write powerful and eff
icient applications for mobile phones, remote
processors, low
-
cost consumer products, and practically any other
device with a digital heartbeat

We need to install Java Development Toolkit (JDK) and JRE from
http://java.sun.com/javase/downloads/index.jsp


and NetBeans IDE with
address
http://www.netbeans.org/downloads/index.html


WHY CHOOSE MS SQL SERVER 2005


High performance and sca
lability

In many situations, Microsoft SQL Server offers better performance than
an Access database. SQL Server also provides support for very large
databases, up to one terabyte, which is much larger than the current limit
for an Access database of two gi
gabytes. Finally, SQL Server works very
efficiently on Microsoft Windows Servers by processing queries in parallel
(using multiple native threads within a single process to handle user
requests) and minimizing additional memory requirements when more
users

are added.

Increased availability

Using Microsoft SQL Server, you can do a dynamic backup, either
incremental or complete, of the database while it's in use. Consequently,
you do not have to force users to exit the database to back up data. This
means yo
ur database can be running up to 24 hours a day, seven days a
week.

Improved security

Microsoft SQL Server can integrate with the Windows Server operating system
security to provide a single log on to the network and the database. This makes it
much easier

for you to administer complex security schemes. An SQL Server
database on a server is also better protected because unauthorized users can't get
to the database file directly but must access the server first.

Immediate recoverability

In case of system fa
ilure (such as an operating system crash or power
outage), Microsoft SQL Server has an automatic recovery mechanism that
recovers a database to the last state of consistency in a matter of minutes,
with no database administrator intervention. Critical appl
ications can be up
and running again right away.

Reliable distributed data and transactions

Transaction processing is a vital requirement for a system that is designed
to support critical applications, such as banking and online order entry.
Microsoft SQL
Server supports atomic transactions with transaction
logging, which guarantees that all changes performed within a transaction
are either committed or rolled back.

Consistency and recoverability of a database transaction are guaranteed
even in the case of
system failure and in the middle of complex updates by
more than one user. SQL Server treats all database changes inside a
transaction as a single unit of work. By definition, either an entire
transaction is completed safely and all resulting changes are r
eflected in the
database, or the transaction is rolled back

and all changes to the database
are undone.

Using a two
-
phase commit protocol, SQL Server can even support
synchronized transactions that span more than one server

ensuring that all
servers on the

network are maintained in a consistent state.

Server
-
based processing

Microsoft designed Microsoft SQL Server from the beginning as a
client/server database. Data and indexes reside on a single server computer
that is often accessed over the network by ma
ny client computers. SQL
Server reduces network traffic by processing database queries on the server
before sending results to the client. Thus client/server application can do
processing where it's done best
-

on the server.

Applications can also use sto
red procedures and triggers to
centralize

and
share application logic, business rules and policies, complex queries, and
data validation and referential integrity code on the server, rather than on
the client.

We need
to
install MS SQL Server
2005
as backe
nd database

(Remember
set user name: sa and password : root)
.

You can download
Microsoft
SQL Server JDBC Driver 2.0

from
address
ht
tp://www.microsoft.com/downloads/details.aspx?FamilyID=99b21b65
-
e98f
-
4a61
-
b811
-
19912601fdc9&displaylang=en


We also need install JDateChooser 1.1.1 plug
-
in component for netbeans

http://plugins.netbeans.org/PluginPortal/faces/PluginDetailPage.jsp;jsessio
nid=01d3a141c2ba65d8f6294a0580ef?pluginid=658



After
you

install
ed

MS SQL Server 2005, we need set up IP port to run
project as
follow:


1.

Run:

Start/Program/Microsoft SQL Server 2005/SQL Server
Configuration.




2.

Choose Protocols for SQLEXPRESS

2.1.

Right click on TCP/IP and choose enable




3.

Double click on TCP/IP and choose IP Address tab



4.

Set up all TCP Port with 1433

5.

Res
tart SQL service


HOW TO RUN LEAVE MANAGEMENT SYSTEM PROJECT


1.

Copy LeaveManagement folder
on CD
into your computer.

2.

Start/Program/MS SQL Server 2005/MS SQL Management Studio
Express and log in with username : sa and password : root

3.

Right click on database
and choose attach. Point to source/Database/
where contain 2 file LMS.mdf and LMS.log.







4.

Note:

Install software iReport 3.5.3 on CD, to view all report in
application.

5.

Open source/dist and run file with named LeaveManagement.jar