import android.os.Bundle;
import android.app.Activity;
import android.view.Menu;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.EditText;
import java.sql.*;
import java.text.SimpleDateFormat;
import java.util.Date;


public class MainActivity extends Activity{
Button boton;
EditText date_text;
Connection con;

@Override
protected void onCreate(Bundle savedInstanceState){
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
date_text=(EditText)findViewById(R.id.txtDate);
boton=(Button)findViewById(R.id.button1);
boton.setOnClickListener(new OnClickListener(){

@Override
public void onClick(View arg0){

try{
//Class.forName(driver).newInstance();
Class.forName("oracle.jdbc.driver.OracleDriver");
//con= DriverManager.getConnection(url,usuario,pass);
con = DriverManager.getConnection("jdbc:oracle:thin:@192.168.1.4:1521:xe","anshi","anshi");
Statement st = con.createStatement();
SimpleDateFormat fmt = new SimpleDateFormat("dd-MM-yy");
Date date = fmt.parse(date_text.getText().toString());
String insertQuery = "Insert into student_date (col1) values ('"+date+"')";
st.executeUpdate(insertQuery);
st.close();
con.close();
}catch(Exception e){
date_text.setText(e.toString());
}
}
});
}


public boolean onCreateOptionMenu(Menu menu) {
getMenuInflater().inflate(R.menu.main,menu);
return true;
}
}