Information technology: 2015

Tuesday, December 29, 2015

BLUETOOTH FILE TRANSFER CODING IN JAVA:

MainActivity.java

package com.example.bluetoothdatatransfer;

import java.io.File;

import java.util.List;

import android.bluetooth.BluetoothAdapter;

import android.content.Intent;

import android.content.pm.PackageManager;

import android.content.pm.ResolveInfo;

import android.net.Uri;

import android.os.Bundle;

import android.os.Environment;

import android.support.v7.app.ActionBarActivity;

import android.view.View;

import android.widget.Toast;

public class MainActivity extends ActionBarActivity {

private static final int DISCOVER_DURATION = 300;

private static final int REQUEST_BLU = 1;

@Override

protected void onCreate(Bundle savedInstanceState) {

super.onCreate(savedInstanceState);

setContentView(R.layout.activity_main);

}

public void sendViaBluetooth(View v) {

BluetoothAdapter btAdapter = BluetoothAdapter.getDefaultAdapter();

if(btAdapter == null) {

Toast.makeText(this, "Bluetooth is not supported on this device", Toast.LENGTH_LONG).show();

} else {

enableBluetooth();

}

public void enableBluetooth() {

Intent discoveryIntent = new Intent(BluetoothAdapter.ACTION_REQUEST_DISCOVERABLE);

discoveryIntent.putExtra(BluetoothAdapter.EXTRA_DISCOVERABLE_DURATION, DISCOVER_DURATION);

startActivityForResult(discoveryIntent, REQUEST_BLU);

}

@Override

protected void onActivityResult(int requestCode, int resultCode, Intent data) {

if(resultCode == DISCOVER_DURATION && requestCode == REQUEST_BLU) {

Intent intent = new Intent();

intent.setAction(Intent.ACTION_SEND);

intent.setType("text/plain");

File f = new File(Environment.getExternalStorageDirectory(), "ganesh.txt");

intent.putExtra(Intent.EXTRA_STREAM, Uri.fromFile(f));

PackageManager pm = getPackageManager();

List<ResolveInfo> appsList = pm.queryIntentActivities(intent, 0);

if(appsList.size() > 0) {

String packageName = null;

String className = null;

boolean found = false;

for(ResolveInfo info : appsList) {

packageName = info.activityInfo.packageName;

if(packageName.equals("com.android.bluetooth")) {

className = info.activityInfo.name;

found = true;

break;

}

if (!found) {

Toast.makeText(this, "Bluetooth havn't been found",

Toast.LENGTH_LONG).show();

} else {

intent.setClassName(packageName, className);

startActivity(intent);

}

} else {

Toast.makeText(this, "Bluetooth is cancelled", Toast.LENGTH_LONG)

.show();

}

ACTIVITYMAIN.XML

<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"

xmlns:tools="http://schemas.android.com/tools"

android:layout_width="match_parent"

android:layout_height="match_parent"

android:paddingBottom="@dimen/activity_vertical_margin"

android:paddingLeft="@dimen/activity_horizontal_margin"

android:paddingRight="@dimen/activity_horizontal_margin"

android:paddingTop="@dimen/activity_vertical_margin"

tools:context="com.example.bluetoothdatatransfer.MainActivity" >

<Button

android:layout_height="wrap_content"

android:layout_width="wrap_content"

android:text="Send via Bluetooth"

android:onClick="sendViaBluetooth"/>

</RelativeLayout>

AndroidManifest.XML

<uses-permission android:name="android.permission.BLUETOOTH"/>

<uses-permission android:name="android.permission.BLUETOOTH_ADMIN"/>

<uses-permission android:name="android.permission.READ_EXTERNAL_STORAGE"/>

<uses-permission android:name="android.permission.WRITE_EXTERNAL_STORAGE"/>

Monday, December 28, 2015

PARTICULAR ROW DELETION LOGIC IN BOTH HTML TABLE AND ALSO IN BACKEND

TO DELETE PARTICULAR ROW IN HTML TABLE AND ALSO IN BACK END

(LOGICS IN JSP):-

<h1> PROJECT LIST</h1>

<tr>

<td>

PROJECT ID

</td>

PROJECT NAME

</td>

<td>

DEAD LINE DATE

</td>

<td>

STATUS

</td>

<td>

ASSIGN PROJECTS

</td>

</tr>

List<String> projids = new ArrayList<String>();

List<String> members = new TeamClassInter().GetdATA();

String memid = new TeamClassInter().getMemid();

System.out.println("MEMBERS ID.." + memid);

ArrayList memids = new ArrayList(Arrays.asList(memid.split(",")));

String val = session.getAttribute("curteam").toString();

List<String> groupdata = new ArrayList(Arrays.asList(val.split(",")));

String tid = groupdata.get(0);

String tname = groupdata.get(1);

Statement stm = new Database_Connection().Database_Connection1().createStatement();

ResultSet rs = stm.executeQuery("select * from projects where assignedgroupid='" + tid + "'");

while (rs.next()) {

<tr>

String projid = rs.getString("projid");

String status = rs.getString("status");

projids.add(projid);

<option value="SELECT TEAM">MEMBERS</option>

for (int i = 0; i < memids.size(); i++) {

out.println("<option value=" + memids.get(i) + ">" + members.get(i) + "</option>");

}

</select>

<a href="confirmstatus.jsp?conid=<%=projid + "," + status%>" onclick="return confirm('Are You Sure want to Transfer the Status..? ');">CONFIRM_STATUS</a>

</td>

</tr>

}

TeamClassInter.setData3(projids);

</table>

CALLING JSP SERVLET PAGE FOR CALLING DELETING ID:

<%@page import="java.util.Arrays"%>

<%@page import="java.util.ArrayList"%>

<%@page import="java.sql.Statement"%>

<%@page import="minnning.data.Database_Connection"%>

<%@page import="java.sql.Connection"%>

<%@page contentType="text/html" pageEncoding="UTF-8"%>

<!DOCTYPE html>

<html>

<head>

<title>CONFIRM STATUS</title>

</head>

<body>

String consdatum=request.getParameter("conid");

ArrayList condata= new ArrayList(Arrays.asList(consdatum.split(",")));

String conid=condata.get(0).toString();

String condname=condata.get(1).toString();

Connection con=new Database_Connection().Database_Connection1();

String query="update projects set leadstatus='"+condname+"' where projid='"+conid+"'";

Statement stm=con.createStatement();

stm.executeUpdate(query);

con.close();

out.println ("<html><body><script>alert('STATUS SUCCESSFULLY SUBMITED TO TEAM MANAGER..');</script></body></html>");

RequestDispatcher rs1 = request.getRequestDispatcher("teamprojects.jsp");

rs1.include(request,response);

</body>

</html>

AJAX DATA FETCH IN JSP :

JAVA SCRIPT FUNCTION TO CALL AJAX:

function loadXMLDoc()

{

var xmlhttp;

var keys = document.assignNewTask.team.value

var urls = "Emp_Fetch.jsp?ok=" + keys

if (window.XMLHttpRequest)

{

xmlhttp = new XMLHttpRequest();

}

else

{

xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");

}

xmlhttp.onreadystatechange = function ()

{

removeall();

if (xmlhttp.readyState == 4)

{

z = 0;

var roott = xmlhttp.responseXML.documentElement;

var ress = roott.getElementsByTagName("membername")[z].childNodes[0].nodeValue;

while (ress != null)

{

addoptions(ress)

z++

var ress = roott.getElementsByTagName("membername")[z].childNodes[0].nodeValue;

}

function removeall()

{

var ct = document.assignNewTask.name.length;

for (i = ct; i >= 0; i--)

{

document.assignNewTask.name.options[i] = null;

}

function addoptions(reslt)

{

// alert(reslt);

var ct1 = document.createElement("OPTION");

ct1.text = reslt;

ct1.value = reslt;

document.assignNewTask.name.options.add(ct1);

}

xmlhttp.open("GET", urls, true);

xmlhttp.send();

}

</script>

CALLING AJAX FUNCTION IN SELECT TAG:

SELECT TEAM :

<option value="">---Select Team---</option>

String name = "";

String gid="0";

int size=0;

Connection con1 = Database_Connection1.Database_Connection2();

Statement stmg=con1.createStatement();

ResultSet rslen=stmg.executeQuery("select length(groupid) as size from teamleads where Tid='"+Tid+"'");

while(rslen.next())

{

size=rslen.getInt("size");

}

con1.close();

for(int i=0;i<size;i++)

{

ResultSet rs = stm.executeQuery(" select gnanme,gid from groups where gid=(select SPLIT_STR(groupid,',',"+i+") from teamleads where Tid='"+Tid+"')");

while (rs.next())

{

name = rs.getString("gnanme");

gid=rs.getString("gid");

<%}

}%>

</select>

Employee name :

<select name="name"> //AJAX DROPDOWN

<option value="">--Choose Employee Name--</option>

</select>

JSPSERVLET:-

<%@page import="java.util.ArrayList"%>

<%@page import="java.util.List"%>

<%@page import="com.pack.Database_Connection1"%>

<%@page import="java.sql.ResultSet"%>

<%@page import="java.sql.Statement"%>

<%@page import="java.sql.Connection"%>

<%@page import="javax.naming.InitialContext"%>

<%@page import="javax.sql.DataSource"%>

<%@page import="javax.naming.Context"%>

<%@ page contentType="text/html" pageEncoding="UTF-8"%>

response.setContentType("text/xml");

try

{

String gid = request.getParameter("ok");

List<String> memnames=new ArrayList<String>();

String name = "";

int size = 0;

Connection con1 = Database_Connection1.Database_Connection2();

Statement stmg = con1.createStatement();

ResultSet rslen = stmg.executeQuery("select length(membersid) as size from groups where gid='" + gid + "'");

while (rslen.next()) {

size = rslen.getInt("size");

System.out.println("GIVEN SIZE.."+size);

}

for (int i = 0; i <=size; i++)

{

ResultSet rs = stmg.executeQuery(" select membername from members where memid=(select SPLIT_STR(membersid,','," +i+ ") from groups where gid='" + gid + "')");

while (rs.next()) {

memnames.add(rs.getString(1));

}

System.out.println("SIZE .."+memnames.size());

if(memnames.size()>1)

{

System.out.println("GREATER VALE..");

out.println("<members>");

for(int i=0;i<memnames.size();i++)

{

out.println("<membername>" + memnames.get(i) + "</membername>");

}

out.println("</members>");

}

else

{

System.out.println("GREATER VALE other..");

out.println("<members>");

out.println("<membername>" + memnames.get(0) + "</membername>");

out.println("</members>");

}

stmg.close();

con1.close();

}

catch(Exception ex)

{

System.out.println("ERROR.."+ex.getMessage());

}