Vaharkalil

Saturday, February 23, 2013

Simple java program for connecting to DATABASE(mysql)

In order to connect to database you need to add mysql-connector-java-5.1.22.jar file in your eclipse project as a external jar file....

import java.sql.Connection;

import java.sql.Driver;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;



public class SqlSample {



    /**

     * @param args

     * @throws ClassNotFoundException 

     * @throws IllegalAccessException 

     * @throws InstantiationException 

     * @throws SQLException 

     */

    public static void main(String[] args) throws InstantiationException, IllegalAccessException, ClassNotFoundException, SQLException {

        // TODO Auto-generated method stub

        Connection con;

        Class.forName("com.mysql.jdbc.Driver");

        con = DriverManager.getConnection("jdbc:mysql://localhost/saran","root","root");

        Statement stmt;

        ResultSet rs;

        stmt=con.createStatement();

        rs=stmt.executeQuery("select * from employee;");

        

        while(rs.next())

        {

            System.out.println(rs.getString("empname")+rs.getInt("salary"));

        }

    }



}

Servlet Program for Retrieving data from Table

In order to connect to database you need to add mysql-connector-java-5.1.22.jar file in your eclipse project as a external jar file.... 

import java.io.IOException;

import javax.servlet.ServletException;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;



/**

 * Servlet implementation class HelloServlet

 */

import java.io.*;



import javax.servlet.*;

import javax.servlet.http.*;



import java.sql.*;



public

    class HelloServlet extends HttpServlet {

    

    public void doGet (HttpServletRequest req, HttpServletResponse res)

        throws ServletException, IOException {

        res.setContentType("text/html");

        

        PrintWriter out=res.getWriter();

        out.println("<html>");

        out.println("<head><title>Students List</title></head>");

        out.println("<body>");

        

        try {

        // The newInstance() call is a work around for some

        // broken Java implementations

        

        Class.forName("com.mysql.jdbc.Driver").newInstance();

        }

        catch (Exception E) {

        out.println("Unable to load driver.");

        E.printStackTrace();

        }

        

        out.println("<br><center><p style=color:purple;font-size:30px;>STUDENTS DATABASE</p></center><hr>");

        

        try {

        Connection Conn = 

            DriverManager.getConnection("jdbc:mysql://localhost/saran","root","root");

            

        // Do something with the Connection

        Statement Stmt = Conn.createStatement();

        ResultSet RS = Stmt.executeQuery("SELECT * from student");

        out.println("<center><table border='1' style=color:purple;font-size:20px;><th>Name</th><th>Area</th><th>Course</th>");

        while (RS.next()) {

            out.println("<tr><td>"+RS.getString("name")+"<td>"+RS.getString("area")+"<td>"+RS.getString("course")+"</td></tr>");

            

        }

        out.println("</table></center>");

        out.println("<center><form action='index.htm'><input type='submit' value='Home'></form></center>");

        // Clean up after ourselves

        RS.close();

        Stmt.close();

        Conn.close();

        

        }

        catch (SQLException E) {

        

        }

        

        

        out.println("</body></html>");

    }

    

    }

Friday, February 22, 2013

Compare Two Integer Arrays

This program will compare two integer arrays and return a result number of matching numbers in those arrays :
public void arrayMatcher(int a[], int b[])
{

    int count=0;
    for(int i=0;i<a.length;i++)
    {
        for(int j=0;j<b.length;j++)
        {
            if((a[i])==(b[j]))
            {
                count++;

            }
        }

    }
    System.out.println(count+" numbers matches in two arrays");


}
CONTENT WARNING:This is my own program.. It is for Educational purposes only. Please do not republish or reproduce with another name in online.

Sort Letters in a String Object

public void doSorting(String str)
    {
    char array[]=str.toCharArray();
    char temp;
    System.out.print("Given name :");
    for(int i=0;i<array.length;i++)
    {
        System.out.print(array[i]);
    }
    System.out.println();
    for(int i=0;i<array.length;i++)
    {
        for(int j=0;j<i;j++)
        {
            if(array[i]<array[j])
            {
                temp=array[j];
                array[j]=array[i];
                array[i]=temp;
            }
        }

    }

CONTENT WARNING:This is my own program.. It is for Educational purposes only. Please do not republish or reproduce with another name in online.

Reverse String in JAVA



This is the method which will reverse the given STRING :





public void myOwnstringReversing(String str)
{
    for(int i=str.length()-1;i>=0;i--)
    {
        System.out.print(str.charAt(i));
    }
}









CONTENT WARNING:

This is my own program.. It is for Educational purposes only. Anyone do not republish in your website will be punished offensively.

Wednesday, December 19, 2012

Thread Program four in Java

public class Thread_Demo extends Thread{

public void run(){
System.out.println("Some text");
}
public static void main(String[] args) throws InterruptedException{

Thread_Demo t=new Thread_Demo();
Thread_Demo td1=new Thread_Demo();

t.start();

System.out.println("ISALIVE :"+t.isAlive());
t.sleep(500);
System.out.println("ISALIVE :"+t.isAlive());
//t.destroy();
t.resume();
System.out.println("ISALIVE :"+t.isAlive());
}

}

Thread Program three in Java

What is out put?

public class Thread_Demo extends Thread{

public void run(){

System.out.println("Some text");

}

public static void main(String[] args) throws InterruptedException {

Thread_Demo t=new Thread_Demo();

Thread_Demo td1=new Thread_Demo();

t.run();

System.out.println("ISALIVE :"+t.isAlive());

t.sleep(500);

System.out.println("ISALIVE :"+t.isAlive());

t.destroy();

System.out.println("ISALIVE :"+t.isAlive());

}

Vaharkalil

Saturday, February 23, 2013

Simple java program for connecting to DATABASE(mysql)

Servlet Program for Retrieving data from Table

Friday, February 22, 2013

Compare Two Integer Arrays

Sort Letters in a String Object

Reverse String in JAVA

Wednesday, December 19, 2012

Thread Program four in Java

Thread Program three in Java

About Me

Blog Archive