Skip to content

Commit cd537fc

Browse files
committed
added project files
1 parent 1cbaaf8 commit cd537fc

File tree

139 files changed

+9367
-0
lines changed

Some content is hidden

Large Commits have some content hidden by default. Use the searchbox below for content that may be hidden.

139 files changed

+9367
-0
lines changed

databases/java_registration.sql

Lines changed: 174 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,174 @@
1+
-- phpMyAdmin SQL Dump
2+
-- version 4.5.1
3+
-- http://www.phpmyadmin.net
4+
--
5+
-- Host: 127.0.0.1
6+
-- Generation Time: Aug 26, 2017 at 12:41 AM
7+
-- Server version: 10.1.13-MariaDB
8+
-- PHP Version: 7.0.8
9+
10+
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11+
SET time_zone = "+00:00";
12+
13+
14+
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15+
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16+
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17+
/*!40101 SET NAMES utf8mb4 */;
18+
19+
--
20+
-- Database: `java_registration`
21+
--
22+
23+
-- --------------------------------------------------------
24+
25+
--
26+
-- Table structure for table `adminstrator`
27+
--
28+
29+
CREATE TABLE `adminstrator` (
30+
`adminNo` varchar(10) DEFAULT NULL,
31+
`name` varchar(20) DEFAULT NULL,
32+
`gender` varchar(10) DEFAULT NULL,
33+
`phoneNo` varchar(15) DEFAULT NULL,
34+
`Email` varchar(225) DEFAULT NULL
35+
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
36+
37+
--
38+
-- Dumping data for table `adminstrator`
39+
--
40+
41+
INSERT INTO `adminstrator` (`adminNo`, `name`, `gender`, `phoneNo`, `Email`) VALUES
42+
('ad01', 'Sammuel', 'Male', '0-778-589-369', NULL),
43+
('ad02', 'Tracy', 'Female', '0-712-993-698', NULL),
44+
('ad03', 'Hariet', 'Female', '0-704-965-785', NULL);
45+
46+
-- --------------------------------------------------------
47+
48+
--
49+
-- Table structure for table `enroll`
50+
--
51+
52+
CREATE TABLE `enroll` (
53+
`Regno` varchar(10) DEFAULT NULL,
54+
`course_code` varchar(10) DEFAULT NULL,
55+
`courseUnit` varchar(50) DEFAULT NULL,
56+
`marks` int(11) DEFAULT NULL,
57+
`grade` char(1) DEFAULT NULL
58+
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
59+
60+
--
61+
-- Dumping data for table `enroll`
62+
--
63+
64+
INSERT INTO `enroll` (`Regno`, `course_code`, `courseUnit`, `marks`, `grade`) VALUES
65+
('142', 'ceu1', 'advanced database systems', 67, 'C'),
66+
('142', 'ceu2', 'computer networks', 80, 'A'),
67+
('123', 'ceu1', 'advanced database systems', 77, 'B'),
68+
('857', 'ceu1', 'advanced database systems', 50, 'C'),
69+
('875', 'ceu3', 'analysis of algorithms', 64, 'C'),
70+
('456', 'ceu2', 'computer networks', 90, 'A'),
71+
('013', 'ceu4', 'Database', 87, 'A'),
72+
('378', 'ceu5', 'system administration', 79, 'A'),
73+
('782', 'ceu6', 'programming principles', 65, 'C'),
74+
('320', 'ceu7', 'Ethics', 73, 'B'),
75+
('320', 'ceu2', 'computer networks', 76, 'B'),
76+
('013', 'ceu6', 'programming principles', 62, 'C'),
77+
('782', 'ceu3', 'analysis of algorithms', 67, 'C'),
78+
('378', 'ceu1', 'advanced database systems', 83, 'A'),
79+
('213', 'ceu4', 'Database', 80, 'A'),
80+
('278', 'ceu4', 'Database', 72, 'B'),
81+
('213', 'ceu6', 'programming principles', 80, 'A'),
82+
('213', 'ceu7', 'Ethics', 78, 'B'),
83+
('278', 'ceu7', 'Ethics', 69, 'C'),
84+
('278', 'ceu5', 'system administration', 75, 'B');
85+
86+
-- --------------------------------------------------------
87+
88+
--
89+
-- Table structure for table `lecturer`
90+
--
91+
92+
CREATE TABLE `lecturer` (
93+
`staffNo` varchar(10) DEFAULT NULL,
94+
`Fname` varchar(15) DEFAULT NULL,
95+
`Lname` varchar(15) DEFAULT NULL,
96+
`Age` int(11) DEFAULT NULL,
97+
`gender` varchar(10) DEFAULT NULL,
98+
`Address` varchar(20) DEFAULT NULL,
99+
`Email` varchar(255) DEFAULT NULL,
100+
`PhoneNo` varchar(15) DEFAULT NULL,
101+
`dept` varchar(255) DEFAULT NULL
102+
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
103+
104+
--
105+
-- Dumping data for table `lecturer`
106+
--
107+
108+
INSERT INTO `lecturer` (`staffNo`, `Fname`, `Lname`, `Age`, `gender`, `Address`, `Email`, `PhoneNo`, `dept`) VALUES
109+
('le01', 'Annet', 'Nanta', 25, 'Female', 'Entebbe,najja', 'anne@gmail.com', '0-727-457-890', 'Faculty Of Scince and technology'),
110+
('le02', 'Bob', 'John', 25, 'Male', 'Kampala,Kibuli', 'bobjo@Yahoo.com', '0-797-224-752', 'Faculty Of Scince and technology'),
111+
('le03', 'Rose', 'Mary', 30, 'Female', 'Gulu,ayam', 'rosem@gmail.com', '0-787-878-998', 'Faculty Of Scince and technology'),
112+
('le04', 'Brian', 'Leju', 34, 'Male', 'Mukono,Nangwa', 'briale@rocketmail.com', '0-754-478-324', 'Faculty Of Law'),
113+
('le05', 'Lwiza', 'Ayikoru', 33, 'Female', 'Arua,Youmbee', 'lwiayi@hotmail.com', '0-787-488-361', 'Faculty Of Law'),
114+
('le06', 'JohnBosco', 'Wabwere', 31, 'Male', 'Kampala,Muyenga', 'wabzjo@Yahoo.com', '0-797-222-333', 'Scince and technology'),
115+
('le07', 'Nancy', 'Askipwe', 28, 'Female', 'Arua,bako', 'nancy@asphotmail.com', '0-787-118-551', 'Foundations Studies');
116+
117+
-- --------------------------------------------------------
118+
119+
--
120+
-- Table structure for table `login`
121+
--
122+
123+
CREATE TABLE `login` (
124+
`password` varchar(15) DEFAULT NULL,
125+
`username` varchar(20) DEFAULT NULL,
126+
`type` varchar(15) DEFAULT NULL
127+
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
128+
129+
--
130+
-- Dumping data for table `login`
131+
--
132+
133+
INSERT INTO `login` (`password`, `username`, `type`) VALUES
134+
('ad00', 'robert', 'adminstrator'),
135+
('13', 'Robert', 'student'),
136+
('le08', 'robert', 'lecturer');
137+
138+
-- --------------------------------------------------------
139+
140+
--
141+
-- Table structure for table `student`
142+
--
143+
144+
CREATE TABLE `student` (
145+
`RegNo` int(11) DEFAULT NULL,
146+
`Fname` varchar(15) DEFAULT NULL,
147+
`Lname` varchar(15) DEFAULT NULL,
148+
`Age` int(11) DEFAULT NULL,
149+
`Gender` varchar(10) DEFAULT NULL,
150+
`Address` varchar(15) DEFAULT NULL,
151+
`Programme` varchar(10) DEFAULT NULL,
152+
`PhoneNo` varchar(15) DEFAULT NULL,
153+
`Email` varchar(225) DEFAULT NULL
154+
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
155+
156+
--
157+
-- Dumping data for table `student`
158+
--
159+
160+
INSERT INTO `student` (`RegNo`, `Fname`, `Lname`, `Age`, `Gender`, `Address`, `Programme`, `PhoneNo`, `Email`) VALUES
161+
(142, 'Dart', 'Dranni', 20, 'Male', 'Arua,ayui', 'BSCs', NULL, NULL),
162+
(123, 'lisa', 'Namata', 21, 'Female', 'Kampala,Gayaza', 'BITs', '234567', 'lisa@home.com'),
163+
(857, 'milhouse', 'Eree', 23, 'Male', 'Mukono,Kayunga', 'BSCs', NULL, NULL),
164+
(456, 'Ralph', 'Macher', 21, 'Male', 'Enttebe,Kazi', 'BSCs', NULL, NULL),
165+
(320, 'Robin', 'Waswaa', 23, 'Male', 'Mukono,Kasoo', 'BITs', NULL, NULL),
166+
(13, 'Robert', 'Andama', 22, 'Male', 'Mbarara,Mataa', 'LIBs', '0787458902', 'rolynandama@gmail.com'),
167+
(378, 'Matha', 'Anne', 21, 'Female', 'Mbale,fttee', 'BES', NULL, NULL),
168+
(213, 'Grace', 'Mutoni', 22, 'Female', 'Wakiso,Mbuya', 'LIBs', NULL, NULL),
169+
(782, 'Joana', 'Yangi', 25, 'Female', 'Soroti,oyamu', 'LIBs', NULL, NULL),
170+
(278, 'Juliana', 'Tabu', 21, 'Female', 'Mbale,fttee', 'BES', NULL, NULL);
171+
172+
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
173+
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
174+
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

student result system/build.xml

Lines changed: 73 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,73 @@
1+
<?xml version="1.0" encoding="UTF-8"?>
2+
<!-- You may freely edit this file. See commented blocks below for -->
3+
<!-- some examples of how to customize the build. -->
4+
<!-- (If you delete it and reopen the project it will be recreated.) -->
5+
<!-- By default, only the Clean and Build commands use this build script. -->
6+
<!-- Commands such as Run, Debug, and Test only use this build script if -->
7+
<!-- the Compile on Save feature is turned off for the project. -->
8+
<!-- You can turn off the Compile on Save (or Deploy on Save) setting -->
9+
<!-- in the project's Project Properties dialog box.-->
10+
<project name="StudentsResults" default="default" basedir=".">
11+
<description>Builds, tests, and runs the project StudentsResults.</description>
12+
<import file="nbproject/build-impl.xml"/>
13+
<!--
14+
15+
There exist several targets which are by default empty and which can be
16+
used for execution of your tasks. These targets are usually executed
17+
before and after some main targets. They are:
18+
19+
-pre-init: called before initialization of project properties
20+
-post-init: called after initialization of project properties
21+
-pre-compile: called before javac compilation
22+
-post-compile: called after javac compilation
23+
-pre-compile-single: called before javac compilation of single file
24+
-post-compile-single: called after javac compilation of single file
25+
-pre-compile-test: called before javac compilation of JUnit tests
26+
-post-compile-test: called after javac compilation of JUnit tests
27+
-pre-compile-test-single: called before javac compilation of single JUnit test
28+
-post-compile-test-single: called after javac compilation of single JUunit test
29+
-pre-jar: called before JAR building
30+
-post-jar: called after JAR building
31+
-post-clean: called after cleaning build products
32+
33+
(Targets beginning with '-' are not intended to be called on their own.)
34+
35+
Example of inserting an obfuscator after compilation could look like this:
36+
37+
<target name="-post-compile">
38+
<obfuscate>
39+
<fileset dir="${build.classes.dir}"/>
40+
</obfuscate>
41+
</target>
42+
43+
For list of available properties check the imported
44+
nbproject/build-impl.xml file.
45+
46+
47+
Another way to customize the build is by overriding existing main targets.
48+
The targets of interest are:
49+
50+
-init-macrodef-javac: defines macro for javac compilation
51+
-init-macrodef-junit: defines macro for junit execution
52+
-init-macrodef-debug: defines macro for class debugging
53+
-init-macrodef-java: defines macro for class execution
54+
-do-jar: JAR building
55+
run: execution of project
56+
-javadoc-build: Javadoc generation
57+
test-report: JUnit report generation
58+
59+
An example of overriding the target for project execution could look like this:
60+
61+
<target name="run" depends="StudentsResults-impl.jar">
62+
<exec dir="bin" executable="launcher.exe">
63+
<arg file="${dist.jar}"/>
64+
</exec>
65+
</target>
66+
67+
Notice that the overridden target depends on the jar target and not only on
68+
the compile target as the regular run target does. Again, for a list of available
69+
properties which you can use, check the target you are overriding in the
70+
nbproject/build-impl.xml file.
71+
72+
-->
73+
</project>

student result system/build/classes/.netbeans_automatic_build

Whitespace-only changes.

student result system/build/classes/.netbeans_update_resources

Whitespace-only changes.
61.8 KB
Loading
128 KB
Loading
384 KB
Loading
9.59 KB
Loading
407 Bytes
Loading
396 Bytes
Loading

0 commit comments

Comments
 (0)