连接sqlserver

主线程 调用

    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();
            }