Mssql 과 Java 연결테스트 2003/07/11

JDBC 용 MSSQL 드라이버 http://microsoft.com/korea/msdn/MSDN-FILES/027/001/779/msdncompositedoc.asp

아래는 SqlTest2.java 파일



import java.sql.*;

class SqlTest2 {
public static void main(String[] arguments){
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");

Connection conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://211.235.151.240:1433;DatabaseName=디비이름","아이디","암호");
Statement stmt = conn.createStatement();
stmt.executeUpdate("careate table mytable5(name varchar(10))");

System.out.println("ok");

stmt.close();
conn.close();
}catch (Exception e){
System.out.println("Error "+e.getMessage());
}
}
}



//con = DriverManager.getConnection("jdbc:microsoft:sqlserver://DB아이피:1433;DatabaseName=테이블명","계정","비번");