主线程 调用
new Thread() {
@Override
public void run() {
try {
delete(names, passwords);
} catch (Exception e) {
e.printStackTrace();
}
}
}.start();
删除
private void delete(String a, String b) throws Exception {
//sql语句
String sql = "delete from dbo.Table_1 where name = ? and password=?";
PreparedStatement pstmt = null;
//连接
Class.forName("net.sourceforge.jtds.jdbc.Driver");
m_con = DriverManager.getConnection("jdbc:jtds:sqlserver://" + "ip" + ":1433/" + "数据名", "连接账号", "连接密码");
if (m_con != null)
try {
pstmt = m_con.prepareStatement(sql);
pstmt.setString(1, a);
pstmt.setString(2, b);
int i = pstmt.executeUpdate();
if (i == 0) {
Looper.prepare();
Toast.makeText(this, "删除失败", Toast.LENGTH_SHORT).show();
Looper.loop();
} else if (i != 0) {
Looper.prepare();
Toast.makeText(this, "删除成功", Toast.LENGTH_SHORT).show();
Looper.loop();
}
pstmt.close();
} catch (Exception e1) {
throw new Exception("操作中出现错误!!!");
} finally {
m_con.close();
}
}
new Thread() {
@Override
public void run() {
try {
//获取数据
names = name.getText().toString().trim();
passwords = password.getText().toString().trim();
//进行验证
select(names, passwords);
} catch (Exception e) {
e.printStackTrace();
}
}
}.start();
查询
private void select(String a, String b) throws Exception {
//sql语句
String sql = "select * from dbo.Table_1 where name = ? and password = ?";
PreparedStatement pstmt = null;
//连接
Class.forName("net.sourceforge.jtds.jdbc.Driver");
//sa 账号
//jh012700密码
m_con = DriverManager.getConnection("jdbc:jtds:sqlserver://" + "IP地址" + ":1433/" + "数据库名字", "账号", "密码");
if (m_con != null)
try {
pstmt = m_con.prepareStatement(sql);
pstmt.setString(1, a);
pstmt.setString(2, b);
ResultSet resultSet = pstmt.executeQuery();
while (resultSet.next()) {
Looper.prepare();
Toast.makeText(this, "登陆成功", Toast.LENGTH_SHORT).show();
Intent intent = new Intent(this, DisplayActivity.class);
startActivity(intent);
Looper.loop();
}
if (a.length() == 0 || b.length() == 0) {
Looper.prepare();
Toast.makeText(this, "账号和密码不能为空", Toast.LENGTH_SHORT).show();
Looper.loop();
} else {
Looper.prepare();
Toast.makeText(this, "账号密码有误", Toast.LENGTH_SHORT).show();
Looper.loop();
}
pstmt.close();
resultSet.close();
} catch (Exception e1) {
throw new Exception("操作中出现错误!!!");
} finally {
m_con.close();
}