Ahesanali Khanusiya

In my application there are three users name are : student,faculty,admin.when i made registration at that i am askig which user they are? but i am confused how its possible when user is going for login at that which user is going for login? In my login form i have put username and password field. Now how I am doing than i am checking which user is login?

please help me

yes they are types of user...one table of user in which userid-pk and usertype fields another table login in which loginid-pk,username,password and userid-fk third is register in which sign up detail and loginid-fk

Hello,

I am making one application in which 3 users are there. I am confused at the time login how can i know that which user is login and which page I have to call and also tell me primary key and foreign key of table. my users are: STUDENT,FACULTY,ADMIN if possible than explain with some example.

if i click button in swing and i want go other page of swing than how its possible.....

when I click any JButton than I want redirect one frame to another frame how its possible can you explain with example....

I am not passing that values but I am insert that value in my swing component of text field by user its not static variable.

query string is: String query = "insert into studentdetails(fname,mname,lname,address,mobile,age,gender,tenyear,tenper,twlyear,twlper,gradyear,gradper) values ('" + student.getFname() + "','" + student.getMname() + "','" + student.getLname() + "','" + student.getAddress() + "','" + student.getMobile() + "','" + student.getAge() + "','" + student.getGender() + "','" + student.getTenyear() + "','" + student.getTenper() + "','" + student.getTwlyear() + "','" + student.getTwlper() + "','" + student.getGradyear() + "','" + student.getGradper() + "')";


table format is:
CREATE TABLE `studentdetails` ( `studentDetailsId` int(10) unsigned NOT NULL AUTO_INCREMENT, `fname` varchar(25) NOT NULL, `mname` varchar(25) NOT NULL, `lname` varchar(25) NOT NULL, `address` varchar(45) NOT NULL, `mobile` int(10) unsigned NOT NULL, `age` int(10) unsigned NOT NULL, `gender` varchar(15) NOT NULL, `tenyear` varchar(15) NOT NULL, `tenper` int(10) unsigned NOT NULL, `twlyear` varchar(15) NOT NULL, `twlper` int(10) unsigned NOT NULL, `gradyear` varchar(15) NOT NULL, `gradper` int(10) unsigned NOT NULL, PRIMARY KEY (`studentDetailsId`) )


Exception is: java.lang.NumberFormatException: For input string: "123456789"

