6
hello
i have a problem in the do while loop
where the program will ask the user to enter yes and do an iteration, nut in my example it did not do??
here is the code
[PHP]import java.sql.*;
import java.io.*;
public class Project3A {
public static void main(String[] args) {
String mname="";
String mail="";
String tel="";
String ans="";
try {
System.out.println("Beginning Connection");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String accessFileName = "jdbc:odbc:Project";
String connURL = "jdbc:odbc:;DRIVER=Microsoft Access Driver (*.mdb);DBQ="+accessFileName+".mdb;PWD=";
Connection con = DriverManager.getConnection( accessFileName);
Statement stmt = con.createStatement();
System.out.println("Connection done successfully");
stmt.execute("Create table Member(Name String,EMAIL String,Telephone String)");
System.out.println("Table Created");
do{
System.out.println("Please, Enter the Member Name : ");
InputStreamReader istream = new InputStreamReader (System.in);
BufferedReader br = new BufferedReader (istream);
try{
mname= (br.readLine());
System.out.println("Please, Enter the E-Mail Address : ");
InputStreamReader isr = new InputStreamReader (System.in);
BufferedReader bfr = new BufferedReader (isr);
try
{
mail= (bfr.readLine());
try{
System.out.println("Please, Enter the Telephone number : ");
InputStreamReader ism = new InputStreamReader (System.in);
BufferedReader bb = new BufferedReader (ism);
tel=String.valueOf(bb.readLine());
stmt.execute("insert into Member (Name,EMAIL,Telephone) values ('"+mname+"','"+mail+"','"+tel+"')");
System.out.println("Insertion has been completed");
stmt.execute(" select * from Member");
ResultSet rs=stmt.getResultSet();
if (rs != null)
while (rs.next()){
System.out.println("Name: "+rs.getString("Name")+ " E-MAIL: " + rs.getString("EMAIL")+" Telephone: "+rs.getString("Telephone"));
}
try{
System.out.println("Do you want to insert more records? ");
InputStreamReader is = new InputStreamReader (System.in);
BufferedReader bbb = new BufferedReader (is);
ans=String.valueOf(bbb.readLine());
}
catch (IOException err)
{
System.out.println("Error in reading the numbers");
}
stmt.close();
con.close();
}
catch (IOException err)
{
System.out.println("Error in reading the numbers");
}
}
catch (IOException err)
{
System.out.println("Error in reading the numbers");
}
}
catch (IOException err)
{
System.out.println("Error in reading the numbers");
}
}while(ans=="yes");
}
catch (Exception err) {err.printStackTrace();}
}
}[/PHP]
