Structure Query Language, C programming, Java, Servlet, Jsp, Unix

Thursday 27 June 2013

How to use Command line argument in GCC compiler

[Sender.c]
#include<stdio.h>
#include<fcntl.h>
#include<string.h>
void main(int argc, char *args[])
{
int i,count=0,len,j=0,pid;
char frame[50],data[50];
        len=strlen(args[1])-8;

system("clear");
system(">pipe");
pid=open("pipe",O_WRONLY);

printf("len : %d",len);
printf("%s",data);

for(i=0; i<len; i++)
{
data[i]=args[1][8+i];
}
data[i]='\0';
printf("data %s",data);

frame[j]=len+48;
for(i=0; i<len; i++)
{
j++;
frame[j]=data[i];
}
j++;
frame[j]='\0';
printf(" Sent to frame :%s",frame);
write(pid,&frame,sizeof(frame));
}

[Receiver.c]

#include<stdio.h>
#include<fcntl.h>
#include<string.h>
void main()
{
int i,count=0,len,j=0,pid;
char frame[50],data[50];
        system("clear");
pid=open("pipe",O_RDONLY);
read(pid,&frame,sizeof(frame));
printf("%s",frame);
len=strlen(frame);
for(i=0; i<len; i++)
{
data[i]=frame[i+1];
}
data[i]='\0';
printf("data %s",data);
printf("\n receive to frame :%s",data);
}




Tuesday 22 January 2013

Mysql java connectivity

hi Friends here are the steps to connect java with mysql database
step 2: on your c: drive find "mysql" directory and copy above connector file in "mysql/lib" dirctory.
step 3: right click on mycomputer->properties->advance-system-setting->Environment_variable
step 4: add new variable and set 
VARIABLE NAME=CLASSPATH
VARIABLE VALUE=;C:/<YOUR DIRECTORYs>/mysql/lib/mysql-connector-java-5.1.2.jar;
step 5: click on ok->ok->ok
step 6: write following code
import java.sql.*;
import java.io.*;
public class connect
{
 /*
 * master-gtu.blogspot.com
 * Pankaj Sharma(8460479175)
 */
 public static void main(String args[])
 {
  try
  {
  Class.forName("com.mysql.jdbc.Driver");
  Connection con=DriverManager.getConnection("jdbc:mysql://localhost/neelkanth","root","");
// here neelkanth is database name and root is username and password is blank
  //System.out.println("Connected to DATABASE");
  Statement stmt = con.createStatement();
  ResultSet rs=stmt.executeQuery("select * from notice");
  while(rs.next())
  {
   System.out.println(rs.getString(3));
  }
  con.close();
  }
  catch(Exception e)
  {
   System.out.println(e.toString());
  }
 }
}
step 7: Wao connectivity success... """""""""Happy Coding"""""""""""