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;
} }
}
}
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;
} }
}
}
11-16 14:13:38.310 2491-2491/? W/art: Unexpected CPU variant for X86 using defaults: x86
11-16 14:13:38.579 2491-2491/com.example.administrator.testdate W/System: ClassLoader referenced unknown path: /data/app/com.example.administrator.testdate-2/lib/x86
11-16 14:13:38.590 2491-2491/com.example.administrator.testdate I/InstantRun: starting instant run server: is main process
11-16 14:13:38.803 2491-2491/com.example.administrator.testdate W/art: Before Android 4.1, method android.graphics.PorterDuffColorFilter android.support.graphics.drawable.VectorDrawableCompat.updateTintFilter(android.graphics.PorterDuffColorFilter, android.content.res.ColorStateList, android.graphics.PorterDuff$Mode) would have incorrectly overridden the package-private method in android.graphics.drawable.Drawable
11-16 14:13:39.505 2491-2554/com.example.administrator.testdate I/OpenGLRenderer: Initialized EGL, version 1.4
11-16 14:13:39.505 2491-2554/com.example.administrator.testdate D/OpenGLRenderer: Swap behavior 1
11-16 14:13:39.506 2491-2554/com.example.administrator.testdate W/OpenGLRenderer: Failed to choose config with EGL_SWAP_BEHAVIOR_PRESERVED, retrying without...
11-16 14:13:39.506 2491-2554/com.example.administrator.testdate D/OpenGLRenderer: Swap behavior 0
11-16 14:13:39.522 2491-2554/com.example.administrator.testdate D/EGL_emulation: eglCreateContext: 0xa2dd85a0: maj 2 min 0 rcv 2
11-16 14:13:39.542 2491-2554/com.example.administrator.testdate D/EGL_emulation: eglMakeCurrent: 0xa2dd85a0: ver 2 0 (tinfo 0xa2dfd7d0)
11-16 14:13:39.586 2491-2491/com.example.administrator.testdate W/art: Before Android 4.1, method int android.support.v7.widget.ListViewCompat.lookForSelectablePosition(int, boolean) would have incorrectly overridden the package-private method in android.widget.ListView
11-16 14:13:39.646 2491-2554/com.example.administrator.testdate D/EGL_emulation: eglMakeCurrent: 0xa2dd85a0: ver 2 0 (tinfo 0xa2dfd7d0)
11-16 14:13:41.731 2491-2491/com.example.administrator.testdate W/IInputConnectionWrapper: finishComposingText on inactive InputConnection
11-16 14:13:51.190 2491-2491/com.example.administrator.testdate W/IInputConnectionWrapper: finishComposingText on inactive InputConnection
11-16 14:14:12.440 2491-2554/com.example.administrator.testdate D/EGL_emulation: eglMakeCurrent: 0xa2dd85a0: ver 2 0 (tinfo 0xa2dfd7d0)
11-16 14:14:12.456 2491-2554/com.example.administrator.testdate D/EGL_emulation: eglMakeCurrent: 0xa2dd85a0: ver 2 0 (tinfo 0xa2dfd7d0)
11-16 14:14:16.624 2491-2496/com.example.administrator.testdate I/art: Do partial code cache collection, code=27KB, data=28KB
11-16 14:14:16.625 2491-2496/com.example.administrator.testdate I/art: After code cache collection, code=27KB, data=28KB
11-16 14:14:16.625 2491-2496/com.example.administrator.testdate I/art: Increasing code cache capacity to 128KB
11-16 14:14:16.736 2491-2491/com.example.administrator.testdate W/System.err: Last packet sent to the server was 0 ms ago.
11-16 14:14:16.737 2491-2491/com.example.administrator.testdate D/StrictMode: StrictMode policy violation; ~duration=129 ms: android.os.StrictMode$StrictModeDiskReadViolation: policy=65543 violation=2
at android.os.StrictMode$AndroidBlockGuardPolicy.onReadFromDisk(StrictMode.java:1293)
at java.io.UnixFileSystem.getLength(UnixFileSystem.java:263)