2020-12-03-TIL

2020.12.03 TIL

Connect mysql to JDBC

https://hyeonstorage.tistory.com/110

https://allg.tistory.com/20

https://lottogame.tistory.com/3686

https://m.blog.naver.com/pjok1122/221727915740

https://butgrin.tistory.com/70

https://zetawiki.com/wiki/MySQL_%EC%84%A4%EC%A0%95%ED%8C%8C%EC%9D%BC_my.cnf

https://blog.naver.com/wizardkyn/220852348757

MySQL TImeZone problem

https://yenaworldblog.wordpress.com/2018/01/24/java-mysql-%EC%97%B0%EB%8F%99%EC%8B%9C-%EB%B0%9C%EC%83%9D%ED%95%98%EB%8A%94-%EC%97%90%EB%9F%AC-%EB%AA%A8%EC%9D%8C/

https://coloceum.tistory.com/entry/Mysql-timezone-%EB%B3%80%EA%B2%BD

https://devuna.tistory.com/47

java.sql.SQLException: Before start of result set

https://brocess.tistory.com/108

로그인 프로세스에서 ResultSet에 대한 null 체크과정과 로그인 시도할 때 마다 User Bean 객체의 초기화가 필요하다.

{"2020-11-11", "Food", "Pizza", "Seoul", 0, 8000, 0},
{"2020-11-24", "Beverage", "Coffee", "Seoul", 0, 5000, 0},
{"2020-11-30", "Public", "Mobile Phone fee", "Seoul", 0, 2000000, 0},
{"2020-11-30", "Financial", "Insurance premium", "Seoul", 0, 300000, 0},
{"2020-11-25", "Service", "Mac A/S", "Seoul", 0, 12000, 0},
{"2020-11-30", "Medical", "Dental care", "Dongtan", 0, 45000, 0},
{"2020-11-30", "Income", "Nov salary", "Seoul", 10000000, 0, 0},
{"2020-12-01", "Clothes", "A.P.C shirt", "Daegu", 0, 185000, 0},
{"2020-12-07", "Hobby", "Steam game", "Daegu", 0, 36000, 0},
{"2020-12-12", "Business", "Meeting expenses", "Busan", 0, 12000, 0},
{"2020-12-17", "Study", "Online study", "Daegu", 0, 330000, 0},
{"2020-12-24", "Vehicle", "Fuel", "Busan", 0, 60000, 0},
{"2020-12-24", "Etc", "Lost wallet", "Busan", 0, 100000, 0}

java.awt.IllegalComponentStateException: component must be showing on the screen to determine its location

INSERT INTO ledger (uid, date, method, type, item, description, location, credit, debit, balance) VALUES (1, ‘2020-11-25’, ‘Cash’, ‘Food’, ‘Tomato’, null, ‘Seoul’, 0, 5200, 0)

How to get selected row in JTable?

https://stackoverflow.com/questions/29345792/java-jtable-getting-the-data-of-the-selected-row

To get multiple selected rows in JTable

https://stackoverflow.com/questions/37795073/get-selected-rows-in-jtable/37795497

http://www.java2s.com/Code/JavaAPI/javax.swing/JTablegetSelectedRows.htm

java.sql.SQLEscption: Can not issue data manipulation statements with executequery()

SELECT를 제외한 나머지 쿼리문은 리턴값으로 int의 값을 반환하는 executeUpdate() 사용해야 한다.

How to hide column in JTable?

https://stackoverflow.com/questions/1492217/how-to-make-a-columns-in-jtable-invisible-for-swing-java/1493233

Java Calendar

https://dzone.com/articles/mig-calendar-v66-released#