Android studio连接数据库问题

qq_38772327 2017-11-16 10:26:53
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;
}

}
}
}
...全文
339 3 打赏 收藏 转发到动态 举报
写回复
用AI写文章
3 条回复
切换为时间正序
请发表友善的回复…
发表回复
qq_38772327 2017-11-16
  • 打赏
  • 举报
回复
11-16 14:14:16.736 2491-2491/com.example.administrator.testdate W/System.err: 数据库连接错误: Communications link failure 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)
qq_38772327 2017-11-16
  • 打赏
  • 举报
回复
11-16 14:13:38.309 2491-2491/? I/art: Not late-enabling -Xcheck:jni (already on) 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
qq_38772327 2017-11-16
  • 打赏
  • 举报
回复
麻烦各位大佬帮我看看错在哪里 运行虚拟器不能连接数据啊

80,351

社区成员

发帖
与我相关
我的任务
社区描述
移动平台 Android
androidandroid-studioandroidx 技术论坛(原bbs)
社区管理员
  • Android
  • yechaoa
  • 失落夏天
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