How to Create a GUI application displaying a String in NetBeans: Java Programming

NetBeans provides a simple and easy way to create a new project and display a string in sql programming. The article will let the programmer do the same thing.

• Start NetBeans and create a new project as explained in earlier article. You can change the name of the project otherwise it will automatically set. Add new frame in the same way discussed earlier. By default the name of frame will be NewJFrame.

• Draw a Label control on your frame by dragging it from the Swing Controls section of the Palette.

• To change the name of this Label, right click on its default name, which is JLabel1, under the Inspector window and select Change Variable Name……. command as shown in the image.

• Keeping the label control selected in its design space, do in the Properties window :
  
  Click the ellipsis button of the font property and selected font as:
  Type: Comic Sans MS (you may choose any other font if you wish)
  Style: Bold
  Size: 18

• Type "Computer Programming" (without quotes) in the text property's box or by clicking at its ellipsis button. Now your project window will appear something like:

• Adjust the placement of the title label, whose properties you set just now, by dragging it, so that it appears in the middle horizontally.

• On the same lines, add one more Label to your frame by dragging it from the Palette. Set its font as per you wish. Select the colour of the font by clicking the ellipsis of the foreground property in Properties window. Now specify its text as: "A Complete Programming Blog with SQL, JAVA, C, C#".

• Adjust its placement as per you wishes. Now your project window will appear somewhat like:

• Right click on the jFrame you have created and click on Run File, it will show the frame which will look like:

In this workshop you have learnt about following properties of jLabel control.

• font: The property used to specify the display font, style and size for the display text of the jlabel. Font is selected by clicking ellipsis button in font property's box.
• foreground: The property used to specify foreground color of jLabel, you can select desired colors by clicking of the foreground property.
• text: The property used to specify the display text. You can either type the display text directly in front of text property’s name click to type it in a separate box. Small texts you can type directly, for big texts, its better them separately.

Ranking Functions to Generate Sequential Numbers in Sql Server: SQL Programming

In SQL Programming, ranking functions are used to operate with numeric values. Programmer can easily perform all type of ranking functions to generate sequential numbers for each row based on specific criteria.

You can use ranking functions to generate sequential numbers for each row or to give a rank based on specific criteria. For example, in a manufacturing organization, the management wants to rank the employees based on their salary. To rank the employees, you can use the rank function.

Ranking function return a ranking value for each row. However, based on the criteria, more than one row can get the same rank. You can use the following functions to rank the records:

• row_number
• rank
• dense_rank

All these functions make use of the OVER clause. This clause determines the ascending or descending sequence in which rows are assigned a rank. The row_number function returns the sequential numbers, starting at 1, for the rows in a result set based on a column.

For example, the following SQL query displays the sequential number on a column by using the row_number function:

SELECT BusinessEntityID, Rate, row_number ( ) OVER (ORDER BY Rate desc) AS RANK 
FROM HumanResources.EmployeePayHistory

The following figure displays the output of the preceding query.

dense_rank Function

The dense_rank( ) function is used where consecutive ranking values need to be given based on a specified criteria. It performs the same ranking task as the rank function, but provides consecutive ranking values to an output.

For example, you want to rank the products based on the sales done for that product during a year. If two products A and B have same sale values, both will be assigned a common rank. The next product in the order of sales values, both will be assigned a common rank. The next product in the order of sales values would be assigned the next rank value.

If in the preceding example of the rank function, you need to give the same rank to the employees with the same salary rate and the consecutive rank to the next one. You need to write the following query:

SELECT BusinessEntityID, Rate, dense_rank( ) OVER (ORDER BY Rate desc) AS rank 
FROM HumanResources.EmployeePayHistory

Computer Programming : How to Generate random number in ASP.NET, Example

You can generate random number using Random class. According to msdn library:

Represents a pseudo-random number generator, a device that produces a sequence of numbers that meet certain statistical requirements for randomness.

A Random class exists in System namespace, used to display pseudo-random numbers. The Class has many methods, such as Next() method. Overloaded Next method take different parameters such as zero argument, one argument and two argument.

Random class instance . Next () : Following Code gives Non-negative integer number like 1 to further.
Random class instance . Next (Int32) : You can specify a number, which is maximum for generated output.
Random class instance . Next (Int32, Int32): You can specify minimum and maximum number in parameter, following output generated between specified argument.

Application

1. Mathematical CAPTCHA Design
2. Kids Game.

Lets take an simple example

 <%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default2.aspx.cs" Inherits="Default2" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>Random Number</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:Label ID="Label1" runat="server"></asp:Label>
        <br />
        <br />
        <asp:Button ID="Button1" runat="server" Height="37px" onclick="Button1_Click" 
            Text="Random Number " />
    </div>
    </form>
</body>
</html>
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class Default2 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        
        

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        Random r1 = new Random();
        string s = r1.Next(10, 100).ToString ();
        Label1.Text = s;


    }

}

Code generate following output

      

Computer Programming : How to get System information in ASP.NET, Example

Computer Programming : Easily you can get operating System information using OperatingSystem Class. This class exist in System Namespace. It has single constructor with specified platform identifier and version object. Also contain four public properties, such as Platform, ServicePack, Version and VersionString.

Need of it  

1. Install driver online, if you know about operating system.

Note : Output depends on class constructor parameter.

Lets take a simple

        <%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default2.aspx.cs" Inherits="Default2" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head runat="server">

    <title>Operating System Information</title>

</head>

<body>

    <form id="form1" runat="server">

    <div>

        <asp:Label ID="Label1" runat="server"></asp:Label>

        <br />

        <br />

        <asp:Button ID="Button1" runat="server" Height="37px" onclick="Button1_Click" 

            Text="System Information " />

    </div>

    </form>

