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 객체의 초기화가 필요하다.
1
2
3
4
5
6
7
8
9
10
11
12
13
{"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#