package com.example.prejtds;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import android.os.Bundle;
import android.app.Activity;
import android.util.Log;
import android.view.Menu;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.Toast;
public class MainActivity extends Activity {
Button show;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
show = (Button) findViewById(R.id.btn_show);
show.setOnClickListener(new OnClickListener() {
@Override
public void onClick(View arg0) {
query2(); }
});
}
@Override
public boolean onCreateOptionsMenu(Menu menu) {
// Inflate the menu; this adds items to the action bar if it is present.
getMenuInflater().inflate(R.menu.main, menu);
return true;
}
public void query2()
{
Log.i("Android"," SQL Connect Example.");
Connection conn = null;
try {
String driver = "net.sourceforge.jtds.jdbc.Driver";
Class.forName(driver).newInstance();
//SQL Server name=HNI-03-PC,Computer Name=HNI-03, user=nikhil502, password=ocean502, //instance=MSSQLSERVER.
String connString ="jdbc:jtds:sqlserver://HNI-03-PC/nikhil;instance=MSSQLSERVER";
conn = DriverManager.getConnection(connString,"nikhil502","ocean502");
Log.w("Connection","open");
Toast.makeText(MainActivity.this, "connection estabilished",Toast.LENGTH_LONG).show();
Statement stmt = conn.createStatement();
ResultSet reset = stmt.executeQuery("select * from emp_details");
while(reset.next()){
Log.w("Data:",reset.getString(3));
Log.w("Data",reset.getString(2)); }
conn.close();
} catch(SQLException e){
Log.w("Error connection","" + e.getMessage());
} catch (Exception e)
{
Log.w("Error connection","" + e.getMessage());
}
}
}