|
1 2 3 4 5 6 7 8 9 10 11 12 |
LINQ to entities query // Descending SearchFareInfoList = SearchFareInfoList.OrderByDescending(o => o.NoShowFee).ToList(); // Contain : True False SegmentOrder = AirSegmentData.Select(o => o.Key).Contains(SegmentRef).ToString(); // 있으면 값 가져오기 if (AirSegmentData.Select(s => s.Key).Contains(SegmentRef).ToString() == "True") SegmentOrder = AirSegmentData.Single(s => s.Key == SegmentRef).SegmentOrder; |
JAVA
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 |
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(); // Execute a stored procedure that returns some data. cstmt = con.prepareCall("{call dbo.uspGetAircraft()}"); //cstmt.setInt(1, 50); rs = cstmt.executeQuery(); // Iterate through the data in the result set and display it. while (rs.next()) { System.out.println("aircraft_code: " + rs.getString("aircraft_code")); System.out.println("aircraft_english: " + rs.getString("aircraft_english")); System.out.println(); } } // Handle any errors that may have occurred. catch (Exception e) { e.printStackTrace(); } finally { if (rs != null) try { rs.close(); } catch(Exception e) {} if (cstmt != null) try { cstmt.close(); } catch(Exception e) {} if (con != null) try { con.close(); } catch(Exception e) {} } } } |
JSP mysql
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 |
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%@ page import="java.sql.*" %> <html> <head> <title>Connection with mysql database</title> </head> <body> <h1>Connection status </h1> <table> <% String connectionURL = "jdbc:mysql://localhost:3306/IBE?characterEncoding=UTF-8&serverTimezone=UTC"; Connection connection = null; PreparedStatement pstmt = null; ResultSet rs = null; try{ Class.forName("com.mysql.jdbc.Driver").newInstance(); connection = DriverManager.getConnection(connectionURL, "user02", "user99"); String query ="SELECT airline_code,airline_korean FROM IBE.Airlines where airline_code = ?"; //String query ="SELECT airline_code,airline_korean FROM IBE.Airlines"; pstmt = connection.prepareStatement(query); pstmt.setString(1,"OZ"); rs = pstmt.executeQuery(); while(rs.next()){ String airline_code = rs.getString("airline_code"); String airline_korean = rs.getString("airline_korean"); %> <tr> <td width="100"><%=airline_code%></td> <td width="100"><%=airline_korean%></td> </tr> <% } } catch(Exception ex){ out.println(ex.toString()); }finally{ if(rs != null) try{rs.close();}catch(SQLException ex){} if(pstmt != null) try{pstmt.close();}catch(SQLException ex){} if(connection != null) try{connection.close();}catch(SQLException ex){} } %> </table> </body> </html> |
jsp paramerer
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 |
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%@ page import = "java.sql.DriverManager" %> <%@ page import = "java.sql.Connection" %> <%@ page import = "java.sql.PreparedStatement" %> <%@ page import = "java.sql.ResultSet" %> <%@ page import = "java.sql.SQLException" %> <% String connectionURL = "jdbc:mysql://localhost:3306/IBE?characterEncoding=UTF-8&serverTimezone=UTC"; Connection connection = null; PreparedStatement pstmt = null; ResultSet rs = null; String code = request.getParameter("code"); //Code if(code == null) code=""; String Decode = code; try{ if(code.length()==2){ Class.forName("com.mysql.jdbc.Driver").newInstance(); connection = DriverManager.getConnection(connectionURL, "user02", "user99"); String query ="SELECT airline_code,airline_korean FROM IBE.Airlines where airline_code = ? LIMIT 0, 1"; pstmt = connection.prepareStatement(query); pstmt.setString(1,code); rs = pstmt.executeQuery(); while(rs.next()){ Decode = rs.getString("airline_korean"); } out.println(Decode); }else out.println(code); } catch(Exception ex){ out.println(ex.toString()); }finally{ if(rs != null) try{rs.close();}catch(SQLException ex){} if(pstmt != null) try{pstmt.close();}catch(SQLException ex){} if(connection != null) try{connection.close();}catch(SQLException ex){} } %> |
추천 : ToUniversalTime
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 |
using System.Linq; using System.Text; using System.Collections.ObjectModel; namespace ConsoleTime { class Program { static void Main(string[] args) { DateTime thisDate = new DateTime(2007, 3, 10, 0, 0, 0); DateTime dstDate = new DateTime(2007, 6, 10, 0, 0, 0); DateTimeOffset thisTime; thisTime = new DateTimeOffset(dstDate, new TimeSpan(-7, 0, 0)); ShowPossibleTimeZones(thisTime); thisTime = new DateTimeOffset(thisDate, new TimeSpan(-6, 0, 0)); ShowPossibleTimeZones(thisTime); thisTime = new DateTimeOffset(thisDate, new TimeSpan(+1, 0, 0)); ShowPossibleTimeZones(thisTime); Console.ReadLine(); } private static void ShowPossibleTimeZones(DateTimeOffset offsetTime) { TimeSpan offset = offsetTime.Offset; ReadOnlyCollection<TimeZoneInfo> timeZones; Console.WriteLine("{0} could belong to the following time zones:", offsetTime.ToString()); // Get all time zones defined on local system timeZones = TimeZoneInfo.GetSystemTimeZones(); // Iterate time zones foreach (TimeZoneInfo timeZone in timeZones) { // Compare offset with offset for that date in that time zone if (timeZone.GetUtcOffset(offsetTime.DateTime).Equals(offset)) Console.WriteLine(" {0}", timeZone.DisplayName); } Console.WriteLine(); } } } |
결과 참조 : https://stackoverflow.com/questions/1201378/how-does-datetime-touniversaltime-work
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 |
class DBData { static string connectionString = "server= 111.222.333.444;uid=id;pwd=pppp;database=UEUE"; public static string QueueHTML(string SID) { SqlConnection conn = new SqlConnection(connectionString); SqlDataAdapter da = new SqlDataAdapter(); DataSet QUEUE = new DataSet(); try { conn.Open(); SqlCommand cmd = conn.CreateCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "QueueList"; SqlParameter paramSID = cmd.Parameters.Add("@SID", SqlDbType.Char, 3); paramSID.Direction = ParameterDirection.Input; paramSID.Value = SID; da.SelectCommand = cmd; da.Fill(QUEUE, "QUEUE"); XslCompiledTransform xslt = new XslCompiledTransform(); StringWriter stringWriter = new StringWriter(); xslt.Load("Queue.xsl"); XsltArgumentList args = new XsltArgumentList(); XmlDocument xml = new XmlDocument(); string dbXML = QUEUE.GetXml(); xml.LoadXml(dbXML); xslt.Transform(xml, args, stringWriter); string Content = stringWriter.ToString(); return Content; } catch (Exception ex) { //클라이언트에게 예외를 던진다. //throw ex; string Err = ex.ToString(); return ""; } finally { } } } |
NuGet – MySqlConnector 설치 방법1. 포트연결은 : 아니고 , Insert 방법2. Asp.net Web.config Core 참조 : https://mysqlconnector.net/tutorials/connect-to-mysql/ Error : 원인 : MysqlBench 에서 나오는 쿼리에서 ‘(싱글쿼테이션)을 다 빼야지 된다. / C# 하고 java 의 문법적 차이
vs2010 기준 다운로드 : Omk02
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 |
package apples; import java.util.Scanner; public class apples { public static void main(String[] args) { Scanner input = new Scanner(System.in); tuna tunaObject = new tuna(); System.out.println("Enter your name here: "); String name = input.nextLine(); tunaObject.simpleMessage(name); } } //tuna.java package apples; public class tuna { public void simpleMessage(String name){ System.out.println("Hello "+ name); } } |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 |
package apples; public class apples { public static void main(String[] args) { tuna tunaObject = new tuna(); tunaObject.simpleMessage(); } } //tuna.java package apples; public class tuna { public void simpleMessage(){ System.out.println("This is another class"); } } |
https://nodejs.org/en/