mossycode

Today we did a further dive on HeidiSQLand learnt more of its commands and functions Did you know SQL is text-based? it will export all of its files in .txt format!! radical :3How SQL reads and processes commandsthis is the order the DB reads its SQL commands:           3                4              1                2   command  selection    location  table name    SELECT         *            ..

a quick and fun tutorial on how to access DB: hacker style :3 1.) open cmd and find the DB file   some useful CMD keywords to use:cd..: it means to go back a directory.you can see everytime we enter it we went back a space, from user1 > Users > C:/ drive dir:  see a list of all directories when you want to know where to go! 2.) find the DB bin where everything is stored 3.) log into DB and creat..

If we want to manage and oversea a database, we can use MariaDB to do just that.https://mariadb.com/downloads/ MariaDB Products & Tools Downloads | MariaDBFind MariaDB downloads, connectors, and tools including Community Server, Enterprise Server, ColumnStore, MaxScale and Xpand.mariadb.com1.) select mariaDB community and select version 11.4.2-GA and windows 64 version before clicking download2...

Today we learnt ways to implement a much more safer jsp page using prepared Statement and Singleton Methdod.However before we dive into that, we covered some simple jsp knowledge and methods to apply into our page.Get & Postthere are lots of HTTP methods: the most commonly used are get and postgetused when openly sharing information: news websites, search barIt exposes the information in the hea..

Jakarta Server Pages (used to be Java Server page)A server-side script language that inserts Java code within HTML script and creates a static web app on the server and uploads into the browser. other sever-side lang: PHP(Hypertext Preprocessor) and ASP (Active Server Pages) JSP work process1.) when called, transitions to Java Servlet2.) compiled in the server3.) Deploys the outcome to the user ..

Today we learnt about the wonders of networking in Java! It was so exciting to find out how we actually receive and send information between users and servers! I adore learning about the ins and outs of CS!Networking?think of it as a web that connect one computer to anotherIt is where two or more computers are connected via a cable (could be a literal or not) to form a network. The network is co..

There are two types of interfaces to use when using Java: CLI and GUI.CLI (Command Line Interface) : this is where we use the cmd panel to execute code. Simple and lightweight but visually minimal and could be limiting.GUI: (Graphic User Interface): Heavier than CLI but visually easier for users to navigate and useToday we focused on GUI!!three main outlets for GUI:AWT: Follow the Operating syst..

Today we started the basics on threads.Honestly the lecture was a little hard to follow so I did some of my own reseach (Geeksforgeeks and chatgpt) to cover some holes in my understanding.I also looked into the Java book hat added a bit more context to the example codes we were using today.Today's notes are a combination of all three :3Usually when processing a code we tend to use a single threa..

Creating a web page using ListsToday we decided to use the List interface we learnt while studying about Collections and incorporate it into pulling data from a database and creating a functioning web page. One of the problems we ran into last time was that the user id and password that was needed was unprotected.So this time we: stored the sensitive info in a seperate class so it can store the ..

Importing data into JSP using mariaDB and try/catch Utilising what we learnt yesterday, we encorporated the try/catch method to import data onto an index.jsp page we have created and launched via Apache Tomcat. Use the setting below to set up a dynamic web project after downloading Apache tomcat. PROTIP: make sure to name the main jsp file as index as that will be the name Java will be searching..