</body>

</html>

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

public partial class Default2 : System.Web.UI.Page

{

    protected void Page_Load(object sender, EventArgs e)

    {

        

        

    }

    protected void Button1_Click(object sender, EventArgs e)

    {

        Version ver = new Version();

        OperatingSystem os = new OperatingSystem(PlatformID.Win32S, ver);

        string version = os.Version.ToString();

        string StringVersion = os.VersionString;

        string platform = os.Platform.ToString();

        string servicepack = os.ServicePack.ToString();

        Label1.Text = "Operating System Version=" + version + "<br/>version String=" + StringVersion + "<br/>platform=" + platform + "<br/>Service Pack=" + servicepack;

    }

}

Code generates the following outputs

Computer Programming : Different DateTime format in ASP.NET, Example

DateTime class is used to print date and time of the system/server. Its very useful class in application development or project development. Suppose you want to print current date and time of the system, use DateTime class with Now property.

Label1.Text = DateTime.Now.ToString();

If you want to print only date with special format like date/month/year. Now, use dd/MM/yyyy in ToString() method. Lets take an simple example

Label1.Text = DateTime.Now.ToString("dd/MM/yyyy");

 Similarly again, if you want to print only day of current date then you should take only "dd" in the string parameter.

Label1.Text = DateTime.Now.ToString("dd");

Mathematical Functions to Work with Numerical Values in Sql Server: SQL Programming

In SQL Programming, mathematical functions are used to operate with numeric values. Programmer can easily perform all type of scientific functions as well as simple arithmetic operations using these mathematical functions.

Programmer can use mathematical functions to manipulate the numeric values in a result set. You can perform various numeric and arithmetic operations on the numeric values. For example, you can calculate the absolute value of a number or you can calculate the square or square root of a value.

The following table lists the mathematical functions provided by SQL Server 2005.

• Abs, Returns an absolute value
• Acos, asin and atan, returns the angle in radians whose cosine, sine, or tangent is a floating-point value
• Cos, sin, cot and tan, returns the cosine, sine, cotangent, or tangent of the angle in radians
• Degrees, returns the smallest integer greater than or equal to the specified value
• Exp, returns the exponential value of the specified value
• Floor, returns the largest integer less than or equal to the specified volume
• Log, returns the natural logarithm of the specified value
• Log10, returns the base-10 logarithm of the specified value
• Pi, returns the constant value of 3.141592653589793
• Power, returns the value of numeric_expression to the value of y
• Radians, converts from degrees to radians
• Rand, returns a random float number between 0 and 1
• Round, returns a numeric expression rounded off to the length specified as an integer expression
• Sign, returns positive, negative, or zero
• Sqrt, returns the square root of the specified value

For example, to calculate the round off value of any number, you can use the round mathematical function. The round mathematical function calculates and returns the numeric value based on the input values provided as an argument.

The syntax of the round function is:

round (numeric_expression, length)

where

• numeric_expression is the numeric expression to be rounded off.
• Length is the precision to which the expression is to be rounded off.

The following SQL query retrieves the EmployeeID and Rate for a specified employee id from the EmployeePayHistory table:

SELECT BusinessEntityID, 'Hourly Pay Rate' = round (Rate, 2)

FROM HumanResources.EmployeePayHistory WHERE BusinessEntityID =3

In the result set, the value of the Rate column is rounded off to two decimal places.

While using the round function, if the length is positive, then the expression is rounded to the right of the decimal point. If the length is negative then the expression is rounded to the left of the decimal point. SQL Server provides the following usage of the round function.

• Round (1234.567, 2) outputs 1234.570
• Round (1234.567, 1) outputs 1234.600
• Round (1234.567, 0) outputs 1235.000
• Round (1234.567, -1) outputs 1230.000
• Round (1234.567, -2) outputs 1200.000
• Round (1234.567, -3) outputs 1000.000

Use Date Functions to Operate with Date Values in Sql Server: SQL Programming

In SQL Programming, programmer can use the date functions of the SQL Server to manipulate date-time values. You can either perform arithmetic operations on date values or parse the date values. Date parsing includes extracting components, such as the day, the month, and the year from a date value.

Programmer can also retrieve the system date and use the value in the date manipulation operations. To retrieve the current system date, you can use the getdate function. The following statement displays the current date:

SELECT getdate ( )

The following SQL query uses the datediff function to calculate the difference between the current date and the date of birth of employees in AdventureWorks, Inc. The date of birth of employees is stored in the BirthDate column of the Employee table.

SELECT datediff (yy, BirthDate, getdate()) AS 'Age'
FROM HumanResources.Employee

Outputs:

The following table lists the date functions provided by SQL Server.

• dateadd, adds the number of date parts to the date
• datediff, calculates the number of date parts between two dates
• datename, returns date part from the listed date, as a character value (for example, October)
• datepart, returns date part from the listed date as an integer
• getdate(), returns the current date and time, day, (date), returns an integer, which represents the day getutcdate, returns the current date of the system in Universal Time Coordinate (UTC) time. UTC time is also known as the Greenwich Mean Time (GMT)
• month, returns an integer, which represents the month
• year, returns an integer which represents the year

SQL Server provides the following abbreviation and values of the datepart function

• Year, Abbreviation -- (yy,yyyy),  may have values (1753-9999)
• Qartr, Abbreviation -- (qq, q), may have values (1-4)
• Month, Abbreviation -- (mm, m), may have values (1-12)
• Day of year, Abbreviation -- (dy, y), may have values (1-366)