实际工作中,闲来想试一试通过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("连接失败");
}
}
}
再接再厉,加把劲,争取突破!!!