Logic At work

Why Learn Google Web Tool Kit at LogicAtWork.org ?

Puneet Arora — Thu, 26 Nov 2009 17:42:38 GMT

1If you ask a experience programmer working in any the web technology
platform , you will find that 80% of the time is spent not in writing code
but in understanding the ever changing behaviors of various browsers and
making a web page look nice when is moved due to user interaction . Some
times , it is too frustrating without a meticulously working web designer .

2If you ask a whether the principals of â€œReUse of Code â€œ are implemented or
not ,then will be both yes and no ? Do you why it is difficult task to do
for programming team â€¦especially in case we need to maintain and reuse
â€œJavascript Code â€œ .

3If you ask any programmer ? Have you ever calculated the burden of
reinventing the wheel again and again .., I mean learn a new technology or
language .., make the same

Controls , forms etc.., believing that you are learning the best and latest
techno.., only to find some new , more convincing technology has arrived .
He would say , I do not know

about the â€œHow many hours mankind spends on learning and unlearning
technologies ?â€

but , I m very uncomfortable to spend more and more hours on Learning new
techo buzzes .

Any way , this article in no way is going to debate the questions above ,but
will try to give some solutions for above said issues for buddy programmers
and senior programmers ..?

Check out !, This new Google Web Tool Kit , it helps to build
applications which have following benefits for programmer community .

a) Faster JavaScript: GWT takes advantage of concept of cross compilers , It
simply compiles the java in to javascript . You do have learn javascript as
separate entity .

By Compiling java into javascript it enhances the performance of the web
application to

Better scale .

b) Browser-specific optimizations:GWT has great features which also includes
optimization of the AJAX specific to browser . Some for which I personally
have many times got uncomfortable in other technologies .

c) Cross Compiler Optimization features : The compiler does numerous
optimizations to make code perform better .

d) Google's GWT provides the development community with a set of resources
enabling them to create web-based applications with relative ease and
support .

e) You can Edit Java code, then view changes immediately without
re-compiling , thus saving production time

f) Easy Debugging : Step through live AJAX code with your Java debugger and
check applications internals .

g) GWT supports an open-ended set of transfer protocols such as JSON and
XML, but GWT RPC makes all-Java communications particularly easy and
efficient.

h) Easily support the browser's back button and history

i) It works wonders with Google App Engine .

*We, at LogicAtwork.org understand the benefits of learning Google based
technology , therefore introduced here in chandigarh and Baddi(Himachal
Pradesh) Centers . This training program is best suited for students who
want to take Java as core competency skill to build their career. Google Web
Tool kit advance training program assumes that you already are familiar with
one programming language , HTML and CSS . Come join in , The Google
Platform of Success ! , For Course details email us at gwt@ecologic.co.in*

* *

Warm regards,

Puneet Arora
Ecologic Corporation
http://www.ecologic.co.in
H.O : 2138 , Sector 22 -C ,Chandigarh
Mobile: 9872856485
IM : puneet@ecologic.co.in
Branch Office: 360, Level III , Motia Plaza
Baddi, Himachal Pardesh

Creating Web Data Entry Form in Entity Frame Work in ASP.NET

Puneet Arora — Sat, 21 Nov 2009 11:07:12 GMT

Creating Web Data Entry Form in Entity Frame Work in ASP.NET

Step 1: Create New ASP.Net Project .

Step 2: Add New Item Ã Model.edmx

Step 3: Follow Entity Frame Work Wizard Steps 1

Step 4: Create Entity Model from the DataBase

Step 5: Once model is Create Now Create a New ItemÃ WebForm

Step 6: Choose the Table for which DataEntry Form is going to be made .

Step 7 : In Our Case we are taking a Table = Entity called â€œDashBoard â€œ

*Step 8: How to LoadData from Table called DashBoard*

* *

* *

Dim db As New YourModel.YourEntities**

* *

'''

''' This Method Show Data in Grid View from Table

'''

'''

'''

Private Sub LoadData()

Try

Dim var = From c In db.Dashboard

GridView1.DataSource = var

GridView1.DataBind()

Catch ex As Exception

ErrMsg.Text = ex.Message

End Try

End Sub

*Step 9 : As you see above , we need to add a GridView to show the Data *

*In the Web Form . *

* *

* *

*Step 10: *

* *

*How to Save Data *

* *

* *

'''

''' This Function has two modes Mode= Insert New Row , Mode = 2 Update a
Row

'''

