public void

Vue\project\.prettierrc

'vue : 이 시스템에서 스크립트를 실행할 수 없으므로 ~' 라는 오류 발생시,

PowerShell 을 관리자 권한으로 실행 후,

Get-ExecutionPolicy 명령어로 권한 확인(Restricted)

Set-ExecutionPolicy  명령어로 권한 변경(RemoteSigned)

1. OpenJDK 8 설치

sudo apt install openjdk-8-jdk

2. JAVA_HOME 설정 및 적용

$ readlink -f $(which java)
/usr/lib/jvm/java-8-openjdk-amd64/jre/bin/java

$ sudo vi /etc/profile
export JAVA_HOME=/usr/lib/jvm/java-8-openjdk-amd64
export PATH=$PATH:$JAVA_HOME/bin

$ source /etc/profile

1. 아래의 URL로 접속하여 파일명 확인

https://dev.mysql.com/downloads/repo/apt/

2. wget 으로 다운로드

sudo wget https://dev.mysql.com/get/mysql-apt-config_0.8.12-1_all.deb

3. deb 설치

sudo dpkg -i mysql-apt-config_0.8.12-1_all.deb

# 1. Add repository to unsupported system?
>> ubuntu bionic

# 2. Which MySQL product do you wish to configure?
>> MySQL Server & Cluster

# 3. Which server version do you wish to receive?
>> mysql-5.7

# 4. Which MySQL product do you wish to configure?
>> Ok

4. 인증키 설치

sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys 467B942D3A79BD29
apt-get update

5. 확인

sudo apt update

sudo apt policy mysql-server

mysql-server:
  설치: 5.7.39-1ubuntu18.04
  후보: 8.0.30-0ubuntu0.22.04.1
  버전 테이블:
     8.0.30-0ubuntu0.22.04.1 500
        500 http://kr.archive.ubuntu.com/ubuntu jammy-updates/main amd64 Packages
        500 http://kr.archive.ubuntu.com/ubuntu jammy-updates/main i386 Packages
        500 http://security.ubuntu.com/ubuntu jammy-security/main amd64 Packages
        500 http://security.ubuntu.com/ubuntu jammy-security/main i386 Packages
     8.0.28-0ubuntu4 500
        500 http://kr.archive.ubuntu.com/ubuntu jammy/main amd64 Packages
        500 http://kr.archive.ubuntu.com/ubuntu jammy/main i386 Packages
 *** 5.7.39-1ubuntu18.04 500
        500 http://repo.mysql.com/apt/ubuntu bionic/mysql-5.7 amd64 Packages
        100 /var/lib/dpkg/status

6. 설치

sudo apt install -f mysql-client=5.7* mysql-community-server=5.7* mysql-server=5.7*

7. 보안

sudo mysql_secure_installation

8. 접속 및 버전 확인

mysql -uroot -p

select version();

1. 센서패키지 설치

sudo apt install lm-sensors

2. 설정

sudo sensors-detect

  이후, 엔터만 입력하여 기본값으로 설정

3. 온도 확인

watch sensors

echo options thinkpad_acpi dbg_bluetoothemul=1 bluetooth_state=1 | sudo tee -a /etc/modprobe.d/thinkpad_acpi.conf

리붓 후,

rfkill unblock all

public class ContentDao {

	private DataSource dataSource;

	public ContentDao() {
		try {
			Context context = new InitialContext();
			dataSource = (DataSource)context.lookup("java:comp/env/jdbc/Oracle11g");
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	
	public ArrayList<ContentDto> list() {
		ArrayList<ContentDto> ContentDtos = new ArrayList<ContentDto>();
		
		Connection conn = null;
		PreparedStatement pstmt = null;
		ResultSet rs = null;
		try {
			conn = dataSource.getConnection();
			String query = "SELECT * FROM TEST_BOARD";
			pstmt = conn.prepareStatement(query);
			rs = pstmt.executeQuery();
			while (rs.next()) {
				// ...
			}
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			try {
				if (rs != null) rs.close();
				if (pstmt != null) pstmt.close();
				if (conn != null) conn.close();
			} catch (Exception e2) {
				e2.printStackTrace();
			}
		}
		return ContentDtos;
	}	
}

위와 같이 찾을 수 없다는 오류가 나오면 JSTL을 다운로드하여 설치하면 된다.

다운로드 : https://tomcat.apache.org/taglibs.html

C:\Java\jre1.8.0_162\lib\ext 등과 같은 외부 라이브러리 폴더에 넣어주면 된다.

Connection connection;
Statement statement;
ResultSet resultSet;

String driver = "oracle.jdbc.driver.OracleDriver";
String url = "jdbc:oracle:thin:@localhost:1521:xe";
String uid = "publicvoid";
String upw = "privatevoid";
String query = "select * from void_members";

try {
	Class.forName(driver);
	connection = DriverManager.getConnection(url, uid, upw);
	statement = connection.createStatement();
	resultSet = statement.executeQuery(query);
	
	while (resultSet.next()) {
		String id = resultSet.getString("user_id");
		String pw = resultSet.getString("user_pw");
		String name = resultSet.getString("user_name");
		String mobile = resultSet.getString("user_mobile");
		out.println("아이디 : " + id + " / 패스워드 : " + pw + " / 이름 : " + name + " / 휴대전화 : " + mobile);
	}
} catch (Exception exception) {
	exception.printStackTrace();
} finally {
	try {
		if (resultSet != null) resultSet.close();
		if (statement != null) statement.close();
		if (connection != null) connection.close();
	} catch (Exception exception2) {
		exception2.printStackTrace();
	}
}