实际工作中，闲来想试一试通过java连接sql server 数据库并进行DDL操作。网上的例子数不胜数，实测有效，不过觉得对目前的工作有点鸡肋。在此仅做记载之用~~~后续如果又需要，再继续研究！
需要先下载sqljdbc4：
下载地址（地址可能会失效，是因为我整理了网盘资料）： http://pan.baidu.com/s/1gfv7VTT
最简单的代码来了：
package com.jdbc; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; import java.util.ArrayList; import java.util.List; public class jdbctest { static String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; static String dbURL = "jdbc:sqlserver://192.168.27.51;DatabaseName=OMS"; static String userName = "OMS"; static String userPwd = "9ol.?:P)"; public static void main(String[] args) { Statement stmt = null; try { Class.forName(driverName); Connection dbConn = DriverManager.getConnection(dbURL, userName, userPwd); System.out.println("连接数据库成功"); stmt = dbConn.createStatement(); String sql = "select * from area"; // String sql = "update area set ManagerMobile = 13818386575"; try { ResultSet rs = stmt.executeQuery(sql); // int rs = stmt.executeUpdate(sql); while (rs.next()) { String result = rs.getString("remark")+ "," + rs.getString("ManagerMobile"); List<String> ls = new ArrayList<String>(); ls.add(result); System.out.println(ls); } } catch (Exception e) { e.printStackTrace(); } } catch (Exception e) { e.printStackTrace(); System.out.print("连接失败"); } } }再接再厉，加把劲，争取突破！！！