'''

Private Sub Save()

Try

Dim c As New Dashboard

â€˜ This mode is for Inserting.on Add Data Button

If Mode = 1 Then

c.ID = HfKey.Value â€˜Last Primary Key Value

c.UserManagement = txtUserManagement.Text

c.MaterialManagement = txtMatrialManagement.Text

c.CustomerManagement = txtCustomerManagement.Text

c.SalesManageManagemet = txtSalesManageManagement.Text

c.JobManagement = txtJobManagement.Text

c.VendorManagement = txtVendorManagement.Text

c.JobMasterData = txtJobMasterData.Text

db.AddToDashboard(c) â€˜Add to the Object Conceptual Model

db.SaveChanges() â€˜ Now Add to Storage Model/Database

End If

â€˜ This mode is for Updating .on UpDateButton

If Mode = 2 Then

Dim e = (From b In db.Dashboard _

Where b.ID = HfKey.Value _

Select b).First

e.UserManagement = txtUserManagement.Text

e.MaterialManagement = txtMatrialManagement.Text

e.CustomerManagement = txtCustomerManagement.Text

e.SalesManageManagemet = txtSalesManageManagement.Text

e.JobManagement = txtJobManagement.Text

e.VendorManagement = txtVendorManagement.Text

e.JobMasterData = txtJobMasterData.Text

db.SaveChanges() â€˜ Save Changes to Storage Model/Database

Else

MsgBox("Not IN MODE 2")

End If

MView1.ActiveViewIndex = 0

LoadData()

Catch ex As Exception

ErrMsg.Text = ex.Message

End Try

End Sub**

* *

Protected Sub btnSave_Click(ByVal sender As Object, ByVal e AsSystem.EventArgs)
Handles btnSave.Click

Save()

End Sub**

* *

* *

* *

* *

*Step 11:*

*How to Delete Data *

'''

''' This Function Delete Data from Table

'''

'''

'''

Private Sub DeleteData(ByVal ID As Long)

Try

Dim e = (From b In db.Dashboard _

Where b.ID = ID _

Select b).First

db.DeleteObject(e)

db.SaveChanges()

LoadData()

Catch ex As Exception

Throw ex

End Try

End Sub

Enjoy Learning New things in Coding ! **

Warm regards,

Puneet Arora
Ecologic Corporation
http://www.ecologic.co.in
H.O : 2138 , Sector 22 -C ,Chandigarh
Mobile: 9872856485
IM : puneet@ecologic.co.in
Branch Office: 360, Level III , Motia Plaza
Baddi, Himachal Pardesh

Creating Search Web Form in LINQ using VB. NET

Puneet Arora — Sat, 21 Nov 2009 10:45:38 GMT

Creating Search Form in LINQ using VB.NET

Step 1: Create Two Text Boxes , Grid View (to show results) , Search Button
to fire LINQ Search Query , in New ASP.NET Website ASPX Page .

Step 2: Add New Item Ã LINQ2SQL in App_Code of your ASP.NET Website Project

Step 3: Drag & Drop the Tables of NorthWind(DB) using Sever Explorer on
LINQ ORM Tool space

Step 4 : Now letâ€™s us take the Table Customers of NorthWind and Drop it on
LINQ ORM

(Object Relational Mapping Tool)

Step 5 : Now , It is time to work on the Search.aspx Page â€˜s Code Behind
File i.e

Code File -Ã Search.vb

Step 6:

Protected Sub Search_Click(ByVal sender As Object, ByVal e AsSystem.EventArgs)
Handles Button1.Click

Try

Using context As New NorthWindDataContext

Dim Customers = From c In context.Customers _

Where c.ContactName.Contains(TextBox1.Text.Trim()) _

AndAlso c.CompanyName.Contains(TextBox2.Text) _

Order By c.CustomerID Descending

GridView1.DataSource = Customers

GridView1.DataBind()

End Using

Catch ex As Exception

Throw ex

End Try

End Sub

Step 7 : Run and Check .., you can change the query Using Or or OrElse
Operator also .

Happy Learning !

Warm regards,

Puneet Arora
Ecologic Corporation
http://www.ecologic.co.in
H.O : 2138 , Sector 22 -C ,Chandigarh
Mobile: 9872856485
IM : puneet@ecologic.co.in
Branch Office: 360, Level III , Motia Plaza
Baddi, Himachal Pardesh

Move First Move Last Move Next In WinForms 2008 VB.NET

Puneet Arora — Tue, 17 Nov 2009 18:17:00 GMT

' Step 1 : Create a Table

    'CREATE TABLE [dbo].[emp](
    '   [empid] [int] NULL,
    '   [empname] [varchar](50) NULL
    ') ON [PRIMARY]

    'GO

