Thursday, 16 January 2014

Create Text File From Data Get from Textarea

 public void CreateTextfile() {
//get all data from online chat area and create file for chat history purpose.
        if (!OnlineUserPanel.online_chatArea.getText().equals("")) {


            textFile = new File("D:\\" + sessionClass.username + ".txt");
            BufferedWriter writer = null;

            BufferedWriter outFile = null;
            try {
                outFile = new BufferedWriter(new FileWriter(textFile));

                OnlineUserPanel.online_chatArea.write(outFile);
//            System.out.println("Data Save Successfully.......");
                OnlineUserPanel.online_chatArea.setText("");
            } catch (IOException ex) {
//                ex.printStackTrace();
            } finally {
                if (outFile != null) {
                    try {
                        outFile.close();
                    } catch (IOException e) {
                    }
                }
            }

            upload();
            Insert();
        }

    }

Runtime DataBase Creation

CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_db`(IN `db` TEXT)
    LANGUAGE SQL
    NOT DETERMINISTIC
    CONTAINS SQL
    SQL SECURITY DEFINER
    COMMENT ''
BEGIN
SET @sql = CONCAT('CREATE DATABASE ', db);
  PREPARE stmt FROM @sql;
  EXECUTE stmt;
  DEALLOCATE PREPARE stmt;
END