A Word About Secure Database Access
Unfortunately, this database access code exhibits insecurities of its own. For example, you should never use the sa account (or an equivalent) to access databases from Web applications. Instead, use weak accounts that lack permission to drop tables, insert, update, and delete records, and the like. In addition, you should use stored procedures or parameterized commands in lieu of dynamic SQL commands for added protection against malicious input parameters. Finally, consider encrypting database connection strings to minimize the risk of information disclosure if your source code falls into the wrong hands. And note that truly paranoid ASP.NET programmers encrypt connection strings and store them in ACLed registry keys. When it comes to Web security, a little paranoia can be a good thing.
Read the rest of this entry »
Graphical objects, also known as entities, are the visible objects (lines, circles, raster images, and so forth) that make up a drawing. Each graphical object has methods that allow an application to perform most of the AutoCAD editing commands, such as Copy, Erase, Move, Mirror, and so forth. These objects also have methods for setting and retrieving extended data (xdata), highlighting and updating, and retrieving the bounding box of the object. Graphical objects have typical properties such as Layer, Linetype, Color, and Handle. They also have specific properties, depending on their object type, such as, Center, Radius, and Area.
—ActiveX Automation User’s Guide, AutoCAD help file
Read the rest of this entry »
This tutorial demonstrates how to import an ESRI shapefile into an Access database using the ArcCatalog. Microsoft Access databases are compatible with ArcGIS, as tables within Access databases can be directly accessed by ArcGIS and added to ArcMap. When geographic boundary files are exported to an Access database, the database can then serve as a personal geodatabase: a container for organizing and storing multiple geographic boundary files and data tables. (see the How to Import Data into Microsoft Access tutorial for importing data tables into Access).
Read the rest of this entry »
This tutorial shows a simple example using Hibernate. We will create a simple Java application, showing how Hibernate works. Hibernate is a solution for object relational mapping and a persistence management solution or persistent layer. This is probably not understandable for anybody learning Hibernate.
Read the rest of this entry »
This laboration is split in two parts, the first part about simple HTML programming and the last about SQL databases, with focus on MySQL databases
Read the HTML tutorial on http://www.w3schools.com adn the MySQL tutorial on http://www.mysql.com/doc/en/Tutorial.html. If you don’t have access to a MySQL database read the examples in the tutorial, these will be a great help when you start to solve the Tasks on the MySQL database. You should also be familiar with the Language Reference section.
Read the rest of this entry »
WHAT IS A MySQL DATABASE ?
A MySQL database is just a useful way to store and order a lot of information. “Databases are most useful when it comes to storing information that fits into logical categories. For example, say that you wanted to store information of all the employees in a company. With a database you can group different parts of your business into separate tables to help store your information logically. Example tables might be: Employees, Supervisors, and Customers. Each table would then contain columns specific to these three areas.”
Read the rest of this entry »
This part will help you familiarize yourself with MySQL by providing a tutorial for you to try. As you work through it, you will create a sample database and some tables, and then interact with the database by adding, retrieving, deleting, and modifying information in the tables. During the process of working with the sample database, you will learn the following things:
Read the rest of this entry »
FlowJo (Macintosh) Manual for Macintosh Workspace Overview Workspace Overview Adding Samples Groups Batch Analysis Statistics Summary of Drag and Drop Examples Keyword Search and Replace Graph Window Bivariate display Univariate displays Graph Types Bivariate displays Univariate displays Gating Autogating Tool Backgating PolyVariate Display Output SciBook The Layout Editor Copying Graphs Tables Iteration (Batching) Iterating in the Layout Editor Changing the Iteration Value FlowJo (Macintosh) Formulas in Tables Insert Function Text (String) functions:
Read the rest of this entry »