<%@ page language="java" contentType="text/html; charset=EUC-KR"
pageEncoding="EUC-KR"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=EUC-KR">
<title>Insert title here</title>
</head>
<body>
<%@ page import="java.sql.*" %>
<% request.setCharacterEncoding("euc-kr"); %>
<%
Connection con = null;
Statement stmt = null;
try{
String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
String dbURL="jdbc:sqlserver://localhost:1433;databaseName=BaseBall";
Class.forName(driverName);
con = DriverManager.getConnection(dbURL,"sa","2890buybs");
out.println("¿¬°á ¼º°ø");
}
catch(Exception e){
out.println("¿¬°á ½ÇÆÐ <br>");
out.println(e.getMessage());
out.println(e.toString());
e.printStackTrace();
}
-------------------------------------------------------------------------------
try{
stmt = con.createStatement();
ResultSet result = stmt.executeQuery("select * from match");
out.println("¿¬°á ¼º°ø");
}
catch(Exception e){
out.println("¿¬°á ½ÇÆÐ <br>");
out.println(e.getMessage());
out.println(e.toString());
e.printStackTrace();
}
%>
</body>
</html>
¼± ±×Àº ÀºÎºÐÀ» ½ÇÇà ½ÃŰ¸é ¿¬°á ¼º°øÀ̶ó°í ¶ß´Âµ¥
¼± ±×Àº ¾Æ·§ºÎºÐÀ» ³Ö±â¸¸ ÇÏ¸é ½ºÅ©¸³Æ® ¿À·ù°¡ ³³´Ï´Ù
¾î¶»°Ô ÇØ°áÇØ¾ß µÇ³ª¿ä???