SqlServer驱动包下载
http://download.csdn.net/detail/silentwolfyh/9062955
package cn.yc.com.util;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import org.apache.log4j.Logger;
import org.junit.Test;
import cn.yc.com.Test.logs.logs;
/***
*
* <p>Description: 连接sqlserver数据库</p>
* @author 余辉
* @date 2015年7月27日上午9:09:33
* @version 1.0
*/
public class ConnectionSqlServer {
private static Logger logger = Logger.getLogger(ConnectionSqlServer.class.getName());
static String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
static String dbURL = "jdbc:sqlserver://IP:10088;databasename=NAME"; // 1433是端口,"USCSecondhandMarketDB"是数据库名称
static String userName = "USER"; // 用户名
static String userPwd = "PWD"; // 密码
public Connection getConn() {
Connection dbConn = null;
try {
dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
} catch (Exception e) {
e.printStackTrace();
logger.error("ConnectionSqlServer:Exception"+e.getMessage());
}
return dbConn;
}
@Test
public void sqlINSERT() throws SQLException{
ConnectionSqlServer getConnectionSqlServer = new ConnectionSqlServer();
Connection dbConn = getConnectionSqlServer.getConn();
Statement sta=dbConn.createStatement();
sta.execute("INSERT INTO IpAddressArea VALUES('198.168.2.10','中国11','01','北京','010','海淀区','100084','五道口','12346','北京','010','五道口','12346');");
}
@Test
public void sqlQuery() throws SQLException{
ConnectionSqlServer getConnectionSqlServer = new ConnectionSqlServer();
Connection dbConn = getConnectionSqlServer.getConn();
Statement sta=dbConn.createStatement();
ResultSet rs=sta.executeQuery("SELECT * FROM IpAddressArea WHERE Ip = '61.54.105.49'");
while(rs.next()){
String Ip=rs.getString("Ip");
System.out.println(Ip);
}
}
}