DaniWeb IT Discussion Community

implementing supertype-subtype

scias23 — Fri, 18 Dec 2009 05:47:39 GMT

my project needs an implementation of supertype-subtype, however, we haven't tackled that topic yet at school. i know the concept of supertype-subtype, but i don't know how to write it out on mssql. i even don't know how to insert data using supertype-subtype.

here's the reqs's:
* there is a supertype named DOCUMENT. it has attributes such as DATE ISSUED, NAME OF REQUESTOR..
* one subtype is clearance
* another subtype is business clearance

now my question:
* how would i code this in mssql?
* how would i enter data if, for example, i will get a business clearance document?

please help me out. i'm completely lost.

thanks

database suggestions

scias23 — Thu, 03 Dec 2009 14:59:57 GMT

last semester, i did an airline reservation system. we need to create another system for this semester. any suggestions? [except inventory and enrollment systems]

thanks

executing a .java file from another .java file

scias23 — Mon, 12 Oct 2009 11:18:49 GMT

WHAT i want to happen is, when i click the CALCULATOR menu item, my separate Calculator.java will run on the MenuShortCut JFrame.

AGAIN, i want the separate .java file to appear on THE SAME JFrame of MenuShortCut class.

here's what i've got

import javax.swing.*;

import java.awt.event.*;



public class MenuShortcut extends JFrame implements ActionListener{

    JMenuBar menuBar;

    JMenu files,help;

    JMenuItem cs[],calc,game,exit,about;



    public MenuShortcut() {

        super("Team Shrek");

        menuBar = new JMenuBar();

        files = new JMenu("File");

        help = new JMenu("Help");

        cs = new JMenuItem[5];

        calc = new JMenuItem("Calculator");

        game = new JMenuItem("Word Game");

        exit = new JMenuItem("Exit");

        about = new JMenuItem("About");



        for(int i=0;i<5;i++) {

            cs[i] = new JMenuItem("CaseStudy "+(i+1));

            cs[i].addActionListener(this);

            files.add(cs[i]);

        }

        files.addSeparator();

        files.add(calc);

        files.add(game);

        files.addSeparator();

        files.add(exit);



        help.add(about);



        menuBar.add(files);

        menuBar.add(help);



        setJMenuBar(menuBar);



        setSize(250,200);

        setVisible(true);

        setDefaultCloseOperation(EXIT_ON_CLOSE);

    }



    public static void main(String[] args) {

        new MenuShortcut();

    }



    public void actionPerformed(ActionEvent e) {

        //some events here

    }

}

can i do that using this?

Runtime.getRuntime().exec( "java programname.java" );

if yes, codes do i need to add in order to get it working? (i get unreported exception error)

thanks.

insert data into two separate table / 2 queries in same php file

scias23 — Sun, 11 Oct 2009 15:02:46 GMT

i can't get this from working. i want to execute these two queries ebcause i want to insert data to two separate table.

is it possible to do this with one query?

this is what i've got so far:

        $sql = "INSERT INTO login SET 

                studNo = $studNo,

                userName = $user,

                password = $pass,

                dateRegistered = NOW()";

                

        $sql2 = "INSERT INTO users SET 

                studNo = $studNo,

                lastName = $lName,

                firstName = $fName,

                gender = $gender,

                bMonth = $month,

                bDay = $day,

                bYear = $year,

                address = $address,

                cellNo = $phone,

                email = $email";

                

        if(mysql_num_rows(@mysql_query("SELECT * FROM classlist WHERE num = '$studNo'"))) {

                if(mysql_num_rows(@mysql_query("SELECT studNo FROM login WHERE studNo = '$studNo'"))) {

                        $flag = true;

                        $headMsg = "Registration Error";

                        $msg = "You have already registered.";

                }

                else{

                        @mysql_query($sql);

                        @mysql_query($sq2);

                }

        }

        else {

                $flag = true;

                $headMsg = "Registration Unsuccessful";

                $msg = "Your student number doesn't exist in the database.";

        }

enabling relations in phpmyadmin

scias23 — Wed, 30 Sep 2009 11:59:21 GMT

i want to relate my tables, but i can't find out how to relate the tables.

how?

creating login dialog box.

scias23 — Thu, 24 Sep 2009 14:34:04 GMT

how do i create a login dialog box in my database that does this,
1. there are two blank textboxes. one for username, and one for password.
2. when the user clicks the submit button, it will look for a match of the username in the table, then checks if the password entered in the dialog box matches the password record in the database. if not match, it will not login.

what i've created is two textboxes, but the username value appears on the dialog box. i used validation rules so that the user specified in the validation rule can access the database. however, if i want to add new user, i have to modify the validation rule. i don't want it that way. i want it to search the table for matching username.

help!