Archive

Archive for the ‘Computer Programming’ Category

Using Git with Netbeans

February 8, 2018 Leave a comment

https://docs.google.com/presentation/d/1ZHRYKARAssKZhMeaJluoH31pHM53rUyZ3zia_KkB78s

Advertisements

Pygame resource

January 9, 2018 Leave a comment

Program arcade games, apparently. This site has been recommended to me for those interested in Python game development.

http://programarcadegames.com/

Inserting Multiple Rows into a SQLite Database from Java

November 26, 2017 Leave a comment
package sqlitetest;
import java.sql.*;

public class SqliteTest {

    public static void main(String args[]) {
        Connection connection = null;

        try {
            /* The next line will give a ClassNotFound error unless the
               sqlite jar is in the classpath. To add it in Netbeans, 
               right-click on the project, choose Properties, Libraries 
               and add the path to the jar file. On Linux I saved it in 
               /usr/local/sqlite/sqlite-jdbc-3.20.0.jar, but this will be
               different if you are using Mac or Windows.
            */
            Class.forName("org.sqlite.JDBC");
            connection = DriverManager.getConnection("jdbc:sqlite:test.db");

            // The database must already have a country table with these fields.
            // In my table there is also a CountryId primary key field, but the
            // database assigns values to that field automatically.
            String sql = "insert into Country (CountryName, Population) values (?, ?)";
            PreparedStatement ps = connection.prepareStatement(sql);


            // In larger applications you would probably loop through a list
            // of country objects. This is just a simple demo.

            ps.setString(1, "United States of America");
            ps.setString(2, "320000000");
            ps.addBatch();

            ps.setString(1, "China");
            ps.setString(2, "1400000000");
            ps.addBatch();

            ps.executeBatch();
            connection.close();

        } catch (Exception e) {
            System.err.println(e.getClass().getName() + ": " + e.getMessage());
            System.exit(0);
        }
        System.out.println("Insert successful");
    }
}

Simple chat server in Python

November 24, 2017 Leave a comment

Add the following code to server.py and run.

# server.py
#!/usr/bin/python

import socket

sock = socket.socket()
host = 'localhost' # Change this to "" to receive connections from any host
port = 12221  # Any unreserved port but must be same as client
sock.bind((host, port))

sock.listen(5)
conn = None

while True:
   if conn is None:
       # Halts
       print ('[Waiting for connection...]')
       conn, addr = sock.accept()
       print('Got connection from', addr)
   else:
       # Halts
       print ( '[Waiting for response...]')
       print (conn.recv(1024))
       msg = input("Enter something to this client: ")
       conn.send(msg.encode('UTF-8'))

Add the following code to client.py.

# client.py
#!/usr/bin/python

import socket

sock = socket.socket()
host = 'localhost' # Change this to remote ip as necessary
port = 12221 # Any unreserved port but must be same as server

sock.connect((host, port))
print ('Connected to', host)

while True:
msg = input("Enter something for the server: ")
sock.send(msg.encode('UTF-8'))
# Halts
print ('[Waiting for response...]')
print (sock.recv(1024))

Nice Tkinter Tutorial

November 14, 2017 Leave a comment

Code is STUFF

November 9, 2017 Leave a comment

In English we distinguish between count nouns and non-count or mass nouns. Consider what feels wrong about these sentences:

  • My glass is full of waters.
  • I’ve got sands in my shoes.
  • Could I borrow a money?
  • I want to buy a furniture.

The reason these are wrong is that water, sand, money and furniture are examples of mass nouns. They are STUFF. You cannot pluralize stuff and you cannot refer to “a stuff”.

Why am I telling you this? Because “code”, as in lines of computer code, is also a mass noun. Code is STUFF. You cannot refer to “codes” and you cannot write “a code”.

Please try to remember this!

Course Information for All Courses 2017-2018

August 15, 2017 Leave a comment