作者:浪子一品香_938 | 来源:互联网 | 2022-12-17 10:46
以下是登录界面的代码,整个工程运行并没有报错,只是在登录的时候登录不上去。packagecom.example.cuit_project;importjava.sql.Conne
以下是登录界面的代码,整个工程运行并没有报错,只是在登录的时候登录不上去。
package com.example.cuit_project;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import android.os.AsyncTask;
import android.os.Bundle;
import android.os.Handler;
import android.os.Message;
import android.app.Activity;
import android.app.ProgressDialog;
import android.content.Intent;
import android.util.Log;
import android.view.View;
import android.widget.EditText;
import android.widget.Toast;
public class LoginActivity extends Activity {
private EditText et_user;
private EditText et_pwd;
private Boolean fBoolean = false;
private String usertype;
private static ProgressDialog pdialog;
private static final int SHOW_PROCESS = 1;
private static final int DISMISS_PROCESS = 0;
private static Handler handler = new Handler() {
@Override
public void handleMessage(Message msg) {
switch (msg.what) {
case SHOW_PROCESS:
pdialog.show();
break;
case DISMISS_PROCESS:
pdialog.dismiss();
break;
}
}
};
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_login);
init();
}
private void init() {
// TODO Auto-generated method stub
et_user = (EditText) findViewById(R.id.et_name);
et_pwd = (EditText) findViewById(R.id.et_pwd);
}
public void login(View v) {
if (et_user.getText().toString().equals("")
|| et_pwd.getText().toString().equals("")) {
Toast.makeText(LoginActivity.this, "请输入用户名或者密码", Toast.LENGTH_LONG)
.show();
return;
}
pdialog = new ProgressDialog(LoginActivity.this);
pdialog.setProgressStyle(ProgressDialog.STYLE_SPINNER);
pdialog.setCancelable(false);
pdialog.setMessage("服务器正在全力加载中哟亲!");
new AsyncTask
() {
@Override
protected Void doInBackground(Void... params) {
// TODO Auto-generated method stub
handler.sendMessage(handler.obtainMessage(SHOW_PROCESS));
String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://192.168.173.1:3306/project_home";//
String user = "root";
try {
Class.forName(driver);
Connection conn = DriverManager.getConnection(url, user,
"");
if (!conn.isClosed()){
Log.i("out", "connected");
System.out.println("Succeeded connecting to the Database!");}
// statement用来执行SQL语句
Statement statement = conn.createStatement();
// 结果
ResultSet rs;
rs = statement.executeQuery("select * from user");
String name="hxy";
String pwd="321";
while (rs.next()) {
name = rs.getString("username");
pwd = rs.getString("password");
if (et_user.getText().toString().equals(name)
&& et_pwd.getText().toString().equals(pwd)) {
fBoolean = true;
usertype = rs.getString("usertype");
rs.close();
conn.close();
return null ;
}
}
rs.close();
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return null;
}
@Override
protected void onPostExecute(Void result) {
// TODO Auto-generated method stub
handler.sendMessage(handler.obtainMessage(DISMISS_PROCESS));
if (fBoolean) {
Intent it = new Intent().setClass(LoginActivity.this,
MenuActivity.class);
it.putExtra("usertype", usertype);
startActivity(it);
finish();
} else {
Toast.makeText(LoginActivity.this, "天了噜,竟然登陆失败,不要生气,再试一次吧",
Toast.LENGTH_LONG).show();
}
super.onPostExecute(result);
}
}.execute();
}
}
求求求解。。。。。。
5 个解决方案