Abhishek Gupta

The Sun won’t set at NIT Durgapur !

Posts Tagged ‘database’

Developing MySQL Database Applications With PHP

Posted by abhiitechie on April 27, 2009

A four part tutorial that explains the PHP / MySQL extensions – mysql, mysqli, and pdo_mysql – with simple examples is now accessible from Sun Developer Network. While most of the information presented in the tutorial is available elsewhere in bits and pieces, the real value-add is in the introduction of the MySQL native driver for PHP, mysqlnd.

Application developers who are new to the development of MySQL database applications with PHP are the target audience of this tutorial.

Posted in mysql | Tagged: , , , , , , | 1 Comment »

Database connections using JDBC – MySQL and Netbeans

Posted by abhiitechie on April 27, 2009

I am fed up of people asking me how to make Database connections in Java . No one wants to go through the painfull part of studying themselves . All they want is the short-cut . So let me dedicate this particular posts to the topic of database connections in Java .

I have MySQL 5.0 installed on my Windows. In order to make a JDBC connection to MySQL database one needs to downlad the MySQL/J connector driver from here . I will also expect that you have Netbeans 6+ installed on your machine.

Extract the zip file to a folder, you’ll see file ‘mysql-connector-java-5.0.6-bin.jar’ which is the library file that we want. Just copy the file to the library folder, for example to “C:\Program Files\Java\jdk1.6.0_02\lib” also to the “C:\Program Files\Java\jdk1.6.0_02\jre\lib directory.

Next, create a new Java project on NetBeans named ‘TestMySQL’.

Now I’m going to write some code to connect to MySQL database. I have configured MySQL service on localhost.
I’m going to use Connection and DriverMapper Classes so I need to import libraries.
import java.sql.*;

Inorder to test my connections I build my project.

So everything seems to be fine till now.

To get some data, I need to execute query on the SQL Server and get the result back to me. First, I create stmt (Statement object) and execute query in SQL language. Then I store the result on ResultSet object and iterative show the result on the output window.

Insert some data to the created table using the code

Statement stmt = null;

stmt = con.createStatement();

String SQL = “INSERT INTO ZanduBaam (Name,Roll) VALUES (‘Abhishek’,40)”;

int rowsEffected = stmt.executeUpdate(SQL);

System.out.println(rowsEffected + ” rows effected”);

Inorder to retrieve data from database , I need to execute query on the SQL Server and get the result back to me. First, I created stmt (Statement object) and execute query in SQL language. Then I store the result on ResultSet object and iterative show the result on the output window.

ResultSet rs = null; // SQL query command String SQL = “SELECT * FROM ZanduBaam”; stmt = con.createStatement(); rs = stmt.executeQuery(SQL); while (rs.next()) {
System.out.println(rs.getString(“Name”) + ” : ” + rs.getString(“Roll”));

Similarly you can do the required for updation and deletion .

Lots of time and sweat devoted to this post considering the fact that I have a test on Monday I should stop here.

Posted in Uncategorized | Tagged: , , , , , , , , , , , , , , , , , , , , , | 3 Comments »

My First Session On Netbeans IDE and J2SE

Posted by abhiitechie on April 25, 2009

This was the debut session conducted by me as a CA . In the first part of my Demo I covered many topics related to Netbeans Intelligent Text Editor and showed them techniques like Code-Insertion , Code-Refactoring ,Using Javadoc , Live Code Parser and error checker , Local History , Code completion , Instant renaming , Compile on Save,and lots of other cool stuffs. I explained them how to use the Profiler and the Debugger. I explained them the use of Version Control and automated testing (Unit Testing) .

This was followed by a basic demonstration on the Swing Gui Builder and with functionalities like Automatic feedback , Quick Component Insertion , Anchoring , Alignment . After this I expained the basic features of event handling and demonstrated it with a small application built using the Swing Builder .

As people asked for more meat so I continued out of my plan to demonstrate them easy Data Binding using MySQL database , JTable and Java Persistence API showing them how to createa CRUD application in 5 mins! On audience demand I also showed them how to import an existing PHP-MySQL project in Netbeans and showed them advantage of using WEB 2.0 frameworks like JMaki and Dojo directly into the existing PHP project. I gave them an introduction to Visual Web Java Server Faces by demonstrating them how to populated a Woodstock Table from a MYSQL database using simple drag-drop.

Many obvious questions like why Netbeans over Eclipse which I think I answered satisfactorily. Many people came to me afterwards asking more details about multibooting Solaris and more about Web 2.0 and AJAX. I was on the top of the world when people actually clapped at the end of the talk. All in all a nice experience.

Here are some of the pictures from the Session






Posted in sun | Tagged: , , , , , , , , , , , , , , , , , , , , , | Leave a Comment »