Scribd
Upload
141 views30 pages

Ip Project

The document describes a project to create a GUI-based membership database for the Hari Nagar Sports Complex. It includes sections on the aim of the project, an overview of the sports complex, the backend database structure, output screens and source code examples for forms to add, update, cancel and search member records. The project uses Netbeans for the front-end, MySQL for the backend database, and connects them using JDBC.

Uploaded by

Arpit Mittal
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
141 views30 pages

Ip Project

The document describes a project to create a GUI-based membership database for the Hari Nagar Sports Complex. It includes sections on the aim of the project, an overview of the sports complex, the backend database structure, output screens and source code examples for forms to add, update, cancel and search member records. The project uses Netbeans for the front-end, MySQL for the backend database, and connects them using JDBC.

Uploaded by

Arpit Mittal
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 30

BY

ARPIT MITTAL
CLASS XII-E

SPORTS CLUB MEMBERSHIP


Hari Nagar
INDEX
1. CERTIFICATE
2. ACKNOWLEDGMENT
3. AIM
4. ABOUT THE OBJECT
5. OVERVIEW
6. BACKEND
7. OUTPUT SCREEN &
SOURCE CODE
8. BIBLIOGRAPHY

1|Page
Certificate
This is to certify that
Arpit Mittal
Of class XII-E
Has made his project
Hari Nagar Sports Complex
For the year
2017-2018

Under my supervision and has


completed the full project
Under my satisfaction

______________________________________

Mr. M. Vaz
2|Page
Acknowledgement

I would like to express my


special thanks to my teacher
who assisted me in the
completion of this project.

Secondly, I would like to


thank my parents and my
friends who helped me a lot
in finalizing this project
within the limited time frame

Arpit Mittal
3|Page
AIM
TO create a GUI based
Membership Database for hari
Nagar Sports Complex.

4|Page
ABOUT THE PROJECT

We have made this Project to automate Sports Club Membership.


Following operation are covered in this Project.

New Member Entry Form


Cancel Membership
Update Membership
View All Member Details
Search Member

Front-end used in this project: Net beans


Back End Used: MySQL

Connectivity done through JDBC driver

5|Page
Overview
Hari nagar sports
complex is located at
Hari Nagar, Beer Wala
Bagh New Delhi.
It hosts various
sports facilities
like

6|Page
Backend

7|Page
Database Name: Sports
Table: Member

8|Page
Output

9|Page
10 | P a g e
11 | P a g e
12 | P a g e
13 | P a g e
14 | P a g e
15 | P a g e
16 | P a g e
Source Code

17 | P a g e
Login Form

