Prepapred Statement INSERT

package jdbc;

import java.sql.Connection;
import java.sql.*;
import java.sql.SQLException;

public class Insert_PreparedStatement {

public static void main(String[] args) throws ClassNotFoundException,SQLException
{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","hr","hr");
//Statement st = con.createStatement();
String query = "insert into JDBC_SAMPLE_FBI values(?,?,?,?)";
PreparedStatement ps = con.prepareStatement(query);
ps.setInt(1, 490);
ps.setString(2, "Amit");
ps.setInt(3, 777);
ps.setInt(4,999);
int res = ps.executeUpdate();
if(res>0)
System.out.println("Values inserted");
con.close();





}

}

First JDBC

package jdbc;

import java.sql.*;
import java.sql.DriverManager;
import java.sql.SQLException;

public class First_Jdbc {

public static void main(String[] args) throws ClassNotFoundException, SQLException
{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con= DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "scott", "tiger");
Statement st = con.createStatement();
ResultSet rs = st.executeQuery("select * from fan");
while(rs.next())
{
System.out.println(rs.getInt(1)+"...."+rs.getString(2)+"...."+rs.getString(3));
}
rs.close();
st.close();
con.close();


}

}

Drop Table

package jdbc;

import java.sql.DriverManager;
import java.sql.*;
import java.util.*;

public class DropTableDemo {

public static void main(String[] args)throws ClassNotFoundException,SQLException 
{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","hr","hr");
Statement st = con.createStatement();
st.executeUpdate("drop table demo2");
System.out.println("table deleted");
con.close();
}

}

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,