java sqlserver 2008语句_java 连接sqlserver数据库并执行sql语句

java 连接sqlserver数据库，并执行sql语句

public class LinkDB {

public static void main(String[] args) {

List list = connect();

}

//连接数据库执行语句

private static List connect() {

List arr = new ArrayList();

try {

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

String url = "jdbc:sqlserver://ip:port;database=数据库名";

String user = "用户名";

String password = "密码";

Connection con = DriverManager.getConnection(url, user, password);

Statement statement = con.createStatement();

ResultSet re = statement.executeQuery("SELECT DISTINCT name FROM table");//执行查询语句，接收结果集

while (re.next()) {

arr.add(re.getString("name"));

}

} catch (ClassNotFoundException e) {

e.printStackTrace();

} catch (SQLException e) {

e.printStackTrace();

}

return arr;

}

}