Create Table

package jdbc;

import java.sql.*;
import java.sql.Statement;

public class CreateTableDemo
{
public static void main(String[] args) throws SQLException, ClassNotFoundException
{ try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","hr", "hr");
Statement st = con.createStatement();
st.executeUpdate("create table demo(d_num number , d_name varchar2(10), d_rate number)");
//st.executeQuery("commit");
System.out.println("Table created");
con.close();
}
catch(SQLException e)
{
System.out.println(e);
}
catch(ClassNotFoundException e2)
{
System.out.println(e2);
}
}
}

Socket Programming : Client Server Communication

==============================CLIENT============================


import java.io.OutputStreamWriter;
import java.io.PrintWriter;
import java.net.Socket;

public class Client {

public static void main(String[] args) throws Exception
{
String ip = "localhost";
int port = 6666;
Socket s = new Socket(ip,port);

String str = "Apples are good";
OutputStreamWriter os = new OutputStreamWriter(s.getOutputStream());
//PrintWriter out = new PrintWriter(os);
os.write(str);
os.flush();
//out.close();
s.close();
}

}

===================================SERVER===========================

import java.io.BufferedReader;

import java.io.IOException;

import java.io.InputStreamReader;

import java.net.ServerSocket;

import java.net.Socket;

public class Server {

public static void main(String[] args) throws IOException 

{

  System.out.println("Server is Started...");

  ServerSocket ss = new ServerSocket(6666);

  

  System.out.println("Server is Waiting...");

  Socket s = ss.accept();

  

  System.out.println("Client Connected");

  BufferedReader br = new BufferedReader(new InputStreamReader(s.getInputStream()));

  String str1 = br.readLine();

  

  System.out.println("Client Data : "+str1);

  

}

}

======================================================================

Exel data to DataBase Using JDBC

package upload_download_Excel_Bakchodi;

import java.io.FileInputStream;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.sql.Statement;

import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.xssf.usermodel.XSSFFactory;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

public class Excel_To_DB

{

public static void main(String[] args) {
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "hr", "hr");
Statement st = con.createStatement();

con.setAutoCommit(false);
PreparedStatement pstm = null;
FileInputStream fis = new FileInputStream("D:\\work\\Java Work Space\\files\\demo.xlsx");

XSSFWorkbook wb = new XSSFWorkbook(fis);
XSSFSheet sheet = wb.getSheetAt(0);
Row row;

for(int i=1; i<=sheet.getLastRowNum(); i++)
{
row = sheet.getRow(i);

String name = row.getCell(0).getStringCellValue();
String city = row.getCell(1).getStringCellValue();
String hobby = row.getCell(2).getStringCellValue();
String food = row.getCell(3).getStringCellValue();
String id = row.getCell(4).getStringCellValue();
String country  = row.getCell(5).getStringCellValue();

System.out.println(name+" : "+city+" : "+hobby+" : "+food+" : "+id+" : "+country);

String query = "insert into myexel values(?,?,?,?,?,?)";
PreparedStatement ps = con.prepareStatement(query);
ps.setString(1, name);
ps.setString(2, city);
ps.setString(3, hobby);
ps.setString(4, food);
ps.setString(5, id);
ps.setString(6, country);
int res = ps.executeUpdate();
if(res>0)
    System.out.println("Values inserted");
   
}
con.close();
/*
* XSSFFactory fs = new POIFSFileSystem( input ); XSSFWorkbook wb = new
* XSSFWorkbook(fs); XSSFSheet sheet = wb.getSheetAt(0); Row row;
*/
} catch (ClassNotFoundException e) {
System.out.println(e);
} catch (SQLException ex) {
System.out.println(ex);
} catch (IOException ioe) {
System.out.println(ioe);
}

}
}

==================TABLE==================

create table myexel( name varchar(20),
                    city varchar(20),
                    hobby varchar(20),
                    food varchar(20),
                    ID varchar(20),
                    Country varchar(20));
==========================================

Name	city	hobby	food	ID	Country
amit	Ranchi	Football	Fruits	gdf	USA
Sohan	Jaiput	hocky	idly	dfgd	India
Mohan	Mumbai	golf	litty	dfgd	Dubai
Mohan	Mumbai	golf	litty	dfgd	England
Mohan	Mumbai	golf	litty	dfgd	japan

===========================================

Read from Excel

package upload_download_Excel_Bakchodi;

import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;

import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.FormulaEvaluator;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

public class Excel_1
{
public static void main(String[] args) throws IOException
{
FileInputStream fis = new FileInputStream(new File("D:\\work\\Java Work Space\\files\\demo.xlsx"));

//create workbook instance that refers to .xls file
XSSFWorkbook wb = new XSSFWorkbook(fis);

//create sheet object to retrive sheet
XSSFSheet sheet = wb.getSheetAt(0);

//that is for evaluate the cell type
FormulaEvaluator formula = wb.getCreationHelper().createFormulaEvaluator();

for(Row row : sheet)
{
for(Cell cell : row)
{

switch(formula.evaluateInCell(cell).getCellType())
{
case STRING:
System.out.print(cell.getStringCellValue()+"\t\t");
break;
case NUMERIC:
System.out.print(cell.getNumericCellValue()+"\t\t");
break;
}

}
System.out.println();
}



}

}

========================================================================

Note : Download POI .Jars  from below link

https://poi.apache.org/download.html

Binary Distribution