private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {

String login=jTextField1.getText();
String pwd =new String(jPasswordField1.getPassword());
if(login.equals("niki")&&(pwd.equals("kanika"))) {
this.setVisible(false);
new menu1().setVisible(true);
} else
JOptionPane.showMessageDialog(null,"Access Denied");

18 | P a g e
Menu Form

private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {


new addRec().setVisible(true);
}

private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {


new delRec().setVisible(true);
}

private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {


new modRec().setVisible(true);
}

private void jButton4ActionPerformed(java.awt.event.ActionEvent evt) {


new searchRecs().setVisible(true);
}

private void jButton5ActionPerformed(java.awt.event.ActionEvent evt) {


new dispTable().setVisible(true);
}

19 | P a g e
New Member Creation Form

import com.mysql.jdbc.Connection;
import com.mysql.jdbc.Statement;
import java.sql.DriverManager;
import javax.swing.JOptionPane;

private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {

String s2,s3,s5,s6,s7;
int s1,s4;
s1=Integer.parseInt(jTextField1.getText());
s2=jTextField2.getText();
s3=jTextField3.getText();
s4=Integer.parseInt(jTextField4.getText());
if(jRadioButton1.isSelected())
s5="M";
else
s5="F";
s6=jComboBox1.getSelectedItem().toString();
s7=jComboBox2.getSelectedItem().toString();
try
{
Class.forName("java.sql.DriverManager");
Connection
con=(Connection)DriverManager.getConnection("jdbc:mysql://localhost:3306/sports","root","");
Statement stmt=(Statement)con.createStatement();
String Query="insert into member
VALUES("+s1+",'"+s2+"','"+s3+"',"+s4+",'"+s5+"','"+s6+"','"+s7+"')";
stmt.executeUpdate(Query);
JOptionPane.showMessageDialog(this,"Contact Added");

}
catch(Exception e)
{
JOptionPane.showMessageDialog(this,e.getMessage());

}
}

private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {


this.setVisible(false);
new menu1().setVisible(true); }

20 | P a g e
Cancelation Form

import com.mysql.jdbc.Connection;
import com.mysql.jdbc.Statement;
import java.sql.DriverManager;
import java.sql.ResultSet;
import javax.swing.JOptionPane;
import javax.swing.table.DefaultTableModel;

private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {


// TODO add your handling code here:
String s= jTextField1.getText();

try
{
Class.forName("java.sql.DriverManager");
Connection
con=(Connection)DriverManager.getConnection("jdbc:mysql://localhost:3306/sports","root","");
Statement stmt=(Statement)con.createStatement();
String Query="select * from MEMBER where member_nmae='"+s+"'";
ResultSet rs=stmt.executeQuery(Query);
DefaultTableModel model=(DefaultTableModel)jTable1.getModel();
int rows=model.getRowCount();
for(int i=0;i<rows;i++)
{
model.removeRow(0);

}
while(rs.next())
{
String s1=rs.getString("member_id");
String s2=rs.getString("member_nmae");
String s3=rs.getString("member_address");
String s4=rs.getString("member_telephone");
String s5=rs.getString("member_gender");
String s6=rs.getString("member_yearlyincome");
String s7=rs.getString("member_activity");
model.addRow(new Object[]{s1,s2,s3,s4,s5,s6,s7});

}
}
catch(Exception e)

21 | P a g e
{
JOptionPane.showMessageDialog(this,e.getMessage());

private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {


// TODO add your handling code here:
String s1;
s1=jTextField1.getText();
try
{
Class.forName("java.sql.DriverManager");
Connection
con=(Connection)DriverManager.getConnection("jdbc:mysql://localhost:3306/sports","root","");
Statement stmt=(Statement)con.createStatement();
String Query="delete from MEMBER where member_nmae='"+s1+"'";
int i=stmt.executeUpdate(Query);
JOptionPane.showMessageDialog(null,i+"Contacts Deleted");
}
catch(Exception e)
{
JOptionPane.showMessageDialog(this,e.getMessage());
}
}

private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {


this.setVisible(false);
new menu1().setVisible(true);
}

22 | P a g e
Update Member Details

import com.mysql.jdbc.Connection;
import com.mysql.jdbc.Statement;
import java.sql.DriverManager;
import java.sql.ResultSet;
import javax.swing.JOptionPane;
import javax.swing.table.DefaultTableModel;

private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {


// TODO add your handling code here:
String s= jTextField1.getText();

try
{
Class.forName("java.sql.DriverManager");
Connection
con=(Connection)DriverManager.getConnection("jdbc:mysql://localhost:3306/sports","root","");
Statement stmt=(Statement)con.createStatement();
String Query="select * from MEMBER where member_nmae='"+s+"'";
ResultSet rs=stmt.executeQuery(Query);
DefaultTableModel model=(DefaultTableModel)jTable1.getModel();
int rows=model.getRowCount();
for(int i=0;i<rows;i++)
{
model.removeRow(0);

}
while(rs.next())
{
String s1=rs.getString("member_id");
String s2=rs.getString("member_nmae");
String s3=rs.getString("member_address");
String s4=rs.getString("member_telephone");
String s5=rs.getString("member_gender");
String s6=rs.getString("member_yearlyincome");
String s7=rs.getString("member_activity");
model.addRow(new Object[]{s1,s2,s3,s4,s5,s6,s7});

}
}

23 | P a g e
catch(Exception e)
{
JOptionPane.showMessageDialog(this,e.getMessage());

private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {

String s1,s2;
int s3;
s1=jTextField1.getText();
s2=jTextField2.getText();
s3=Integer.parseInt(jTextField3.getText());
try
{
Class.forName("java.sql.DriverManager");
Connection
con=(Connection)DriverManager.getConnection("jdbc:mysql://localhost:3306/sports","root","");
Statement stmt=(Statement)con.createStatement();
String Query="update MEMBER set
member_address='"+s2+"',member_telephone'"+s3+"'where member_nmae'"+s1+"'";
int i=stmt.executeUpdate(Query);

JOptionPane.showMessageDialog(null,i+"Contact Modified");

}
catch(Exception e)
{
JOptionPane.showMessageDialog(this,e.getMessage());
}

private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {


this.setVisible(false);
new menu1().setVisible(true);
}

24 | P a g e
Search Member

import com.mysql.jdbc.Connection;
import com.mysql.jdbc.Statement;
import java.sql.DriverManager;
import java.sql.ResultSet;
import javax.swing.JOptionPane;
import javax.swing.table.DefaultTableModel;

private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {

String s= jComboBox1.getSelectedItem().toString();
try
{
Class.forName("java.sql.DriverManager");
Connection
con=(Connection)DriverManager.getConnection("jdbc:mysql://localhost:3306/sports","root","");
Statement stmt=(Statement)con.createStatement();
String Query="select * from MEMBER where member_activity='"+s+"'";
ResultSet rs=stmt.executeQuery(Query);
DefaultTableModel model=(DefaultTableModel)jTable1.getModel();
int rows=model.getRowCount();
for(int i=0;i<rows;i++)
{
model.removeRow(0);

}
while(rs.next())
{
String s1=rs.getString("member_id");
String s2=rs.getString("member_nmae");
String s3=rs.getString("member_address");
String s4=rs.getString("member_telephone");

25 | P a g e
String s5=rs.getString("member_gender");
String s6=rs.getString("member_yearlyincome");
String s7=rs.getString("member_activity");
model.addRow(new Object[]{s1,s2,s3,s4,s5,s6,s7});

}
}
catch(Exception e)
{
JOptionPane.showMessageDialog(this,e.getMessage());

}
}

private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {


this.setVisible(false);
new menu1().setVisible(true);
}

26 | P a g e
Display all Record

import com.mysql.jdbc.Connection;
import com.mysql.jdbc.Statement;
import java.sql.DriverManager;
import java.sql.ResultSet;
import javax.swing.JOptionPane;
import javax.swing.table.DefaultTableModel;

private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {

try
{
Class.forName("java.sql.DriverManager");
Connection
con=(Connection)DriverManager.getConnection("jdbc:mysql://localhost:3306/sports","root","");
Statement stmt=(Statement)con.createStatement();
String Query="select * from MEMBER ";
ResultSet rs=stmt.executeQuery(Query);
DefaultTableModel model=(DefaultTableModel)jTable1.getModel();
int rows=model.getRowCount();
for(int i=0;i<rows;i++)
{
model.removeRow(0);

}
while(rs.next())
{
String s1=rs.getString("member_id");
String s2=rs.getString("member_nmae");
String s3=rs.getString("member_address");
String s4=rs.getString("member_telephone");
String s5=rs.getString("member_gender");
String s6=rs.getString("member_yearlyincome");
String s7=rs.getString("member_activity");
model.addRow(new Object[]{s1,s2,s3,s4,s5,s6,s7});

}
}
catch(Exception e)

27 | P a g e
{
JOptionPane.showMessageDialog(this,e.getMessage());

}
}

private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {


this.setVisible(false);
new menu1().setVisible(true);
}

28 | P a g e
Bibliography
Informatics Practices for
class XII Prescribed by
CBSE

29 | P a g e

You might also like