JDBC_Connect

import java.sql.*;
public class DBInsert {

	public static void main(String[] args) throws SQLException, ClassNotFoundException {
		Connection conn = null;
		Statement stmt;
		ResultSet rs = null;
		try {	
				String url = "jdbc:mysql://localhost:3306/store?c haracterEncoding=UTF-8&serverTimezone=Asia/Seoul";
				String user = "root";
				String password = "root";
				Class.forName("com.mysql.jdbc.Driver");
				conn = (Connection) DriverManager.getConnection(url, user, password);
				System.out.println("데이터베이스 연결이 성공했습니다.");
				
				stmt = conn.createStatement();
				String sql = "INSERT INTO customer(id, cName, Age, job, deposit) "
						+ "VALUES ('E','김학수','30', '목수',10000)";
				int i = stmt.executeUpdate(sql);
				if (i==1)
					System.out.println("레코드 추가 성공");
				else
					System.out.println("레코드 추가 실패");
		}catch(SQLException ex) {
			System.out.println("데이터베이스 연결이 실패했습니다.");
		} finally {
			if(conn != null)
				conn.close();
		}
	}

}