• poi-bin-4.1.0-20190412.tar.gz (27.32 MB,

Mixed JS

function effect()
{
var x = document.getElementById("para1");
x.style.backgroundColor="yellow";

}
function effectback()
{
var x = document.getElementById("para1");
x.style.backgroundColor="white";
}
function effect2()
{

var x = document.getElementById("para2");
x.style.color = "yellow";

}
function effect2back()
{
var x = document.getElementById("para2");
x.style.color = "black";

}
function idm()
{
var x = document.getElementById("name");
x.style.color = "yellow";
}
function dimb()
{
var x = document.getElementById("name");
x.style.color = "black";
}

function city()
{
var x = document.getElementsByTagName("input");
alert(x.innerHTML);
x.style.color = "yellow";

}
function cityreturn()
{
var x = document.getElementsByTagName("input");
x.style.color = "black";
}

===================================================

document.write("<h1 style='background-color:yellow;color:red'>Welcome to External Java Script..!</h1>");

document.write("</br>");

document.write("thank You");

var str ="Amit Manjhi";

document.write("the string is "+str+"</br>");

var a = 10;

document.write("Int val :"+a);

function validate()

{

alert("Inside validate");

}

function myreturn()

{

return("Hello >>>>>>>>>>>>> I am return value");

}

function sum(a,b)

{

return(a+b);

}

function red()

{

document.bgColor = "red";

}

function green()

{

document.bgColor = "green";

}

function yellow()

{

document.bgColor='yellow';

}

function blue()

{

document.bgColor='blue';

}

===================================================================

function validate()

{ alert("inside 1");

var result = true;

var i = document.getElementsByTagName("input");

if(i[0].value.length==0)

result = false;

return (result);

}

function validateEmail()

{

var result = true;

var e = document.getElementsByName("email")[0].value; // [0] means first email (if there are multiple emails)

//alert(e);

var atindex = e.indexOf('@');

//alert(atindex);

var dotindex = e.lastIndexOf('.');

//alert(dotindex);

if(atindex<1 || dotindex >= e.length-2 || dotindex - atindex <3)

result = false;

return (result);

}

===================================================================

Binary Tree 1

package tree;

public class Node
{
int key;
Node left;
Node right;
}

=======================================================================

package tree;

public class BinaryTree 

{

Node root= null;

Node temp;

public void add(int value) 

{

root = insertRec(root, value);

}

//---------------------------------------

public void inOrderintraverse() 

{

intraverse(root);

}

public void preOrderTraverse() 

{

   pretraverse(root);

}

public void postOrderTraverse() 

{

posttraverse(root);

}

//----------------------------------------

//*****************************************

private Node insertRec(Node root, int value) 

{

if(root == null)

{

Node node = new Node();

node.key = value;

node.left = null;

node.right = null;

root = node;

return node;

}

else

{

if(value < root.key)

root.left = insertRec(root.left, value);

else if(value > root.key)

root.right = insertRec(root.right, value);

}

  

return root;

}

//*************************************

private void intraverse(Node root) 

{

  if(root!= null)

  {    

  intraverse(root.left);

  System.out.println(root.key+" ");

  intraverse(root.right);  

  }

}

//*************************************

private void pretraverse(Node root) 

{

if(root!= null)

  {  

System.out.println(root.key+" ");

pretraverse(root.left);

pretraverse(root.right);  

  }   

}

//*************************************

private void posttraverse(Node root) 

{

if(root!= null)

  {  

posttraverse(root.left);

posttraverse(root.right);

  System.out.println(root.key+" ");

  }   

}

}

======================================================================

package tree;

public class Runner {

public static void main(String[] args) 

{

  BinaryTree tree = new BinaryTree();

  tree.add(50);

  tree.add(30);

  tree.add(20);

  tree.add(35);

  tree.add(55);

  tree.add(52);

  tree.add(60);  

/* System.out.println("InOrder:");

  tree.inOrderintraverse();*/

System.out.println("PreOrder:");

  tree.preOrderTraverse();

  /* System.out.println("PostOrder:");

  tree.postOrderTraverse();

*/

}

}

===================================================================

Stack implementation

package ds.Stack;

public class Runner {

public static void main(String[] args)
{
  Stack stack = new Stack();
  stack.push(10);
  //stack.push(20);
// stack.push(30);

  stack.show();
  int pop1 = stack.pop();
  System.out.println("");
  System.out.println("Popped: "+pop1);
  stack.show();
 
  int peek1 = stack.peek();
  System.out.println("");
  System.out.println("Peeked: "+peek1);
  stack.show();
 
  System.out.println("");
  int size = stack.size();
  System.out.println("Size is:"+size);
 
  System.out.println("");
  stack.isEmpty();
 

}

}

=====================================================================

package ds.Stack;

public class Stack 

{

int[] stack = new int[5];

int  top = 0;

public void push(int i) 

{

if(top==5)

{

System.out.println("Stack is full");

return;

}

else

{

stack[top] = i;

top++;

}

}

public void show() 

{

for(int n :stack)

System.out.print(n+" ");

}

public int pop() 

{

if(top<=0)

{

System.out.println("Stack is Empty");

return 0;

}

else

{

int data;

top--;

data  = stack[top];

stack[top]= 0;

return data;

}

}

public int  peek() 

{

if(top<=0)

{

System.out.println("Stack is Empty");

return 0;

}

else

{

int data;

data  = stack[top -1];

return data;

}

}

public int size() 

{

  return (top);

}

public void  isEmpty() 

{

  if(top<=0)

  System.out.println("Stack is Empty");

  

  else

  System.out.println("Stack is NOT Empty");

  

}

}

========================================================================