Java ignore NullPointerException in database? -

-

i new java coming c#. been trying figure out, can't right.

so let's have table following contents:

_id | body                       | partner_jid | bin_id ---------------------------------------------------------- 1   | hello                      | jid_2933219 | group_30 2   | null                       | jid_2933219 | group_30 3   | !cmd                       | jid_2933219 | group_30 4   |                         | jid_2933219 | group_30 5   | example                    | jid_2933219 | group_30

okay, needs happen, row body gets scanned text starts "!cmd" (and if gets found, something). but, once comes down number 2, program quits , returns nullpointerexception.

i have this:

import java.sql.connection; import java.sql.drivermanager; import java.sql.resultset; import java.sql.statement;  public class main {      public static void main(string[] args) {         try {             class.forname("org.sqlite.jdbc");             system.out.println("load driver success");              connection connection = drivermanager.getconnection("jdbc:sqlite:data.db");              string query = "select * messagestable";             statement statement = connection.createstatement();             resultset result = statement.executequery(query);              while(result.next()) {                 int msgid = result.getint("_id");                 string msgbody = result.getstring("body");                 string usrid = result.getstring("partner_jid");                 string grpid = result.getstring("bin_id");                 if(grpid.equals("group_30")){                     system.out.println(msgid);                     system.out.println(msgbody.tolowercase().trim());                     system.out.println(usrid);                     if(msgbody.contains("!cmd")){                         system.out.println("command found!");                     }                 }             }             } catch (exception e) {             system.out.println("read file error");             e.printstacktrace();         }     } }

log:

1 hello jid_2933219 read file error java.lang.nullpointerexception     @ dysanix.message.scanner.main.main(main.java:26)

how make ignore nullpointerexception , continue next one?

if(msgbody.contains("!cmd")){    system.out.println("command found!"); }

if remove line, doesn't give nullpointerexception , prints whole table should, need make when !cmd gets found, how go around doing this?

thanks in advance!!

use boolean , (&&) check null before checking if contains string. like

if (msgbody != null && msgbody.contains("!cmd")) {     // ... }

Comments

Post a Comment

Popular posts from this blog

Django REST Framework perform_create: You cannot call `.save()` after accessing `serializer.data` -

-
i have following viewset: class artistprofileviewset(viewsets.modelviewset): queryset = artistprofile.objects.all() serializer_class = artistprofileserializer def perform_create(self, serializer): if serializer.is_valid(): serializer.save() with following serializers: class simpleartisttrackserializer(serializers.hyperlinkedmodelserializer): class meta: model = artisttrack fields = (...my fields...) class artistprofileserializer(serializers.hyperlinkedmodelserializer): owners = userserializer(many=true, required=false) tracks = simpleartisttrackserializer(many=true, required=false) class meta: model = artistprofile fields = (...my fields...) i getting following error: assertionerror: cannot call `.save()` after accessing `serializer.data`.if need access data before committing database inspect 'serializer.validated_data' instead. i don't see editing serializer.data object. th...
Read more

Why does Go error when trying to marshal this JSON? -

-
i'm trying rather simple example of trying decode json file structs using golang. however, when attempting error that json: cannot unmarshal object go value of type []main.track which don't understand. here's code in question, , json can found here . package main import ( "encoding/json" "fmt" "net/http" "os" ) // tracks group of track types type tracks struct { tracks []track } // track represents singular track type track struct { name string url string artist artist } // artist represents single artist type artist struct { name string mbid string url string } func main() { url := "http://ws.audioscrobbler.com/2.0/?method=geo.gettoptracks&api_key=c1572082105bd40d247836b5c1819623&format=json&country=netherlands" response, err := http.get(url) if err != nil { fmt.printf("%s\n", err) os.exit(1) } de...
Read more