연결하기 전에 포트 SQL 서버 포트번호 확인하고 포토 열렸는지 확인한다.
ms-sql JDBC드라이버 설치한후 연결.테스트
<%@ page contentType = "text/html;charset=euc-kr" %>
<%@ page import = "java.sql.*" %>
<%
String dbDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String dbUrl = "jdbc:microsoft:sqlserver://IPAddress:1433;DatabaseName=jsp";
String dbId = "sa";
String dbPw = "password";
Connection conn = null;
Statement stmt = null;
try
{
Class.forName( dbDriver );
conn = DriverManager.getConnection( dbUrl, dbId, dbPw );
stmt = conn.createStatement();
conn.close();
out.println("mssql jdbc test: connect ok!!");
}
catch( Exception e )
{
out.println(e);
}
%>
ms-sql JDBC드라이버 설치한후 연결.테스트
<%@ page contentType = "text/html;charset=euc-kr" %>
<%@ page import = "java.sql.*" %>
<%
String dbDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String dbUrl = "jdbc:microsoft:sqlserver://IPAddress:1433;DatabaseName=jsp";
String dbId = "sa";
String dbPw = "password";
Connection conn = null;
Statement stmt = null;
try
{
Class.forName( dbDriver );
conn = DriverManager.getConnection( dbUrl, dbId, dbPw );
stmt = conn.createStatement();
conn.close();
out.println("mssql jdbc test: connect ok!!");
}
catch( Exception e )
{
out.println(e);
}
%>