book shop project file
TRANSCRIPT
www.bOtskOOl.com
INFORMATICS PRACTICES
PROJECT FILEON
COOL-QUIZ
PROJECT PREPARED BY:HIMANSHU
XII
Session: 2010-2011Board’s Roll Number:
www.bOtskOOl.com
SCHOOL : K.V. AFS BEGUMPET
TABLE OF CONTENTS
CertificateAcknowledgementWorking description of projectHeader files and their purposeFiles generatedCoding & outputsBibliography
www.bOtskOOl.com
ACKNOWLEDGEMENTIt would be my utmost pleasure to express my sincere thanks to My IP Teacher Mr. Kamlesh Kumar Rajak in providing a helping hand in this project. His unflagging patience, creativity and immense knowledge that he shared with me have proved highly beneficial to me and have made my Project File both possible and successful.
HIMANSHU VISHWAKARMA
XII
www.bOtskOOl.com
CERTIFICATE
This is to certify that Himanshu Vishwakarma
of class XII has completed this project titled “COOL-QUIZ” under my guidance & this project may be considered as the part of the practical exam of AISSCE conducted by CBSE.
Mr. KAMLESH KUMAR RAJAK IPK.V. AFS BEGUMPET
www.bOtskOOl.com
ABOUT PROJECT
This program is designed to keep the friend’s record.This program consists of six options as follows
1.LOGIN:
2.Register
3.Menu
4.Test
5.Result JFGVNDHJVNSDFJKVHSDHFVS
www.bOtskOOl.com
AABOUT JAVA
Java is a programming language originally developed by James Gosling at Sun Microsystems (which is now a subsidiary of Oracle Corporation) and released in 1995 as a core component of Sun Microsystems' Java platform. The language derives much of its syntax from C and C++ but has a simpler object model and fewer low-level facilities. Java applications are typically compiled to byte code (class file) that can run on any Java Virtual Machine (JVM) regardless of computer architecture. Java is a general-purpose, concurrent, class-based, object-oriented language that is specifically designed to have as few implementation dependencies as possible. It is intended to let application developers "write once, run anywhere". Java is currently one of the most popular programming languages in use, and is widely used from application software to web applications.[9][10]
The original and reference implementation Java compilers, virtual machines, and class libraries were developed by Sun from 1995. As of May 2007, in compliance with the specifications of the Java Community Process, Sun relicensed most of its Java technologies under the GNU General Public License. Others have also developed
www.bOtskOOl.com
alternative implementations of these Sun technologies, such as the GNU Compiler for Java, GNU Classpath, and Dalvik.
ABOUT MYSQL
MySQL is a relational database management system (RDBMS)[1] that runs as a server providing multi-user access to a number of databases. MySQL is officially pronounced /maɪˌɛskjuːˈɛl/ ("My S-Q-L"),[2] but is often also pronounced /maɪˈsiːkwəl/ ("My Sequel"). It is named after developer Michael Widenius' daughter, My. The SQL phrase stands for Structured Query Language.[3]
The MySQL development project has made its source code available under the terms of the GNU General Public License, as well as under a variety of proprietary agreements. MySQL was owned and sponsored by a single for-profit firm, the Swedish company MySQL AB, now owned by Oracle Corporation.[4]
Members of the MySQL community have created several forks (variations) such as Drizzle, OurDelta, Percona Server, and MariaDB. All of these forks were in progress before the Oracle acquisition; Drizzle was announced eight months before the Sun acquisition.
www.bOtskOOl.com
Free-software projects that require a full-featured database management system often use MySQL. Such projects include (for example) WordPress, phpBB, Drupal and other software built on the LAMP software stack. MySQL is also used in many high-profile, large-scale World Wide Web products, including Wikipedia, Google[5] and Facebook.[6]
Minimum Hardware Configurations Microsoft Windows XP Professional SP3/Vista
SP1/Windows 7 Professional: o Processor: 800MHz Intel Pentium III or
equivalento Memory: 512 MBo Disk space: 750 MB of free disk space
Ubuntu 9.10: o Processor: 800MHz Intel Pentium III or
equivalento Memory: 512 MBo Disk space: 650 MB of free disk space
Solaris OS version 10 (SPARC): o Processor: UltraSPARC II 450 MHzo Memory: 512 MBo Disk space: 650 MB of free disk space
Solaris OS version 10 (x86/x64 Platform Edition): o Processor: AMD Opteron 1200 Series 1.8 GHzo Memory: 512 MBo Disk space: 650 MB of free disk space
Macintosh OS X 10.5 Intel: o Processor: Dual-Core Intel (32 or 64-bit)
www.bOtskOOl.com
o Memory: 512 MBo Disk space: 650 MB of free disk space
Minimum SOFTWARE Configurations
1 .OPERATING SYSTEM2 .MYSQL3 .IDE NETBEANS4 .JAVA JDBC CONNECTOR
www.bOtskOOl.com
CODING:-1. LogIn.java
WELCOME TO COOL QUIZ
LOGIN TO CONTINUE
LOGIN ID
PASSWORD
LOGIN
NOT YET A MEMBER …CLICK HERE TO REGISTER
www.bOtskOOl.com
TYPE NAME TEXT
JTextField ID
JLabel InvalidLBL
JPasswordField Password
JButton loginBTN LOGIN
JLabel regLBL Not Yet A Member
www.bOtskOOl.com
Code:import java.sql.*;
private void loginBTNActionPerformed(java.awt.event.ActionEvent evt) {
try {InvalidLBL.setText(“”);
String PWord=Password.getText();String I=ID.getText();
String str=null;Class.forName(“java.sql.Driver”);
Connection con=DriverManager.getConnection(“jdbc:mysql://localhost:3306/quizdb”,”root”,””);
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery(“select * from login where ID =’”+I+”’ ;”);
rs.next(); str=rs.getString(“Password”); if(str.equals(PWord))
{Menu m = new Menu();m.setVisible(true);this.setVisible(false);
}else
{InvalidLBL.setText(“incorrect”);
}} catch(Exception e) {
InvalidLBL.setText(“INCORRECT”);
}
private void regLBLMouseClicked(java.awt.event.MouseEvent evt) { Register r=new Register(); r.setVisible(true); this.setVisible(false);
}//}
www.bOtskOOl.com
COOL QUIZ
REGISTRATION FORM
NAME
DOB
ADDRESS
AGE
UNIVERSITY
COLLEGE
USERID
PASSWORD
REGISTER & START TEST
2.Register.java
www.bOtskOOl.com
Type Name Text
JTextField AddressTf
JTextField AgeTF
JTextField CollegeTF
JTextField DobTF
JRadioButton FemaleTF
JTextField IDTF
JRadioButton MaleRB
JTextField NameTF
JTextField PasswordTF
JTextField UnivTF
JButton RegisterTF REGISTER TO START TEST
CODING:-
import java.sql.*;
www.bOtskOOl.com
import javax.swing.JOptionPane;
private void registerTfActionPerformed(java.awt.event.ActionEvent evt) { try{int age=Integer.parseInt(AgeTF.getText());char Gender=’M’;if(FemaleRB.isSelected())Gender=’F’;Class.forName(“java.sql.driver”);
String database=”jdbc:mysql://localhost:3306/quizdb”;
Connection conn=DriverManager.getConnection(database,”root”,””);
Statement stmt=conn.createStatement();
String sql=”INSERT INTO StudInfo VALUES(‘” + NmaeTF.getText() + “’ ,” + age +”,’” +DobTF.getText() +”’,’” +
Gender +”’,’” + AddressTF.getText() +”’,’” + CollegeTF.getText() +”’,’” + UnivTF.getText() + “’,’” +IDTF.getText() + “’ )”;
stmt.executeUpdate(sql); sql=”INSERT INTO Result VALUES (‘” + IDTF.getText() + “’, 0, 0, 0, 0)”; stmt.executeUpdate(sql); sql=”insert into login values( ‘” + IDTF.getText() + “’,’” + PasswordTF.getText() + “’ )”; stmt.executeUpdate(sql); stmt. close(); conn.close(); new Menu(IDTF.getText()).setVisible(true); this.setVisible(false);
}catch(Exception e)
{JOptionPane.showMessageDialog(null,””+e);
}
public static void main(String args[]) {java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {new Register().setVisible(true);
} }); }}
www.bOtskOOl.com
3. Menu.java
WELCOME TO COOL QUIZ
SELECT YOUR SUBJECT
Ο JAVA Ο HTML
Ο DBMS Ο NETWORKING
TYPE NAME TEXT
JRadioButton DbmsRB DBMS
JRadioButton HtmlRB HTML
JRadioButton JavaRB JAVA
START TEST>>>>
www.bOtskOOl.com
JRadioButton NetworkingRB NETWORKING
JButton startTestBTN START TEST>>
Coding:-
//GLOBAL VARIABLEsString ID;
//CONSTRUCTORs
public Menu() {
initComponents();
}public Menu(String id) {
initComponents();
ID=id;
}
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
String sub=null;if(JavaRB.isSelected())sub=”java”;else if (DbmsRB.isSelected())sub=”dbms”;else if (HtmlRB.isSelected())sub=”html”;else if (NetworkingRB.isSelected())sub=”networking”;if(sub!=null){Test t=new Test (sub,ID);t.setVisible(true);this.setVisible(false);}
www.bOtskOOl.com
public static void main(String args[]) {java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {new Menu().setVisible(true); } }); }}
4. Test.java
www.bOtskOOl.com
TYPE NAME TEXTJButton NextBTN Next>>JButton PrevBTN Prev<<JTextArea QuesTAJButton ResultBTN GET RESULTJRadioButton aJRadioButton bJRadioButton cJRadioButton d
Coding:-
import java.sql.*;import javax.swing.JOptionPane;
//GLOBAL VARIABLESString ID;String Subject;int index=1;int max=0;int result=0;char[] answers;
//CONSTRUCTORS
public Test() {
initComponents();
}public Test(String subject,String id)
{initComponents();ID=id;Subject=subject;PrevBTN.setVisible(false);
try {
www.bOtskOOl.com
Class.forName(“java.sql.driver”);
String database=”jdbc:mysql://localhost:3306/quizdb”;
Connection conn=DriverManager.getConnection(database,”root”,””);
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery(“select max(Sno) from “ + Subject); rs.next(); max=rs.getInt(1);
answers=new char[max]; for(int i=0;i<max;i++) answers[i]=’e’; rs.close(); stmt.close(); conn.close();
}catch(Exception e){JOptionPane.showMessageDialog(null,””+e);
} }
//User-defined method
private void getQuesActionPerformed(java.awt.event.ActionEvent evt) {
try
{Class.forName(“java.sql.Driver”);String database=”jdbc:mysql://localhost:3306/quizdb”;Connection conn=DriverManager.getConnection(database,”root”,””);
Statement stmt=conn.createStatement();
String sql=”select * from “ + Subject + “where Sno = “ + index;
ResultSet rs=stmt.executeQuery(sql); rs.next();
QuesTA.setText(“” + index + “.” + rs.getString(2)); a.setText(rs.getString(“a”));
b.setText(rs.getString(“b”)); c.setText(rs.getString(“c”)); d.setText(rs.getString(“d”)); a.setSelected(answers[index-1]==’a’); b.setSelected(answers[index-1]==’b’); c.setSelected(answers[index-1]==’c’); d.setSelected(answers[index-1]==’d’); rs.close(); stmt.close(); conn.close();
}catch(Exception e)
{JOptionPane.showMessageDialog(null, “”+ e);
}}
www.bOtskOOl.com
5. Result.java
COOL QUIZ
YOUR SCORE:
BEST SO FAR:
TYPE NAME TEXTJButton BackBTN TAKE ANOTHER QUIZJLabel ScoreJButton exitBTN EXITJTable scoreTBL
Coding:-
SUBJECT JAVA DBMS HTML NETWORKING
TAKE ANOTHER QUIZEXIT
www.bOtskOOl.com
import java.sql.*;import javax.swing.table.*;import javax.swing.JOptionPane;
//GLOBAL VARIABLESfloat result;String ID;
//CONSTRUCTORS
public Result() {
initComponents();
}public Result(float res,String id)
{initComponents();result=res;ID=id;score.setText(res + “%”);try{
Class.forName(“java.sql.Driver”);
String database=”jdbc:mysql://localhost:3306/quizdb”;
Connection conn=DriverManager.getConnection(database,”root”,””);
Statement stmt=conn.createStatement();
String sql=”select * from result where ID = ‘” + ID + “’”;
ResultSet rs=stmt.executeQuery(sql);
Object[] newrow=new Object[5]; newrow[0]=”MAX MARKS”; rs.next(); for(int i=1;i<=4;i++)
newrow[i]=rs.getString(i +1);
www.bOtskOOl.com
DefaultTableModel ss=(DefaultTableModel) scoreTBL.getModel(); ss.addRow(newrow);
}catch(Exception e){JOptionPane.showMessageDialog(null,””+ e);
} }
private void BackBTNActionPerformed(java.awt.event.ActionEvent evt) { new Menu(ID).setVisible(true); this.setVisible(false)
}
private void exitBTNActionPerformed(java.awt.event.ActionEvent evt) { this.dispose();
}
public static void main(String args[]) {java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {new Result().setVisible(true);
} }); }}
OUTPUTS
www.bOtskOOl.com
WHAT DO U WANT TO DO:
1.LOGIN
2.Register SELECT YOUR SUBJECT
3.Test4.Result
ENTER UR CHOICE:1
ENTER DETAILS ABOUT BOOK U WANT TO PURCHASE:Enter Login Id: Rohit
Enter Password: sansarwal
Do You Want To Continue Y
WHAT DO U WANT TO DO:
1.LOGIN
2.Register
3.SELECT YOUR SUBJECT
www.bOtskOOl.com
4.Test
5.Result
ENTER UR CHOICE:2
NAME: Rohit
DOB: 15 JULY 1993
ADDRESS:AFS BEGUMPET SMQ 35/2
AGE: 17
UNIVERSITY:KV BEGUMPETCOLLEGE:
USERNAME :rohit
PASSWORD: rohitDo You Want To Continue Y
www.bOtskOOl.com
WHAT DO U WANT TO DO:
1.LOGIN
2.Register
3.SELECT YOUR SUBJECT
4.Test
5.Result
ENTER UR CHOICE:3
SELECT YOUR SUBJECT: JAVA
Do You Want To Continue Y
www.bOtskOOl.com
WHAT DO U WANT TO DO:
1.LOGIN
2.Register
3.SELECT YOUR SUBJECT
4.Test
5.ResultENTER UR CHOICE:4
QUESTION:WHICH TEAM WON 2007 WC?
Do You Want To Continue Y
www.bOtskOOl.com
WHAT DO U WANT TO DO:
1.LOGIN
2.Register
3.SELECT YOUR SUBJECT
4.Test
5.Result
ENTER UR CHOICE:5
YOUR SCORE :55
BEST SO FAR:99TAKE ANOTHER QUIZ Y
NOW YOU WANT TO GO
www.bOtskOOl.com
INFORMATIC PRACTICES IN JAVA BY :– SUMITA ARORA
Websites: www.GOOGLE.com www.WIKIPEDIA.com www.TOPLEARNINGS.com