Code: Select all
public static void createChat(String chatname, String creatorUsername, String chatMessage) throws SQLException {
// create a database connection
Connection connection = DriverManager.getConnection("jdbc:sqlite:chatdata.db");
PreparedStatement statement = connection.prepareStatement("INSERT INTO chatdata (name, data) VALUES (?, ?);");
statement.setQueryTimeout(30); // set timeout to 30 sec.
Chat newChat = new Chat();
newChat.name = chatname;
Message firstMsg = new Message();
firstMsg.poster = creatorUsername;
firstMsg.messageContent = chatMessage;
newChat.allMessages.add(firstMsg);
newChat.members.add(creatorUsername);
// Create DB if not exists
createDbIfNotExists("chatdata");
// Convert class to json using gson
String chatJson = gson.toJson(newChat);
print(newChat.name);
print(chatJson);
statement.setString(1, chatname);
statement.setString(2, chatJson);
statement.executeUpdate();
}
Code: Select all
public class Chat {
public static String name;
public static ArrayList allMessages = new ArrayList();
public static ArrayList members = new ArrayList();
}
class Message {
public static String poster;
public static String messageContent;
}