Mysql java를 이용하여 값 입력

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.SQLException;

import java.util.Scanner;

public class InsertStudentTest {

public static void main(String[] args) {

String url = "jdbc:mysql://127.0.0.1:3306/sds";

String user = "root";

String password = "mysql";

Connection connection = null;

try {

Class.forName("com.mysql.jdbc.Driver");

connection = DriverManager.getConnection(url, user, password);

} catch (ClassNotFoundException e) {

} catch (SQLException e) {

}

Scanner scan = new Scanner(System.in);

System.out.println("학번을 입력");

int num = scan.nextInt();

scan.nextLine();

System.out.println("이름을 입력");

String name = scan.nextLine();

System.out.println("나이를 입력");

int age = scan.nextInt();

System.out.println("점수를 입력");

int score = scan.nextInt();

PreparedStatement pstmt = null;

try {

pstmt = connection.prepareStatement("insert into student values(?,?,?,?)");

pstmt.setInt(1, num);

pstmt.setString(2, name);

pstmt.setInt(3, age);

pstmt.setInt(4, score);

int result = pstmt.executeUpdate();

if (result > 0)

System.out.println("삽입 성공");

else

System.out.println("삽입 실패");

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

} finally {

if (pstmt != null)

try {

pstmt.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

}

}