illegal start of expression

Joined
Dec 10, 2009
Messages
1
Reaction score
0
I am reall new to Java and i am havin a problem write my server code.
Can someone help pls?

import java.net.*;
import java.io.*;
import java.sql.*;
/**
* Write a description of class KelvinMailServer here.
*
* @author (your name)
* @version (a version number or a date)
*/
public class KelvinMailServer
{
// instance variables - replace the example below with your own
ServerSocket server;
Socket conn;
ObjectOutputStream connOut;
ObjectInputStream connIn;
String message;

/**
* Constructor for objects of class KelvinMailServer
*/
public KelvinMailServer(int port)
throws IOException, ClassNotFoundException
{
System.out.println( "Creating Server Socket");
server = new ServerSocket(port);

}
public void startServer()
throws IOException, ClassNotFoundException
{
String dbURL = "jdbc:eek:dbc:" + "MailDB";
try
{
System.out.println ("Start Try");
Class.forName ("sun.jdbc.odbc.JdbcOdbcDriver");
System.out.println ("Class Okay");
Connection con = DriverManager.getConnection ( dbURL, "","");
System.out.println ("Connection Okay");
Statement s = con.createStatement();
System.out.println ("Statement Okay");
s.execute ("Select * from Users");
ResultSet rs = s.getResultSet();
if ( rs != null)
while (rs.next())
System.out.println ("Data: " + rs.getString(3) + " " + rs.getString(2));
s.close();
con.close();
}
catch (Exception err)
{
System.out.println ("Error: " + err);
}

System.out.println("Waiting on connection from Client");
conn = server.accept();

System.out.println("Creating Output Stream");
connOut = new ObjectOutputStream( conn.getOutputStream());

System.out.println (" Creating Input Stream");
connIn = new ObjectInputStream(conn.getInputStream());

System.out.println("Sending Initial Message: Initial Message From Server");
connOut.writeObject("READY");

System.out.println ("Reading Input Stream");
message = (String)connIn.readObject();

while(Running.equal = true)
{
if(message.equals("USERS")){
GetUsers(message);
}
if(message.eqals("MSGS")){
GetUsersMessage(message);
}
if(message.eqals("DEL")){
DeletedMessagae(message);
}
if(message.eqals("INSRT")){
InsertMessage(message);
}
if(message.notequals("BYE")){
CloseServer();
}
}

public void GetUsers (message) ( Im gettin error HERE!)
{
s.execute ("Select * from Users");
ResultSet rs = s.getResultSet();
while (rs.next())
connOut.writeObject("DATA\t" + rs.getString(2) + "\t" + rs.getString(3) + "\t" + rs.getString(1));
connOut.writeObject("END");
}

public void GetUsersMessage(message)
{
String[] myString = message.split("\\t")
s.execute ("Select * from where PersonID = userid"));
ResultSet rs = s.getResultSet();
while ( rs.next())
connOut.writeObject("DATA\t" + rs.getString(1) + "\t" + rs.getString(3));
connOut.writeObject("END");
}

public void InsertMessage(message)
{
s.execute ("Select * from Message");
s.execute("Select * from Users");
Insert into message(PersonID, Message) value (mystring[1], [3];
connOut.writeObject("OK");
}

public void DeleteMessage(message)
{
Delete from message where messageId = mystring[1];
conn.writeObject("OK");
}

public void CloseServer()
{
System.out.println("Expecting BYE BYE, msg:" + message);

System.out.println(" Echoing Message Back");
connOut.writeObject("Message From Client was:" + message);

System.out.println("Closing Input Stream");
connIn.close();

System.out.println("Closing Output Stream");
connOut.close();

System.out.println("Closing Server Socket");
connOut.writeObject("END");
}
}
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,769
Messages
2,569,582
Members
45,065
Latest member
OrderGreenAcreCBD

Latest Threads

Top