final string host = "localhost";
final string port = "3306";
final string database = "lys";
final string user = "lys";
final string passord = "lys";
final String driver = "com.mysql.jdbc.Driver";
Connection con = null;

String lysNavn =""; //fra socket
String lysStatus = "";fra socket
String sql ="";
boolean status = false;

if ( lysStatus.equals("ON"))
	status = true;
else if ( lysStatus.equlas("OFF"))
	status = false
else
	//feil
	Sysstem.exit(0);

try {
  Class.forName(driver).newInstance();
  con = DriverManager.getConnection("jdbc:mysql://"+host":"+port+"/"+database,
	user, passord);

  if(!con.isClosed()){
	//koblet til

	 stmt = con.createStatement();
	 sql = " select from lys where navn = '"+lysNavn+"'";
	 ResultSet rs = stmt.executeQuery(sql);
	int rows = rs.getRow();

	if (rows == 1){
		sql = "update lys set status =" +status;
		int ok = stmt.executeUpdate(sql);
		if (ok != 1){
			//noe feilet, ingenting oppdatert
		}else{
			//ok
		}

	}else if (rows == 0){
		//nytt lys lagre i et minne(fil eller database)
	}else{
		//fler treff feil i database VARSEL
	}


  }else{
	//kunne ikke tilkoble
  }

} catch(Exception e) {
  System.err.println("Exception: " + e.getMessage());
} finally {
  try {
	if(con != null)
	  con.close();
  } catch(SQLException e) {}
}