package com.example.administrator.testdate;
import android.os.Bundle;
import android.os.StrictMode;
import android.support.design.widget.FloatingActionButton;
import android.support.design.widget.Snackbar;
import android.support.v7.app.AppCompatActivity;
import android.support.v7.widget.Toolbar;
import android.view.Menu;
import android.view.MenuItem;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.Statement;
public class MainActivity extends AppCompatActivity {
String Username="root"; //数据库用户名
String Password="12345678"; //数据库用户密码
Button button1;
Button button2;
EditText textView1;
EditText textView2;
Connection conn=null;
Statement stmt=null;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
Toolbar toolbar = (Toolbar) findViewById(R.id.toolbar);
setSupportActionBar(toolbar);
button1 = (Button) findViewById(R.id.button1);
button2 = (Button) findViewById(R.id.button2);
textView1=(EditText)findViewById(R.id.editText2);
textView2=(EditText)findViewById(R.id.editText) ;
StrictMode.setThreadPolicy(new StrictMode.ThreadPolicy.Builder().detectDiskReads().detectDiskWrites().detectNetwork().penaltyLog().build());
StrictMode.setVmPolicy(new StrictMode.VmPolicy.Builder().detectLeakedSqlLiteObjects().detectLeakedClosableObjects().penaltyLog().penaltyDeath().build());
FloatingActionButton fab = (FloatingActionButton) findViewById(R.id.fab);
fab.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View view) {
Snackbar.make(view, "Replace with your own action", Snackbar.LENGTH_LONG)
.setAction("Action", null).show();
}
});
button1.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View v) {
connection();
}
});
button2.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View v) {
textView1.setText("");
textView2.setText("");
}
});
}
@Override
public boolean onCreateOptionsMenu(Menu menu) {
// Inflate the menu; this adds items to the action bar if it is present.
getMenuInflater().inflate(R.menu.menu_main, menu);
return true;
}
@Override
public boolean onOptionsItemSelected(MenuItem item) {
// Handle action bar item clicks here. The action bar will
// automatically handle clicks on the Home/Up button, so long
// as you specify a parent activity in AndroidManifest.xml.
int id = item.getItemId();
//noinspection SimplifiableIfStatement
if (id == R.id.action_settings) {
return true;
}
return super.onOptionsItemSelected(item);
}
public void connection()
{
String username = textView1.getText().toString();
String password=textView2.getText().toString();
if (username != null) {
//打开数据库
try {//注册驱动程序
Class.forName("com.mysql.jdbc.Driver");
} catch (java.lang.ClassNotFoundException e) {
System.err.println("Driver Error " + e.getMessage());
}
//连接数据库并创建Statement 对象
String sConnStr = "jdbc:mysql://localhost/testdate?user=" + Username + "&password=" + Password + "&useUnicode=true&characterEncoding=utf8";
try {
conn = DriverManager.getConnection(sConnStr);
conn.setAutoCommit(true);
//更新数据库
String sql = "insert into testdate(username,password) values(?,?)";
PreparedStatement sta = conn.prepareStatement(sql);
sta.setString(1, username);
sta.setString(2, password);
sta.executeUpdate();
sta.close();
conn.close();
} catch (Exception e) {
System.err.println("数据库连接错误: " + e.getMessage());
return;
}
}
}
}