I want insert integer data in database but i am not able to do this... i am attaching my whole applicationpackage com.niit.student; import java.awt.*; import javax.swing.*; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.util.ArrayList; public class StudentApplication implements ActionListener { //create all lable,textfield and declare variable ArrayList studentList; StudentDao student; JLabel jlbfname, jlblname, jlbmname, jlbaddress, jlbmobile, jlbgender, jlbage, jlb10year, jlb10per, jlb12year, jlb12per, jlbgradyear, jlbgradper; JTextField jtxtaddress, jtxtfname, jtxtlname, jtxtmname, jtxtmobile, jtxtage, jtxt10year, jtxt10per, jtxt12year, jtxt12per, jtxtgradyear, jtxtgradper, jtxtgender; JButton jbtsave, jbtclose; JComboBox jcbgender; JFrame jframe; String fname, lname, mname, gender, address, tenyear, twlyear, gradyear; int mobile, age, tenper, twlper, gradper; Container cpan; public static void main(String arg[]) { new StudentApplication(); } public StudentApplication() { //initalise all variable fname = ""; lname = ""; mname = ""; gender = ""; address = ""; tenyear = ""; //tenper = 0; twlyear = ""; //twlper = 0; gradyear = ""; // gradper = 0; // mobile = 0; // age = 0; creatGUI(); studentList = new ArrayList(); try { student = new StudentDao(); } catch (Exception ex) { System.out.println("Exception in Student Dao" + ex); } } public void creatGUI() { jframe = new JFrame("Student Personal Detail"); cpan = jframe.getContentPane(); cpan.setLayout(new GridBagLayout()); arrangeComponent(); jframe.setSize(600, 600); jframe.setResizable(false); jframe.setVisible(true); jframe.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); } //Arrange Component In container and add action listener in Jbutton public void arrangeComponent() { jlbfname = new JLabel("First Name"); jlbmname = new JLabel("Middle Name"); jlblname = new JLabel("Last Name"); jlbaddress = new JLabel("Address"); jlbmobile = new JLabel("Mobile No"); jlbgender = new JLabel("Gender"); jlbage = new JLabel("Age"); jlb10year = new JLabel("Passing Year Of 10th"); jlb10per = new JLabel("Percentage In 10th"); jlb12year = new JLabel("Passing Year Of 12th"); jlb12per = new JLabel("Percentage In 12th"); jlbgradyear = new JLabel("Passing Graduation Year"); jlbgradper = new JLabel("Aggrigate In Graduation"); jtxtfname = new JTextField(20); jtxtmname = new JTextField(20); jtxtlname = new JTextField(20); jtxtaddress = new JTextField(20); jtxtmobile = new JTextField(20); jtxtgender = new JTextField(10); jtxtage = new JTextField(20); jtxt10year = new JTextField(20); jtxt10per = new JTextField(20); jtxt12year = new JTextField(20); jtxt12per = new JTextField(20); jtxtgradyear = new JTextField(20); jtxtgradper = new JTextField(20); jbtsave = new JButton("Save Student"); jbtclose = new JButton("Close"); i have added all component in Jframe } public void actionPerformed(ActionEvent e) { if (e.getSource() == jbtsave) { saveStudent(); } else if (e.getSource() == jbtclose) { System.exit(0); } } //insert student record into database public void saveStudent() { fname = jtxtfname.getText(); mname = jtxtmname.getText(); lname = jtxtlname.getText(); address = jtxtaddress.getText(); gender = jtxtgender.getText(); tenyear = jtxt10year.getText(); twlyear = jtxt12year.getText(); gradyear = jtxtgradyear.getText(); try { mobile = Integer.parseInt("" + jtxtmobile.getText()); age = Integer.parseInt("" + jtxtage.getText()); tenper = Integer.parseInt("" + jtxt10per.getText()); twlper = Integer.parseInt("" + jtxt12per.getText()); gradper = Integer.parseInt("" + jtxtgradper.getText()); } catch (Exception e) { System.out.println("Exception in main method" + e); } if (fname.equals("")) { JOptionPane.showMessageDialog(null, "Enter Student Name"); } else { StudentBean studentbn = new StudentBean( fname, mname, lname, address, gender, mobile, age, tenyear, tenper, twlyear, twlper, gradyear, gradper); try { student.saveStudent(studentbn); } catch (Exception ex) { System.out.println("Exception caught in save student method in main" + ex); } JOptionPane.showMessageDialog(null, "Student Saved"); } } }

another database connectivity file ispackage com.niit.student; import java.util.ArrayList; import java.sql.*; public class StudentDao { private ArrayList student; private Connection con; public StudentDao() throws Exception { student = new ArrayList(); getConnection(); } public Connection getConnection() throws Exception { Class.forName("com.mysql.jdbc.Driver"); con = DriverManager.getConnection("jdbc:mysql:///student", "root", "root"); return con; } public void saveStudent(StudentBean student) throws Exception { String query = "insert into studentdetails(fname,mname,lname,address,mobile,age,gender,tenyear,tenper,twlyear,twlper,gradyear,gradper) values ('" + student.getFname() + "','" + student.getMname() + "','" + student.getLname() + "','" + student.getAddress() + "','" + student.getMobile() + "','" + student.getAge() + "','" + student.getGender() + "','" + student.getTenyear() + "','" + student.getTenper() + "','" + student.getTwlyear() + "','" + student.getTwlper() + "','" + student.getGradyear() + "','" + student.getGradper() + "')"; Statement s = con.createStatement(); s.executeUpdate(query); } }

I want to definition of Core java and Object Oriented Programing please explain n briefs....

I want to fetch all record from database and display in Swing component Jtable can you tell me how it will done??? Please explain with example.........

I want to align Jlable and Jtextfield Component in single line then which layout manager I used and how....