프로그래밍(32)
-
html에서 부서코드를 입력받아 Mysql 실행
부서코드 입력부서코드 : html문을 작성
2016.09.06 -
mysql 연동하기
pageEncoding="UTF-8" import="java.sql.*" %> String driver="com.mysql.jdbc.Driver"; String url="jdbc:mysql://127.0.0.1:3306/test?useSSL=true"; try{ Class.forName(driver); Connection conn = DriverManager.getConnection(url,"root","mysql"); if (conn != null){ out.println("연결 성공"); conn.close(); } else out.println("연결 실패"); conn.close(); } catch(Excepti..
2016.09.06 -
은행계좌 Mysql 연동 (입금)
public static void depositAcc(){try {System.out.println("계좌번호를 입력하세요 : ");Scanner sc = new Scanner(System.in);String accNumber = sc.nextLine();System.out.println("입금할 금액을 입력하세요: ");int money = sc.nextInt();Connection con = null;con = DriverManager.getConnection("jdbc:mysql://localhost","root","mysql");java.sql.Statement st = null;ResultSet rs = null;st = con.createStatement();rs = st.executeQuer..
2016.09.05 -
은행계좌 Mysql 연동 (계좌 생성+조회)
import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.util.ArrayList;import java.util.Scanner; public class BankAccounts {public static void main(String[] args) {boolean loop = true;while(loop){System.out.println("------------------------------------------------");System.out.println("1.계좌 생성| 2. 계좌 조회 | 3. 입금 | 4.출금 | 5. 종료");..
2016.09.05 -
은행 계좌 예제(list 사용) 수정완료
import java.util.ArrayList;import java.util.Scanner; public class BankAccounts extends BankList {public static void main(String[] args) {boolean loop = true;while(loop){System.out.println("------------------------------------------------");System.out.println("1.계좌 생성| 2. 계좌 조회 | 3. 입금 | 4.출금 | 5. 종료");System.out.println("------------------------------------------------");System.out.println("선택 :..
2016.09.01 -
피보나치 수열 합산!
import java.io.IOException; @WebServlet("/Fibonacci")public class Fibonacci extends HttpServlet {private static final long serialVersionUID = 1L;BigInteger[] arr = new BigInteger[100];public void init() throws ServletException {arr[0] = new BigInteger("1");arr[1] = new BigInteger("1");for (int i = 2; i < arr.length; i++) {arr[i] = arr[i-1].add(arr[i-2]);}}protected void doGet(HttpServletRequest ..
2016.09.01