Java Mssql Connection Example

JDBC 다운로드 : 여기

package test;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.Statement;

public class mssqlTest {

public static void main(String[] args) {

doGet();

}

public static void doGet() {

String userName = "";

String password = "";

String connectionString = "jdbc:sqlserver://mmsdb.s-oil.com:1433;DatabaseName=sms;user="+userName+";password="+password;

Connection con = null;

Statement stmt = null;

try {

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

con = DriverManager.getConnection(connectionString);

String SQL = "";

stmt = con.createStatement();

int a = stmt.executeUpdate(SQL);

con.close();

stmt.close();

} catch (Exception e) {

e.printStackTrace();

}

}

}