assalamo alykom
i really tried to make server program(using servlets) to be accessed through a mobile (client part)
but i find some problems as follows the switch case i use keeps telling me that the case are orphaned i don't know ,why?
also the database i made to be accessed by the mobile want to check if its written in write way or noswitch (x) this part plz i think there is some syntax errors plz if u can help don't hesitate at least by correctingthe errors
gazakom allah kol 7'eir isa
my code as follows
import java.util.*;
import java.io.*;
import javax.servlet.*;
import javax.sevlet.http.*;
import java.sql.*;
import java.lang.*;
import java.text.*;
//package ourresults1;
/**
*
* @author shereen
*/
/* Creates a new instance of Main */
// public Main() {
//}
/**
* @param args the command line arguments
*/
// public static void main(String[] args) {
public class urlWriteServle extends HttpServlet {
public void init () throws ServletException
{super.init(config);}
protected void doGet(HttpServletRequest req,HttpServletResponse res) throws ServletException,IoException
{ try
{
connection con=null;
statement stmt=null;
String account=req.getParameter("account");
String pwd=req.getParameter("password");
String outp=accuntLookUp(acct,pwd);
String con;
if(outp==null)
{
res.sendError(res.sc_BAD_REQUEST,"unable to locate account");
return;
}
char array=req.getPrameter(str);
String s=new String(array);
int len=str.lenght();
char x=s.charAt(0);
switch (x)
case 1:
private String serviceLookUp(s.subString(1,len))
{
class_forName("sun.Jdbc.odbc.Jdbcodbc Driver");
con=driverManager.getConnection("C:\My Documents\TIME TABLE");
statement stmt=con.createStatement();
Resultset rs =stmt.executeQuery("select lectureplace from TIMETABLE where Dept=s.subString(7,9)and sec=s.subString(9,11) and lecno=s.charAt(11) and day =s.charAt(12)");
if (rs.next())
{
res.setcontentType("Text/plain");
printWriterOut=res.getWriter();
out.print(lecplace);
out.close();
}
else
return;
}
break;
case 2:
private string placeLookUp(s.subString(1,len))
{ class_forName("sun.Jdbc.odbc.Jdbcodbc Driver");
con=DriverManager.getConnection("C:\My Documents\TIME TABLE");
statement stmt=con.createStatement();
Resultset rs =stmt.executeQuery("select lecturepath from locationtable where lecture place=s.subString(7,10)");
if (rs.next())
{
res.setcontentType("Text/plain");
printWriterOut=res.getWriter();
out.print(lecturepath);
out close();
}
else
return;
}
break;
case 3:
private string timeTableLookUp(s.subString(1,len))
{ class_forName("sun.Jdbc.odbc.Jdbcodbc Driver");
con=DriverManager.getConnection("C:\My Documents\TIME TABLE");
statement stmt=con.createStatement();
Result set rs =stmt.executeQuery("select lecturename,lecplace,lecno from Timetable where dept=s.subString(7,9) and sec=subString(9,11)");
if (rs.next())
{
if (rs.getNumRecord()>0)
{ for(i-0;i<12;i++)
if (rs.gerRecordSize(i)>recData.length)
{ rec.data=new byte [rs.getRecordSize(i)];
len1=rs,getRecord(i,recdata,0);
output=new String(recdata);
}
res.setcontentType("Text/plain");
printWriterOut=res.getWriter();
out.print(lecturename);
out.print(lectureplace);
out.print(lecno);
out.close();
}
else
return;
}
}
break;
case 4 :
private String examLookUp(s.subString(1,len))
{
class_forName("sun.Jdbc.odbc.Jdbcodbc Driver");
con=DriverManager.getConnection("C:\My Documents\TIME TABLE");
statement stmt=con.createStatement();
Result set rs =stmt.executeQuery("select date ,subject,place from Examtable where dept=s.subString(7,9)");
if (rs.next())
{
if (rs.getNumRecord()>0)
{ for(i-0;i<12;i++)
if (rs.gerRecordSize(i)>recData.length)
{ rec.data=new byte [rs.getRecordSize(i)];
len1=rs,getRecord(i,recdata,0);
output=new String(recdata);
}
res.setcontentType("Text/plain");
printWriterOut=res.getWriter();
out.print(date);
out.print(subject);
out.print(place);
out.close();
}
else
return null;
}
}
break;
case 5:
private String emptyClassLookUp(s.subString(1,len))
{
class_forName("sun.Jdbc.odbc.Jdbcodbc Driver");
con=drivermanager.getConnection("C:\My Documents\TIME TABLE");
statement stmt=con.createStatement();
Resultset rs =stmt.executeQuery("select class1 from emptyplacetable where date =s.subString(7,15)");
if (rs.next())
{
res.setcontentType("Text\Plain");
print writeout=res.getWriter();
out print(class1);
out close ();
}
else
return null;
}
break;
case 6:
ptivate string marksLokUp(s.subString(1,len))
{
class_forName("sun.Jdbc.odbc.Jdbcodbc Driver");
con=DriverManager.getConnection("C:\My Documents\TIME TABLE");
statement stmt=con.createStatement();
Result set rs =stmt.executeQuery("select mark,grade from time table where studentname=s.subString(7,58) and dept=(58,01)");
if (rs.next())
{
if (rs.getNumRecord()>0)
{ for(i-0;i<12;i++)
if (rs.gerRecordSize(i)>recData.length)
{ rec.data=new byte [rs.getRecordSize(i)];
len1=rs,getRecord(i,recdata,0);
output=new String(recdata);
}
res.setcontentType("Text/plain");
printWriterOut=res.getWriter();
out.print(mark);
out.print(grade);
out.close();
}
else
//return null;
}
}
break;
default
return null;
finally
{
if (istrm!=null)
istrm.close();
if(istrm!=null)
ostrm.close();
}
}//try
catch (Exception e)
{
return e.toString();
}
}
}