我就是憨批，真的是佛了，讓我亂刪還得重新連又多搞了一個(gè)多小時(shí)，草
package com.example.listview;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

/**

• Created by Administrator on 2017/12/14.
  */

public class DbUtil {
//連接數(shù)據(jù)庫(kù)
private static Connection getSQLConnection(String ip,String user,String pwd,String db)
{
Connection con =null;
try {
Class.forName("net.sourceforge.jtds.jdbc.Driver");
//一定要在AndroidManifest.xml中加入socket權(quán)限，不然會(huì)包權(quán)限錯(cuò)誤
/*



*/
con = DriverManager.getConnection("jdbc:jtds:sqlserver://"+ip+":1433/"+db+";charset=utf-8",user,pwd);
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return con;

}
//登陸
public static String QuerySQL(){

    String result="";

    try {
        //要想連接數(shù)據(jù)庫(kù)必須導(dǎo)入相應(yīng)的包在libs中（jtds-1.2.7.jar和sqljdbc.jar）
        Connection conn = getSQLConnection("127.0.0.1","sa","huang0529","pro");
        String sql = "SELECT * FROM student"; //查詢語(yǔ)句
        Statement stmt = conn.createStatement();//得到PreparedStatement對(duì)象
        ResultSet rs = stmt.executeQuery(sql);//執(zhí)行查詢語(yǔ)句

        while(rs.next())
        {
            String s1 = rs.getString("name");
            String s2 = rs.getString("score");//列名
            result += s1+" - " + s2 + "\n";
            System.out.println(s1+" - "+s2);
        }
        rs.close();
        stmt.close();
        conn.close();
    } catch (SQLException e) {
        e.printStackTrace();
        result += "查詢數(shù)據(jù)異常！"+e.getMessage();
    }
    return result;
}

public static void main(String[] args){
    QuerySQL();

}

}這是as
package shu;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class Testdb {

public static void main(String[] args) {
	String JDriver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";// SQL數(shù)據(jù)庫(kù)引擎
	String connectDB = "jdbc:sqlserver://127.0.0.1:1433;DatabaseName=pro";// 數(shù)據(jù)源注意IP地址和端口號(hào)，數(shù)據(jù)庫(kù)名字！！！
	try {
		Class.forName(JDriver);// 加載數(shù)據(jù)庫(kù)引擎，返回給定字符串名的類
	} catch (ClassNotFoundException e) {
		// e.printStackTrace();
		System.out.println("加載數(shù)據(jù)庫(kù)引擎失敗");
		System.exit(0);
	}
	System.out.println("數(shù)據(jù)庫(kù)驅(qū)動(dòng)成功");
	try {
		String user = "root";// 你自己創(chuàng)建的用戶名字和密碼！！！！！！！！！！！！
		String password ="root";
		Connection con = DriverManager.getConnection(connectDB, user,
				password);// 連接數(shù)據(jù)庫(kù)對(duì)象
		System.out.println("連接數(shù)據(jù)庫(kù)成功");
		Statement stmt = con.createStatement();// 創(chuàng)建SQL命令對(duì)象
		// 創(chuàng)建表
		System.out.println("查詢");
		System.out.println("開(kāi)始讀取數(shù)據(jù)");
		ResultSet rs = stmt.executeQuery("SELECT * FROM student");// 返回SQL語(yǔ)句查詢結(jié)果集(集合)
		// 循環(huán)輸出每一條記錄
		while (rs.next()) {
			// 輸出每個(gè)字段
			System.out.println(rs.getString("id") + "\t"
					+ rs.getString("name"));
		}
		System.out.println("讀取完畢");
		// 關(guān)閉連接
		stmt.close();// 關(guān)閉命令對(duì)象連接
		con.close();// 關(guān)閉數(shù)據(jù)庫(kù)連接
	} catch (SQLException e) {
		e.printStackTrace();
		// System.out.println("數(shù)據(jù)庫(kù)連接錯(cuò)誤");
		System.exit(0);
	}
}

}這是ecplise