You dint implement the loop well.
One more thing " studentid " should be primary key at databasae level,this
prevents duplicate insertion.
On Tue, Jan 18, 2011 at 4:21 AM, jose luis garcia <[email protected]>wrote:
> you have :
>
>
> do{
> .
> .
> .
> //all cases
>
>
> }while(choice!=0);
>
>
> the sentence "do-while" don´t out go, if you choice 1, 2, 3 ... because the
> cycle "do-while" be repeated while "while(condition==true)".
>
> Therefore the insert is repeat several times.
>
>
>
> 2011/1/17 Parveen Thakur <[email protected]>
>
> HI Friends,
>>
>>
>> Please Help me!! when i Rum this program and insert values in
>> table then multiple rows are created automatically in the data base . I have
>> no idea about this ??
>>
>>
>> code is written below:
>>
>>
>> import java.sql.*;
>> import java.lang.*;
>> import java.util.*;
>>
>>
>>
>> class Student
>> {
>> int choice;
>> int id;
>> float sfees;
>> float fees;
>> float rfees;
>> float balance;
>> String name;
>> String sclass;
>> String phno;
>> String address;
>> String clgename;
>> String course;
>> String stream;
>> String driver="com.mysql.jdbc.Driver";
>> String path="jdbc:mysql://localhost/vee";
>> String root="root";
>> String pass="root";
>> void mainMenu()
>> {
>> Scanner s = new Scanner(System.in);
>>
>> System.out.println("\t********************************");
>> System.out.println("\t\tPlease Select Any One");
>> System.out.println("\t********************************");
>> System.out.println("1.InsertRecord");
>> System.out.println("2.ShowRecord");
>> System.out.println("3.UpdateRecord");
>> System.out.println("4.DeleteRecord");
>> System.out.println("5.SearchRecord");
>> System.out.println("0.Exit");
>> System.out.println("\n\nEnter Choice :");
>> choice=s.nextInt();
>>
>> System.out.println("\t********************************");
>> System.out.println("\t\tSTUDENT DETAIL");
>> System.out.println("\t********************************");
>> System.out.print("Enter id :");
>> id=s.nextInt();
>> System.out.print("Enter name :");
>> name=s.next();
>> System.out.print("Enter sclass :");
>> sclass=s.next();
>> System.out.print("Enter phno :");
>> phno=s.next();
>> System.out.print("Enter address :");
>> address=s.next();
>> System.out.print("Enter clgename :");
>> clgename=s.next();
>> System.out.print("Enter course :");
>> course=s.next();
>> System.out.print("Enter stream :");
>> stream=s.next();
>> System.out.print("Enter fees :");
>> fees=s.nextFloat();
>> System.out.print("Enter rfees :");
>> rfees=s.nextFloat();
>> float totalfees=fees+rfees;
>> System.out.println("Your Totalfees is :"+totalfees);
>> System.out.println("\n\nsubmit sfees :");
>> sfees=s.nextFloat();
>> if(sfees==totalfees)
>> {
>> System.out.println("Your fees is submitted");
>> }
>> else
>> {
>> System.out.println("");
>> }
>> if(sfees==rfees)
>> {
>> balance=totalfees-sfees;
>> System.out.println("your Balance is :"+balance);
>> System.out.println("Your Rfees is submit ");
>> }
>> else
>> {
>> System.out.println("");
>> }
>> if(sfees<totalfees && sfees!=rfees)
>> {
>> balance=totalfees-sfees;
>> System.out.println("your Balance is :"+balance);
>> }
>> else
>> {
>> System.out.println("");
>> }
>>
>> do
>> {
>> switch(choice)
>> {
>> case 1:
>> try
>> {
>>
>> Class.forName(driver);
>> Connection con=DriverManager.getConnection(path,root,pass);
>> PreparedStatement p = con.prepareStatement("insert into studentInfo
>> values(?,?,?,?,?,?,?,?,?,?)");
>> p.setInt(1,id);
>> p.setString(2,name);
>> p.setString(3,sclass);
>> p.setString(4,phno);
>> p.setString(5,address);
>> p.setString(6,clgename);
>> p.setString(7,course);
>> p.setString(8,stream);
>> p.setFloat (9,fees);
>> p.setFloat (10,rfees);
>> p.executeUpdate();
>> p.close();
>> con.close();
>> }
>> catch(Exception e)
>> {
>> System.out.println(e.getMessage());
>> }
>> break;
>> case 2:
>> String select="select * from studentInfo";
>> try
>> {
>> Class.forName(driver);
>> Connection con = DriverManager.getConnection(path,root,pass);
>> Statement st = con.createStatement();
>> ResultSet rs = st.executeQuery(select);
>> while(rs.next())
>> {
>> System.out.println(rs.getString(1)+" "+rs.getString(2)+"
>> "+rs.getString(3)+" "+rs.getString(4));
>> }
>> rs.close();
>> con.close();
>> }
>> catch(Exception e)
>> {
>> System.out.println(e.getMessage());
>> }
>> break;
>> case 3:
>> try
>> {
>> Class.forName(driver);
>> Connection con=DriverManager.getConnection(path,root,pass);
>> PreparedStatement ps =con.prepareStatement("update studentInfo set id=?
>> where id=?,");
>> ps.setInt(1,id);
>> System.out.println(ps.executeUpdate());
>> ps.close();
>> con.close();
>> }
>> catch(Exception e)
>> {
>> System.out.println(e.getMessage());
>> }
>> break;
>> case 4:
>> try
>> {
>> Class.forName(driver);
>> Connection con=DriverManager.getConnection(path,root,pass);
>> PreparedStatement ps = con.prepareStatement("Delete from studentInfo where
>> id=?");
>> ps.setInt(1,id);
>> ps.executeUpdate();
>> ps.close();
>> con.close();
>> }
>> catch(Exception e)
>> {
>> System.out.println(e.getMessage());
>> }
>> break;
>> case 5:
>> try
>> {
>> Class.forName(driver);
>> Connection con = DriverManager.getConnection(path,root,pass);
>> PreparedStatement ps =con.prepareStatement("select id from studentInfo
>> where id=?");
>> ps.setInt(1,id);
>> ResultSet rs = ps.executeQuery();
>> while(rs.next())
>> {
>> System.out.println(rs.getString(1));
>> }
>> rs.close();
>> con.close();
>> }
>> catch(Exception e)
>> {
>> System.out.println(e.getMessage());
>> }
>>
>> break;
>> default:
>> System.out.println("exit(0)");
>> }
>> }while(choice!=0);
>> }
>> }
>> public class StudentDemo
>> {
>> public static void main(String[] args)
>> {
>> Student s = new Student();
>> s.mainMenu();
>> }
>> }
>>
>> --
>> Best Regards And Thanks :
>> Parveen Thakur,
>> Contact no.-9988208440.
>>
>> --
>> To post to this group, send email to
>> [email protected]
>> To unsubscribe from this group, send email to
>> [email protected]<javaprogrammingwithpassion%[email protected]>
>> For more options, visit this group at
>> http://groups.google.com/group/javaprogrammingwithpassion?hl=en
>
>
> --
> To post to this group, send email to
> [email protected]
> To unsubscribe from this group, send email to
> [email protected]<javaprogrammingwithpassion%[email protected]>
> For more options, visit this group at
> http://groups.google.com/group/javaprogrammingwithpassion?hl=en
>
--
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/javaprogrammingwithpassion?hl=en
