package br.com.caelum.financas.teste;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;

import javax.swing.JOptionPane;

public class TesteInsereConta {
	public static void main(String[] args) throws SQLException {

		String banco = JOptionPane.showInputDialog("Digite o banco:");
		String agencia = JOptionPane.showInputDialog("Digite a agência:");
		String numero = JOptionPane.showInputDialog("Digite o número:");
		String titular = JOptionPane.showInputDialog("Digite o titular:");

		String sql = "insert into Conta (banco, agencia, numero, titular) values (?,?,?,?)";
		Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/fj25", "root", "");
		PreparedStatement stmt = con.prepareStatement(sql);
		stmt.setString(1, banco);
		stmt.setString(2, agencia);
		stmt.setString(3, numero);
		stmt.setString(4, titular);
		stmt.execute();
		stmt.close();
	}
}