Step 2: INSERT DATA INTO THE TABLE "insert into emp Values(1,'Jaspreet Singh')
Step 3 : Write Next , Previous and LoadData Code as Follows , Since there are two Fields in the Table we need to create
                  a From having Two TextBoxs and NEXT and PREVIOUS buttons

    Dim dbDataSet As New DataSet
    Shared rowNum As Integer = 0
    Shared dbMaxNumRows As Integer

    ''' <summary>
    ''' Load the First Row
    ''' Get the Max Number of Rows in the Table
    ''' </summary>
    ''' <remarks></remarks>
    Private Sub LoadData()
        Dim con As New SqlConnection
        con.ConnectionString = "server=ECOLOGIC\SQLEXPRESS;initial catalog=testDB;integrated security=true"
        con.Open() ' Open the Database
        Dim sql As String = "Select   * from Emp" ' Emp Table
        Dim da As New SqlDataAdapter(sql, con)
        da.Fill(dbDataSet)
        Dim dr As DataRow
        For Each dr In dbDataSet.Tables(0).Rows
            TextBox1.Text = dbDataSet.Tables(0).Rows(rowNum).Item("empid") ' First Coluum
            TextBox2.Text = dbDataSet.Tables(0).Rows(rowNum).Item("empname") ' Second Coluum
        Next

        dbMaxNumRows = dbDataSet.Tables(0).Rows.Count - 1
        Me.Text = dbMaxNumRows ' Display the Max Row - 1
    End Sub

    ''' <summary>
    ''' Next Button
    ''' </summary>
    ''' <param name="sender"></param>
    ''' <param name="e"></param>
    ''' <remarks></remarks>

    Private Sub btnNext_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnNext.Click

        ' Next Listing

        If rowNum <> dbMaxNumRows Then

            rowNum = rowNum + 1

            TextBox1.Text = dbDataSet.Tables(0).Rows(rowNum).Item("empid")
            TextBox2.Text = dbDataSet.Tables(0).Rows(rowNum).Item("empname")

        Else

            rowNum = 0
            'Fill in all the needed fields
            TextBox1.Text = dbDataSet.Tables(0).Rows(rowNum).Item("empid")
            TextBox2.Text = dbDataSet.Tables(0).Rows(rowNum).Item("empname")

        End If
    End Sub


    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        LoadData()
    End Sub

    ''' <summary>
    ''' This is the Previous Button
    ''' </summary>
    ''' <param name="sender"></param>
    ''' <param name="e"></param>
    ''' <remarks></remarks>
    Private Sub btnPrevious_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
        rowNum = rowNum - 1
        If rowNum < 0 Then
            ' Go to the First
            rowNum = 0
            Me.Text = "Last Record :" & rowNum
        Else

            TextBox1.Text = dbDataSet.Tables(0).Rows(rowNum).Item("empid")
            TextBox2.Text = dbDataSet.Tables(0).Rows(rowNum).Item("empname")
            Me.Text = "Record Number :" & rowNum
        End If

    End Sub
End Class

How to create Orkut kind of Website in ASP.NET using Linq2SQL

Puneet Arora — Sun, 08 Nov 2009 18:24:06 GMT

How to create Orkut kind of Website in ASP.NET

View more presentations from Puneet Arora.

Warm regards,

Puneet Arora
Ecologic Corporation
http://www.ecologic.co.in
H.O : 2138 , Sector 22 -C ,Chandigarh
Mobile: 9872856485
IM : puneet@ecologic.co.in
Branch Office: 360, Level III , Motia Plaza
Baddi, Himachal Pardesh

Invitation to connect on LinkedIn

Puneet Arora — Tue, 03 Nov 2009 07:34:56 GMT

LinkedIn
------------

Logic,

I'd like to add you to my professional network on LinkedIn.

- Puneet

Accept Puneet Arora's invite:
https://www.linkedin.com/e/isd/836787884/K9ERJFOs/

------
(c) 2009, LinkedIn Corporation

Coming Soon Tutorial ON How to LINQ !

Puneet Arora — Thu, 29 Oct 2009 21:37:56 GMT

Coming Soon Tutorial ON How toÂ LINQ !

Warm regards,

Puneet Arora
Ecologic Corporation
http://www.ecologic.co.in
H.O : 2138 Â , Sector 22 -C ,Chandigarh

Mobile: 9872856485
IM : puneet@ecologic.co.in
Branch Office: 360, Level III , Motia Plaza
Baddi, Himachal Pardesh

Coming Soon ARTICLES ON Silver Light 3.0

Puneet Arora — Thu, 29 Oct 2009 21:31:20 GMT

Warm regards,

Puneet Arora
Ecologic Corporation
http://www.ecologic.co.in
H.O : 2138 Â , Sector 22 -C ,Chandigarh
Mobile: 9872856485
IM : puneet@ecologic.co.in

Branch Office: 360, Level III , Motia Plaza
Baddi, Himachal Pardesh

How to upload Image in JFrame in Java

Puneet Arora — Tue, 18 Aug 2009 11:26:56 GMT

/** Returns an ImageIcon, or null if the path was invalid. */
protected ImageIcon createImageIcon(String path,
String description) {
java.net.URL imgURL = getClass().getResource(path);
if (imgURL != null) {
return new ImageIcon(imgURL, description);
} else {
System.err.println("Couldn't find file: " + path);
return null;
}
}

Example for Loading Images in Frame

public class IconDemoApp extends JFrame {

private JLabel photographLabel = new JLabel();
private JToolBar buttonBar = new JToolBar();

private String imagedir = "images/";

private MissingIcon placeholderIcon = new MissingIcon();

/**
* List of all the descriptions of the image files. These correspond one
to
* one with the image file names
*/
private String[] imageCaptions = { "Original SUNW Logo", "The
Clocktower",
"Clocktower from the West", "The Mansion", "Sun Auditorium"};

/**
* List of all the image files to load.
*/
private String[] imageFileNames = { "sunw01.jpg", "sunw02.jpg",
"sunw03.jpg", "sunw04.jpg", "sunw05.jpg"};

/**
* Main entry point to the demo. Loads the Swing elements on the "Event
* Dispatch Thread".
*
* @param args
*/
public static void main(String args[]) {
SwingUtilities.invokeLater(new Runnable() {
public void run() {
IconDemoApp app = new IconDemoApp();
app.setVisible(true);
}
});
}

/**
* Default constructor for the demo.
*/
public IconDemoApp() {
setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
setTitle("Icon Demo: Please Select an Image");

// A label for displaying the pictures
photographLabel.setVerticalTextPosition(JLabel.BOTTOM);
photographLabel.setHorizontalTextPosition(JLabel.CENTER);
photographLabel.setHorizontalAlignment(JLabel.CENTER);
photographLabel.setBorder(BorderFactory.createEmptyBorder(5, 5, 5,
5));

// We add two glue components. Later in process() we will add
thumbnail buttons
// to the toolbar inbetween thease glue compoents. This will center
the
// buttons in the toolbar.
buttonBar.add(Box.createGlue());
buttonBar.add(Box.createGlue());

add(buttonBar, BorderLayout.SOUTH);
add(photographLabel, BorderLayout.CENTER);

setSize(400, 300);

// this centers the frame on the screen
setLocationRelativeTo(null);

// start the image loading SwingWorker in a background thread
loadimages.execute();
}

/**
* SwingWorker class that loads the images a background thread and calls
publish
* when a new one is ready to be displayed.
*
* We use Void as the first SwingWroker param as we do not need to
return
* anything from doInBackground().
*/
private SwingWorker loadimages = new
SwingWorker() {

/**
* Creates full size and thumbnail versions of the target image
files.
*/
@Override
protected Void doInBackground() throws Exception {
for (int i = 0; i < imageCaptions.length; i++) {
ImageIcon icon;
icon = createImageIcon(imagedir + imageFileNames[i],
imageCaptions[i]);

ThumbnailAction thumbAction;
if(icon != null){

ImageIcon thumbnailIcon = new
ImageIcon(getScaledImage(icon.getImage(), 32, 32));

thumbAction = new ThumbnailAction(icon, thumbnailIcon,
imageCaptions[i]);

}else{
// the image failed to load for some reason
// so load a placeholder instead
thumbAction = new ThumbnailAction(placeholderIcon,
placeholderIcon, imageCaptions[i]);
}
publish(thumbAction);
}
// unfortunately we must return something, and only null is
valid to
// return when the return type is void.
return null;
}

/**
* Process all loaded images.
*/
@Override
protected void process(List chunks) {
for (ThumbnailAction thumbAction : chunks) {
JButton thumbButton = new JButton(thumbAction);
// add the new button BEFORE the last glue
// this centers the buttons in the toolbar
buttonBar.add(thumbButton, buttonBar.getComponentCount() -
1);
}
}
};

/**
* Creates an ImageIcon if the path is valid.
* @param String - resource path
* @param String - description of the file
*/
protected ImageIcon createImageIcon(String path,
String description) {
java.net.URL imgURL = getClass().getResource(path);
if (imgURL != null) {
return new ImageIcon(imgURL, description);
} else {
System.err.println("Couldn't find file: " + path);
return null;
}
}

/**
* Resizes an image using a Graphics2D object backed by a BufferedImage.
* @param srcImg - source image to scale
* @param w - desired width
* @param h - desired height
* @return - the new resized image
*/
private Image getScaledImage(Image srcImg, int w, int h){
BufferedImage resizedImg = new BufferedImage(w, h,
BufferedImage.TYPE_INT_RGB);
Graphics2D g2 = resizedImg.createGraphics();
g2.setRenderingHint(RenderingHints.KEY_INTERPOLATION,
RenderingHints.VALUE_INTERPOLATION_BILINEAR);
g2.drawImage(srcImg, 0, 0, w, h, null);
g2.dispose();
return resizedImg;
}

/**
* Action class that shows the image specified in it's constructor.
*/
private class ThumbnailAction extends AbstractAction{

/**
*The icon if the full image we want to display.
*/
private Icon displayPhoto;

/**
* @param Icon - The full size photo to show in the button.
* @param Icon - The thumbnail to show in the button.
* @param String - The descriptioon of the icon.
*/
public ThumbnailAction(Icon photo, Icon thumb, String desc){
displayPhoto = photo;

// The short description becomes the tooltip of a button.
putValue(SHORT_DESCRIPTION, desc);

// The LARGE_ICON_KEY is the key for setting the
// icon when an Action is applied to a button.
putValue(LARGE_ICON_KEY, thumb);
}

/**
* Shows the full image in the main area and sets the application
title.
*/
public void actionPerformed(ActionEvent e) {
photographLabel.setIcon(displayPhoto);
setTitle("Icon Demo: " +
getValue(SHORT_DESCRIPTION).toString());
}
}
}

Storing Temporary Data : VB.NET & ASP.NET in DataTable & GirdView

Puneet Arora — Thu, 13 Aug 2009 11:54:37 GMT

Storing Temporary Data : VB.NET & ASP.NET : Using DataTable & GirdView

step 1:Create Temporary DataTable &
Add a GridView control, two lable controls, three textbox controls and
button control in the page .

Private Function CreateTempDataTable() As DataTable
Dim myDataTable As DataTable = New DataTable()

Dim myDataColumn As DataColumn

myDataColumn = New DataColumn()
myDataColumn.DataType = Type.GetType("System.String")
myDataColumn.ColumnName = "id"
myDataTable.Columns.Add(myDataColumn)

myDataColumn = New DataColumn()
myDataColumn.DataType = Type.GetType("System.String")
myDataColumn.ColumnName = "username"
myDataTable.Columns.Add(myDataColumn)

myDataColumn = New DataColumn()
myDataColumn.DataType = Type.GetType("System.String")
myDataColumn.ColumnName = "firstname"
myDataTable.Columns.Add(myDataColumn)

myDataColumn = New DataColumn()
myDataColumn.DataType = Type.GetType("System.String")
myDataColumn.ColumnName = "lastname"
myDataTable.Columns.Add(myDataColumn)

Return myDataTable
End Function

Step 2:

Private Function PoputlateDataTable(ByVal username As String, ByVal
firstname As String,

ByVal lastname As String, ByVal myTable As DataTable)
Dim row As DataRow

row = myTable.NewRow()

row("id") = Guid.NewGuid().ToString()
row("username") = username
row("firstname") = firstname
row("lastname") = lastname

myTable.Rows.Add(row)
End Function

Now call the PopulateDataTable Function :

Private Sub Some ClickEvent_XXX()

If txtUserName.Text.Trim() = "" Then
Me.lblTips.Text = "You must fill a username."
Return
Else
AddDataToTable(Me.txtUserName.Text.Trim(), Me.txtFirstName.Text.Trim(),

Me.txtLastName.Text.Trim(), CType(Session("myDatatable"), DataTable))

Me.GridView1.DataSource = CType(Session("myDatatable"),
DataTable).DefaultView

Me.GridView1.DataBind()

Me.txtFirstName.Text = ""
Me.txtLastName.Text = ""
Me.txtUserName.Text = ""
Me.lblTips.Text = ""
End If

End Sub

Important Note:

Please note that "Session["myDatatable"] = myDt;" is important to ensure we
can add new data

continually until the page be closed.

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles

Me.Load
If Me.IsPostBack = False Then
myDt = New DataTable()
myDt = CreateTempDataTable()
Session("myDatatable") = myDt

Me.GridView1.DataSource = (CType(Session("myDatatable"),
DataTable)).DefaultView
Me.GridView1.DataBind()
End If
End Sub

RowSet Model based on TableModel and Using it with Jtable

Puneet Arora — Mon, 03 Aug 2009 16:27:11 GMT

import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Types;

import javax.sql.RowSet;
import javax.sql.RowSetEvent;
import javax.sql.RowSetListener;
import javax.swing.table.AbstractTableModel;

public class RowSetModel extends AbstractTableModel implements
RowSetListener {
private RowSet rowSet = null;

public RowSetModel(RowSet set) {
super();
rowSet = set;
rowSet.addRowSetListener(this);
}

public void cursorMoved(RowSetEvent event) {
}

public Class getColumnClass(int column) {
String cname;
int type;

try {
ResultSetMetaData meta = rowSet.getMetaData();

if (meta == null) {
return null;
}
type = meta.getColumnType(column + 1);
} catch (SQLException e) {
e.printStackTrace();
return super.getColumnClass(column);
}
switch (type) {
case Types.BIT: {
cname = "java.lang.Boolean";
break;
}
case Types.TINYINT: {
cname = "java.lang.Byte";
break;
}
case Types.SMALLINT: {
cname = "java.lang.Short";
break;
}
case Types.INTEGER: {
cname = "java.lang.Integer";
break;
}
case Types.BIGINT: {
cname = "java.lang.Long";
break;
}
case Types.FLOAT:
case Types.REAL: {
cname = "java.lang.Float";
break;
}
case Types.DOUBLE: {
cname = "java.lang.Double";
break;
}
case Types.NUMERIC: {
cname = "java.lang.Number";
break;
}
case Types.DECIMAL: {
cname = "java.math.BigDecimal";
break;
}
case Types.CHAR:
case Types.VARCHAR:
case Types.LONGVARCHAR: {
cname = "java.lang.String";
break;
}
case Types.DATE: {
cname = "java.sql.Date";
break;
}
case Types.TIME: {
cname = "java.sql.Time";
break;
}
case Types.TIMESTAMP: {
cname = "java.sql.Timestamp";
break;
}
case Types.BINARY:
case Types.VARBINARY:
case Types.LONGVARBINARY: {
cname = "byte[]";
break;
}
case Types.OTHER:
case Types.JAVA_OBJECT: {
cname = "java.lang.Object";
break;
}
case Types.CLOB: {
cname = "java.sql.Clob";
break;
}
case Types.BLOB: {
cname = "java.ssql.Blob";
break;
}
case Types.REF: {
cname = "java.sql.Ref";
break;
}
case Types.STRUCT: {
cname = "java.sql.Struct";
break;
}
default: {
return super.getColumnClass(column);
}
}
try {
return Class.forName(cname);
} catch (Exception e) {
e.printStackTrace();
return super.getColumnClass(column);
}
}

public int getColumnCount() {
try {
ResultSetMetaData meta = rowSet.getMetaData();

if (meta == null) {
return 0;
}
return meta.getColumnCount();
} catch (SQLException e) {
return 0;
}
}

public String getColumnName(int col) {
try {
ResultSetMetaData meta = rowSet.getMetaData();

if (meta == null) {
return null;
}
return meta.getColumnName(col + 1);
} catch (SQLException e) {
return "Error";
}
}

public int getRowCount() {
try {
if (rowSet.last()) {
return (rowSet.getRow());
} else {
return 0;
}
} catch (SQLException e) {
return 0;
}
}

public Object getValueAt(int row, int col) {
try {
if (!rowSet.absolute(row + 1)) {
return null;
}
return rowSet.getObject(col + 1);
} catch (SQLException e) {
return null;
}
}

public void rowChanged(RowSetEvent event) {
try {
int row = rowSet.getRow();

if (rowSet.rowDeleted()) {
fireTableRowsDeleted(row, row);
} else if (rowSet.rowInserted()) {
fireTableRowsInserted(row, row);
} else if (rowSet.rowUpdated()) {
fireTableRowsUpdated(row, row);
}
} catch (SQLException e) {
}
}

public void rowSetChanged(RowSetEvent event) {
fireTableStructureChanged();
}

public void setValueAt(Object value, int row, int column) {
try {
if (!rowSet.absolute(row + 1)) {
return;
}
rowSet.updateObject(column + 1, value);
} catch (SQLException e) {
}
}
}

Vector Based Table Model and Using it with JTable

Puneet Arora — Mon, 03 Aug 2009 16:24:06 GMT

1. Create a new project or open your exam project
2. Create a JFrame class, named as you like and drag, drop and
design JTable

3. The data (model) is saving in Vector, now create variable
Vector data in class:

private Vector data = new Vector();

4. initComponents();

write this code to create and asign model to JTable

5.The table model contain variable String[] using as column name, and at
least we must override 3 method:

public int getRowCount();
public int getColumnCount();
public Object getValueAt(int rowIndex, int columnIndex);

ublic String getColumnName(int column);

to show column name on table header.
5. After creating a model now we assign the data, write this code:

data.add(new String[]{"", "Sri Kuntadi", "Purwodadi"});
data.add(new String[]{"", "Fajar Ichwanul Arifin", "Cilacap"});
data.add(new String[]{"", "Arif Nurcahyo", "Magetan"});
data.add(new String[]{"", "Muh Adly Hamid", "Makasar"});

6. Run the project

Complete Listing
import java.util.Vector;
import javax.swing.table.AbstractTableModel;

public class JTableAbstractTableModel extends javax.swing.JFrame {

private Vector data = new Vector();

/** Creates new form JTableAbstractTableModel */
public JTableAbstractTableModel() {
initComponents();
table.setModel(new AbstractTableModel() {

String[] colum = new String[]{"No", "Name", "Address"};

@Override
public int getRowCount() {
return data.size();
}

@Override
public int getColumnCount() {
return colum.length;
}

@Override
public Object getValueAt(int rowIndex, int columnIndex) {
return columnIndex == 0 ? "" + (rowIndex + 1) :
data.get(rowIndex)[columnIndex];
}

@Override
public String getColumnName(int column) {
return colum[column];
}
});

data.add(new String[]{"", "Sri Kuntadi", "Purwodadi"});
data.add(new String[]{"", "Fajar Ichwanul Arifin", "Cilacap"});
data.add(new String[]{"", "Arif Nurcahyo", "Magetan"});
data.add(new String[]{"", "Muh Adly Hamid", "Makasar"});

}

/** This method is called from within the constructor to
* initialize the form.
* WARNING: Do NOT modify this code. The content of this method is
* always regenerated by the Form Editor.
*/
@SuppressWarnings("unchecked")
// //GEN-BEGIN:initComponents
private void initComponents() {

scroller = new javax.swing.JScrollPane();
table = new javax.swing.JTable();

setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
setTitle("JTable using AbstractTableModel");

scroller.setName("scroller"); // NOI18N

table.setName("table"); // NOI18N
scroller.setViewportView(table);

javax.swing.GroupLayout layout = new
javax.swing.GroupLayout(getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(

layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addContainerGap()
.addComponent(scroller,
javax.swing.GroupLayout.DEFAULT_SIZE, 394, Short.MAX_VALUE)
.addContainerGap())
);
layout.setVerticalGroup(

layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addContainerGap()
.addComponent(scroller,
javax.swing.GroupLayout.DEFAULT_SIZE, 283, Short.MAX_VALUE)
.addContainerGap())
);

pack();
}// //GEN-END:initComponents

/**
* @param args the command line arguments
*/
public static void main(String args[]) {
java.awt.EventQueue.invokeLater(new Runnable() {

public void run() {
new JTableAbstractTableModel().setVisible(true);
}
});
}

// Variables declaration - do not modify//GEN-BEGIN:variables
public javax.swing.JScrollPane scroller;
public javax.swing.JTable table;
// End of variables declaration//GEN-END:variables
}
Sent from Chandigarh, PB, India

How to create your own Table Model and Using it with JTable

Puneet Arora — Mon, 03 Aug 2009 16:14:51 GMT

*Three Most Important Constructors of JTable *

JTable table = new JTable(data, columnNames);
JTable(Object[][] rowData, Object[] columnNames)
JTable(Vector rowData, Vector columnNames)

*How to create your own Table Model : Then using this Table Model with
JTable *

Every table object uses a table model object to manage the actual table
data. A table model object must implement the TableModel interface. If the
programmer does not provide a table model object, JTable automatically
creates an instance of DefaultTableModel. This relationship is Like this

Table Object--> Table Model -->Table Data

class MyTableModel extends AbstractTableModel {
private String[] columnNames = ...//same as before...
private Object[][] data = ...//same as before...

public int getColumnCount() {
return columnNames.length;
}

public int getRowCount() {
return data.length;
}

public String getColumnName(int col) {
return columnNames[col];
}

public Object getValueAt(int row, int col) {
return data[row][col];
}

public Class getColumnClass(int c) {
return getValueAt(0, c).getClass();
}

/*
* Don't need to implement this method unless your table's
* editable.
*/
public boolean isCellEditable(int row, int col) {
//Note that the data/cell address is constant,
//no matter where the cell appears onscreen.
if (col < 2) {
return false;
} else {
return true;
}
}

/*
* Don't need to implement this method unless your table's
* data can change.
*/
public void setValueAt(Object value, int row, int col) {
data[row][col] = value;
fireTableCellUpdated(row, col);
}
...
}
-------------------------------------------------------------

Example :Table Model
*
Using this Table Model with JTable *

package components;

/*
* TableDemo.java requires no other files.
*/

import javax.swing.JFrame;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.table.AbstractTableModel;
import java.awt.Dimension;
import java.awt.GridLayout;

/**
* TableDemo is just like SimpleTableDemo, except that it
* uses a custom TableModel.
*/
public class TableDemo extends JPanel {
private boolean DEBUG = false;

public TableDemo() {
super(new GridLayout(1,0));

JTable table = new JTable(new MyTableModel());
table.setPreferredScrollableViewportSize(new Dimension(500, 70));
table.setFillsViewportHeight(true);

//Create the scroll pane and add the table to it.
JScrollPane scrollPane = new JScrollPane(table);

//Add the scroll pane to this panel.
add(scrollPane);
}

class MyTableModel extends AbstractTableModel {
private String[] columnNames = {"First Name",
"Last Name",
"Sport",
"# of Years",
"Vegetarian"};
private Object[][] data = {
{"Mary", "Campione",
"Snowboarding", new Integer(5), new Boolean(false)},
{"Alison", "Huml",
"Rowing", new Integer(3), new Boolean(true)},
{"Kathy", "Walrath",
"Knitting", new Integer(2), new Boolean(false)},
{"Sharon", "Zakhour",
"Speed reading", new Integer(20), new Boolean(true)},
{"Philip", "Milne",
"Pool", new Integer(10), new Boolean(false)},
};

public int getColumnCount() {
return columnNames.length;
}

public int getRowCount() {
return data.length;
}

public String getColumnName(int col) {
return columnNames[col];
}

public Object getValueAt(int row, int col) {
return data[row][col];
}

/*
* JTable uses this method to determine the default renderer/
* editor for each cell. If we didn't implement this method,
* then the last column would contain text ("true"/"false"),
* rather than a check box.
*/
public Class getColumnClass(int c) {
return getValueAt(0, c).getClass();
}

/*
* Don't need to implement this method unless your table's
* editable.
*/
public boolean isCellEditable(int row, int col) {
//Note that the data/cell address is constant,
//no matter where the cell appears onscreen.
if (col < 2) {
return false;
} else {
return true;
}
}

/*
* Don't need to implement this method unless your table's
* data can change.
*/
public void setValueAt(Object value, int row, int col) {
if (DEBUG) {
System.out.println("Setting value at " + row + "," + col
+ " to " + value
+ " (an instance of "
+ value.getClass() + ")");
}

data[row][col] = value;
fireTableCellUpdated(row, col);

if (DEBUG) {
System.out.println("New value of data:");
printDebugData();
}
}

private void printDebugData() {
int numRows = getRowCount();
int numCols = getColumnCount();

for (int i=0; i < numRows; i++) {
System.out.print(" row " + i + ":");
for (int j=0; j < numCols; j++) {
System.out.print(" " + data[i][j]);
}
System.out.println();
}
System.out.println("--------------------------");
}
}

/**
* Create the GUI and show it. For thread safety,
* this method should be invoked from the
* event-dispatching thread.
*/
private static void createAndShowGUI() {
//Create and set up the window.
JFrame frame = new JFrame("TableDemo");
frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

//Create and set up the content pane.
TableDemo newContentPane = new TableDemo();
newContentPane.setOpaque(true); //content panes must be opaque
frame.setContentPane(newContentPane);

//Display the window.
frame.pack();
frame.setVisible(true);
}

public static void main(String[] args) {
//Schedule a job for the event-dispatching thread:
//creating and showing this application's GUI.
javax.swing.SwingUtilities.invokeLater(new Runnable() {
public void run() {
createAndShowGUI();
}
});
}
}
-------------------------------------------------------------

JTable & AbstractTableModel Class with JFrame

Puneet Arora — Mon, 03 Aug 2009 16:04:10 GMT

Your First Populated JTable

import javax.swing.JFrame;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import java.awt.Dimension;
import java.awt.GridLayout;
import java.awt.event.MouseAdapter;
import java.awt.event.MouseEvent;

public class TableDemo extends JPanel {
private boolean DEBUG = false;

public TableDemo() {
super(new GridLayout(1,0));

String[] columnNames = {"First Name",
"Last Name",
"Sport",
"# of Years",
"Vegetarian"};

Object[][] data = {
{"Mary", "Campione",
"Snowboarding", new Integer(5), new Boolean(false)},
{"Alison", "Huml",
"Rowing", new Integer(3), new Boolean(true)},
{"Kathy", "Walrath",
"Knitting", new Integer(2), new Boolean(false)},
{"Sharon", "Zakhour",
"Speed reading", new Integer(20), new Boolean(true)},
{"Philip", "Milne",
"Pool", new Integer(10), new Boolean(false)}
};

final JTable table = new JTable(data, columnNames);
table.setPreferredScrollableViewportSize(new Dimension(500, 70));
table.setFillsViewportHeight(true);

if (DEBUG) {
table.addMouseListener(new MouseAdapter() {
public void mouseClicked(MouseEvent e) {
printDebugData(table);
}
});
}

//Create the scroll pane and add the table to it.
JScrollPane scrollPane = new JScrollPane(table);

//Add the scroll pane to this panel.
add(scrollPane);
}

private void printDebugData(JTable table) {
int numRows = table.getRowCount();
int numCols = table.getColumnCount();
javax.swing.table.TableModel model = table.getModel();

System.out.println("Value of data: ");
for (int i=0; i < numRows; i++) {
System.out.print(" row " + i + ":");
for (int j=0; j < numCols; j++) {
System.out.print(" " + model.getValueAt(i, j));
}
System.out.println();
}
System.out.println("--------------------------");
}

/**
* Create the GUI and show it. For thread safety,
* this method should be invoked from the
* event-dispatching thread.
*/
private static void createAndShowGUI() {
//Create and set up the window.
JFrame frame = new JFrame(" TableDemo ");
frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

//Create and set up the content pane.
TableDemo newContentPane = new TableDemo();
newContentPane.setOpaque(true); //content panes must be opaque
frame.setContentPane(newContentPane);

//Display the window.
frame.pack();
frame.setVisible(true);
}

public static void main(String[] args) {
//Schedule a job for the event-dispatching thread:
//creating and showing this application's GUI.
javax.swing.SwingUtilities.invokeLater(new Runnable() {
public void run() {
createAndShowGUI();
}
});
}
}

Creating Single Class Object Class:SingleTon in VB.NET

Puneet Arora — Tue, 28 Jul 2009 11:37:11 GMT

Step1 : Create Private Constructor
Step 2: Create method to put logic that , only one instance can be created
(getOneInstance() )

*Public Class SingleObjectClass*

Private Shared objSingle As SingleObjectClass
Private Shared CreatedFlag As Boolean

Private Sub New()
'Override the default constructor
End Sub

Public Shared Function getOneInstance() As SingleObjectClass
If CreatedFlag = False Then
objSingle = New SingleObjectClass()

CreatedFlag = True
Return objSingle
Else
Return objSingle
End If
End Function
* End Class*

Programming-Project-Ideas-With-Sample-Project-Report-on-Library-Management

Puneet Arora — Mon, 11 May 2009 17:16:34 GMT

If you looking for Project Ideas and want to learn

"How to write a Computer Project Report ? you must read this document

"How create ER diagram ? " find one example of ER Diagram in Sample Report
contained in this Doc !
--
Visit this link:

http://www.scribd.com/doc/14656712/Programming-Project-Ideas-With-Sample-Project-Report-on-Library-Management

Warm regards,

Puneet Arora
Ecologic Corporation
www.ecologic.co.in
www.logicatwork.info

IM : puneet@ecologic.co.in

training-classes directory!

Puneet Arora — Wed, 06 May 2009 18:34:00 GMT

If you are looking for other types of training, check out the
training-classes.com directory of

construction training seminars

Warm regards,

Puneet Arora
Ecologic Corporation
www.ecologic.co.in
www.logicatwork.info
2138 , Sector 22 -C
Chandigarh
Mobile: 9872856485
IM : puneet@ecologic.co.in

How to map System Study to create Class Diagrams , Activity and State Diagrams

Puneet Arora — Sun, 26 Apr 2009 14:45:00 GMT

How to Create Class, Activity and State Diagram

Publish at Scribd or explore others: How-to-Guides & Manu class Uncategorizable-Unca

105 Project Ideas for Computer Science Students :

Puneet Arora — Thu, 02 Apr 2009 17:13:00 GMT

Many times students face one natural issue while doing training in Java, VB.NET , SQL, ASP.NET ect ., ... They do know how to how to apply their acquired knowledge into making projects they lack...Here are few Project Ideas .. 105 Project Ideas for Industrial Training for Computer Science Students 105 Project Ideas for Industrial Training for Computer Science Students puneetarora2000 Many times students face one natural issue while doing training in Java, VB.NET , SQL, ASP.NET ect ., ... They do know how to how to apply their acquired knowledge into making projects they lack Project Ideas.., Here are 105 Project ideas for any person who is the process of learning Computer Science Languages .

Publish at Scribd or explore others: Study Guides Academic Work java .net

How to create Ledger Accounting Application in VB.NET

Puneet Arora — Wed, 01 Apr 2009 20:30:00 GMT

How To Create Ledger Accounting In Vb.Net