{"id":459,"date":"2018-08-20T19:08:31","date_gmt":"2018-08-20T10:08:31","guid":{"rendered":"http:\/\/csharp.ihavenomoney.co.kr\/?p=459"},"modified":"2020-08-13T09:53:23","modified_gmt":"2020-08-13T00:53:23","slug":"459","status":"publish","type":"post","link":"https:\/\/csharp.ihavenomoney.co.kr\/?p=459","title":{"rendered":"\uc790\ubc14 \ub514\ube44 \uc5f0\uacb0"},"content":{"rendered":"

\"\"<\/a>\"\"<\/a><\/p>\n

JAVA<\/strong><\/p>\n

package javaDB;\r\nimport java.sql.*;\r\nimport com.microsoft.sqlserver.jdbc.*;\r\n\r\npublic class test {\r\n\r\npublic static void main(String[] args) {\r\n\t\t\r\n\t\t\/\/ Declare the JDBC objects.\r\n\t\tConnection con = null;\r\n\t\tCallableStatement cstmt = null;\r\n\t\tResultSet rs = null;\r\n\t\t\r\n\t\ttry {\r\n\t\t\t\/\/ Establish the connection. \r\n\t\t\tSQLServerDataSource ds = new SQLServerDataSource();\r\n\t\t\t\r\n\t\t\t\/\/ds.setIntegratedSecurity(true);\r\n\t\t\tds.setServerName(\"localhost\");\r\n\t\t\tds.setPortNumber(1433); \r\n\t\t\tds.setDatabaseName(\"WSP_IBE\");\r\n\t\t\tds.setUser(\"user01\");\r\n\t\t\tds.setPassword(\"password01\");\r\n\t\t\tcon = ds.getConnection();\r\n\t\t\t \r\n\t        \t\/\/ Execute a stored procedure that returns some data.\r\n            \t\tcstmt = con.prepareCall(\"{call dbo.uspGetAircraft()}\");\r\n            \t\t\/\/cstmt.setInt(1, 50);\r\n            \t\trs = cstmt.executeQuery();\r\n\r\n\t        \t\/\/ Iterate through the data in the result set and display it.\r\n\t        \twhile (rs.next()) {\r\n\t            \t\tSystem.out.println(\"aircraft_code: \" + rs.getString(\"aircraft_code\"));\r\n\t            \t\tSystem.out.println(\"aircraft_english: \" + rs.getString(\"aircraft_english\"));\r\n\t            \t\tSystem.out.println();\r\n\t        \t}\r\n\t        }\r\n\t        \r\n\t\t\/\/ Handle any errors that may have occurred.\r\n\t    \tcatch (Exception e) {\r\n\t    \t\te.printStackTrace();\r\n\t    \t}\r\n\r\n\t   \tfinally {\r\n\t    \t\tif (rs != null) try { rs.close(); } catch(Exception e) {}\r\n\t    \t\tif (cstmt != null) try { cstmt.close(); } catch(Exception e) {}\r\n\t    \t\tif (con != null) try { con.close(); } catch(Exception e) {}\r\n\t    \t}\r\n\t}\r\n}<\/pre>\n
JSP mysql<\/strong><\/p>\n
<%@ page language=\"java\" contentType=\"text\/html; charset=UTF-8\" pageEncoding=\"UTF-8\"%>\r\n<%@ page import=\"java.sql.*\" %> \r\n \r\n<html> \r\n<head> \r\n<title>Connection with mysql database<\/title> \r\n<\/head> \r\n<body>\r\n<h1>Connection status <\/h1>\r\n\r\n<table>\r\n\r\n<%\r\nString connectionURL = \"jdbc:mysql:\/\/localhost:3306\/IBE?characterEncoding=UTF-8&serverTimezone=UTC\"; \r\n\r\nConnection connection = null; \r\nPreparedStatement pstmt = null;\r\nResultSet rs = null;\r\n\r\ntry{\r\n\tClass.forName(\"com.mysql.jdbc.Driver\").newInstance(); \r\n\tconnection = DriverManager.getConnection(connectionURL, \"user02\", \"user99\");\r\n    \r\n    String query =\"SELECT \ufeffairline_code,airline_korean FROM IBE.Airlines where \ufeffairline_code = ?\";\r\n    \/\/String query =\"SELECT \ufeffairline_code,airline_korean FROM IBE.Airlines\";\r\n    \r\n    pstmt = connection.prepareStatement(query); \r\n    pstmt.setString(1,\"OZ\");\r\n       \t\t\r\n    rs = pstmt.executeQuery();\r\n    \r\n    while(rs.next()){\t\r\n    \tString airline_code = rs.getString(\"\ufeffairline_code\");\r\n    \tString airline_korean = rs.getString(\"airline_korean\"); \r\n%>\r\n\t \t<tr>\r\n\t\t\t<td width=\"100\"><%=airline_code%><\/td>\r\n\t\t\t<td width=\"100\"><%=airline_korean%><\/td>\r\n\t\t<\/tr>\t\r\n<%\r\n    }\r\n}\r\ncatch(Exception ex){\r\n\tout.println(ex.toString());\r\n}finally{\r\n\tif(rs != null) try{rs.close();}catch(SQLException ex){}           \r\n\tif(pstmt != null) try{pstmt.close();}catch(SQLException ex){}   \r\n\tif(connection != null) try{connection.close();}catch(SQLException ex){}\r\n}\r\n\r\n%>\r\n\r\n<\/table>\r\n\r\n<\/body> \r\n<\/html><\/pre>\n
\"\"<\/a><\/p>\n
jsp paramerer<\/p>\n
<%@ page language=\"java\" contentType=\"text\/html; charset=UTF-8\" pageEncoding=\"UTF-8\"%>\r\n<%@ page import = \"java.sql.DriverManager\" %>\r\n<%@ page import = \"java.sql.Connection\" %>\r\n<%@ page import = \"java.sql.PreparedStatement\" %>\r\n<%@ page import = \"java.sql.ResultSet\" %>\r\n<%@ page import = \"java.sql.SQLException\" %>\r\n\r\n<%\r\nString connectionURL = \"jdbc:mysql:\/\/localhost:3306\/IBE?characterEncoding=UTF-8&serverTimezone=UTC\"; \r\n\r\nConnection connection = null; \r\nPreparedStatement pstmt = null;\r\nResultSet rs = null;\r\n\r\nString code = request.getParameter(\"code\"); \/\/Code\r\nif(code == null) code=\"\";\r\n\r\nString Decode = code;\r\n\r\ntry{\r\n\tif(code.length()==2){\r\n\t\tClass.forName(\"com.mysql.jdbc.Driver\").newInstance(); \r\n\t\tconnection = DriverManager.getConnection(connectionURL, \"user02\", \"user99\");\r\n\t    \r\n\t    String query =\"SELECT \ufeffairline_code,airline_korean FROM IBE.Airlines where \ufeffairline_code = ? LIMIT 0, 1\";\r\n\t    \r\n\t    pstmt = connection.prepareStatement(query); \r\n\t    pstmt.setString(1,code);\r\n\t       \t\t\r\n\t    rs = pstmt.executeQuery();\r\n\t    \r\n\t\t    while(rs.next()){\r\n\t\t    \tDecode = rs.getString(\"airline_korean\");\r\n\t\t    }\r\n\t   \r\n\t\t    out.println(Decode);\r\n\t   \r\n    }else\t\r\n    \tout.println(code);\r\n\t\r\n}\r\ncatch(Exception ex){\r\n\tout.println(ex.toString());\r\n}finally{\r\n\tif(rs != null) try{rs.close();}catch(SQLException ex){}           \r\n\tif(pstmt != null) try{pstmt.close();}catch(SQLException ex){}   \r\n\tif(connection != null) try{connection.close();}catch(SQLException ex){}\r\n}\r\n%>\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"
JAVA package javaDB; import java.sql.*; import com.microsoft.sqlserver.jdbc.*; public class test { public static void main(String[] args) { \/\/ Declare the JDBC objects. Connection con = null; CallableStatement cstmt = null; ResultSet rs = null; try { \/\/ Establish the connection. SQLServerDataSource ds = new SQLServerDataSource(); \/\/ds.setIntegratedSecurity(true); ds.setServerName(“localhost”); ds.setPortNumber(1433); ds.setDatabaseName(“WSP_IBE”); ds.setUser(“user01”); ds.setPassword(“password01”); con = ds.getConnection(); \/\/\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[82],"tags":[],"class_list":["post-459","post","type-post","status-publish","format-standard","hentry","category-java"],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/csharp.ihavenomoney.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/459","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/csharp.ihavenomoney.co.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/csharp.ihavenomoney.co.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/csharp.ihavenomoney.co.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/csharp.ihavenomoney.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=459"}],"version-history":[{"count":10,"href":"https:\/\/csharp.ihavenomoney.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/459\/revisions"}],"predecessor-version":[{"id":791,"href":"https:\/\/csharp.ihavenomoney.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/459\/revisions\/791"}],"wp:attachment":[{"href":"https:\/\/csharp.ihavenomoney.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=459"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/csharp.ihavenomoney.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=459"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/csharp.ihavenomoney.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=459"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}