Tips

1. eclipse에서 java 자동완성 만들기

• Preferences -> Java -> Editor -> Templeates -> New
  
  <추가 코드1>
• db연동 시 select 사용코드
  • Name : db1
  • Description : SELECT

Connection con = null;
		PreparedStatement pstmt = null;
		ResultSet rs = null;
		String sql = null;
		try {
			con = pool.getConnection();
			sql = "";
			pstmt = con.prepareStatement(sql);
			rs = pstmt.executeQuery();
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			pool.freeConnection(con, pstmt, rs);
		}
		return ;

<추가 코드2>

• db연동 시 insert,update,delete 사용코드
  • Name : db2
  • Description : INSERT,UPDATE,DELETE

Connection con = null;
		PreparedStatement pstmt = null;
		String sql = null;
		boolean flag = false;
		try {
			con = pool.getConnection();
			sql = "${cursor}";
			pstmt = con.prepareStatement(sql);
			pstmt.executeUpdate();
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			pool.freeConnection(con, pstmt);
		}
		return flag;