###実現したいこと
javaとMysqlをつなげたい
###発生している問題・エラーメッセージ
エラーメッセージ java.lang.NullPointerException ###該当のソースコード import java.awt.EventQueue; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.applet.Applet; import java.awt.*; import java.awt.event.*; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import javax.swing.*; import javax.swing.border.EmptyBorder; import javax.swing.JLabel; import javax.swing.JTextField; import javax.swing.JRadioButton; import javax.swing.JButton; public class Tuika extends JFrame implements ActionListener { int atai=0; static Connection connect =null; static java.sql.Statement stmt =null; static ResultSet relt=null; static String oi; /** * */ private static final long serialVersionUID = 1L; private JPanel contentPane; private JTextField textField; private JTextField textField_1; private JTextField textField_2; private JTextField textField_3; private JTextField textField_4; private JTextField textField_5; private JTextField textField_6; private JTextField textField_7; DefaultComboBoxModel model; JButton button = new JButton("\u767B\u9332"); JButton button_1 = new JButton("\u623B\u308B"); public static void main(String[] args) { EventQueue.invokeLater(new Runnable() { public void run() { try { Tuika frame = new Tuika(); frame.setVisible(true); } catch (Exception e) { e.printStackTrace(); } } }); } public Tuika() { try{ Class.forName("com.mysql.jdbc.Driver"); stmt= connect.createStatement(); connect =DriverManager.getConnection("jdbc:mysql://localhost/data","root","root"); System.out.println("接続成功"); } catch(Exception e){ System.out.println("データがありません"+e); } setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); setBounds(100, 100, 600, 400); contentPane = new JPanel(); contentPane.setBorder(new EmptyBorder(5, 5, 5, 5)); setContentPane(contentPane); contentPane.setLayout(null); JLabel label = new JLabel("\u82D7\u5B57"); label.setBounds(89, 56, 39, 38); contentPane.add(label); textField = new JTextField(); textField.setBounds(164, 148, 229, 19); contentPane.add(textField); textField.setColumns(10); JLabel label_1 = new JLabel("\u30DF\u30E7\u30A6\u30B8"); label_1.setBounds(89, 128, 50, 13); contentPane.add(label_1); textField_1 = new JTextField(); textField_1.setBounds(164, 66, 229, 19); contentPane.add(textField_1); textField_1.setColumns(10); JLabel label_2 = new JLabel("\u540D\u524D"); label_2.setBounds(89, 91, 50, 13); contentPane.add(label_2); JLabel lblNewLabel = new JLabel("\u30CA\u30DE\u30A8\u3000"); lblNewLabel.setBounds(89, 151, 50, 13); contentPane.add(lblNewLabel); textField_2 = new JTextField(); textField_2.setBounds(164, 125, 229, 19); contentPane.add(textField_2); textField_2.setColumns(10); textField_3 = new JTextField(); textField_3.setBounds(164, 88, 229, 19); contentPane.add(textField_3); textField_3.setColumns(10); JLabel label_3 = new JLabel("\u751F\u5E74\u6708\u65E5"); label_3.setBounds(22, 217, 66, 13); contentPane.add(label_3); textField_4 = new JTextField(); textField_4.setBounds(100, 214, 96, 19); contentPane.add(textField_4); textField_4.setColumns(10); JLabel label_4 = new JLabel("\u5E74"); label_4.setBounds(208, 217, 50, 13); contentPane.add(label_4); JLabel lblNewLabel_1 = new JLabel("\u6708"); lblNewLabel_1.setBounds(343, 217, 50, 13); contentPane.add(lblNewLabel_1); textField_5 = new JTextField(); textField_5.setBounds(235, 214, 96, 19); contentPane.add(textField_5); textField_5.setColumns(10); textField_6 = new JTextField(); textField_6.setBounds(361, 214, 96, 19); contentPane.add(textField_6); textField_6.setColumns(10); JLabel label_5 = new JLabel("\u65E5"); label_5.setBounds(469, 217, 50, 13); contentPane.add(label_5); button.setBounds(147, 297, 91, 21); contentPane.add(button); button_1.setBounds(355, 297, 91, 21); contentPane.add(button_1); JLabel lblid = new JLabel("\u767B\u9332ID"); lblid.setBounds(89, 21, 50, 13); contentPane.add(lblid); textField_7 = new JTextField(); textField_7.setBounds(164, 18, 229, 19); contentPane.add(textField_7); textField_7.setColumns(10); JLabel label_6 = new JLabel("\u534A\u89D2\u6570\u5B57\uFF16\u6841"); label_6.setBounds(416, 21, 82, 13); contentPane.add(label_6); button.addActionListener(this); button_1.addActionListener(this); getContentPane().add(button); getContentPane().add(button_1); String[] combodata = { "男", "女"}; model = new DefaultComboBoxModel(combodata); JComboBox comboBox = new JComboBox(model); comboBox.setBounds(164, 185, 74, 19); contentPane.add(comboBox); } public void actionPerformed(ActionEvent ae){ try{ String text7=textField_7.getText(); String text3=textField_3.getText(); String text2=textField_2.getText(); String text1=textField_1.getText(); String text=textField.getText(); String text8=(String)model.getSelectedItem(); String text6=textField_6.getText(); String text5=textField_5.getText(); String text4=textField_4.getText(); text4=""+text4+""+text5+""+text6+""; if(ae.getSource()==button){ stmt= connect.createStatement(); stmt.executeUpdate("insert into main values("+text7+",'"+text8+"',"+text4+",0,0,0"); stmt.executeUpdate("insert into name values("+text7+",'"+text3+"','"+text1+"','"+text+"','"+text2+"'"); Frame2 next=new Frame2(text4); next.setVisible(true); setVisible(false); } else if(ae.getSource()==button_1){Frame2 next=new Frame2(text7); next.setVisible(true); setVisible(false);} }catch(Exception e){ e.printStackTrace(); } } private String integerParsInt(String text4) { // TODO 自動生成されたメソッド・スタブ return null; } } ###試したこと 接続するプログラムだけでの接続は確認しました ###補足情報(言語/FW/ツール等のバージョンなど) 言語 java ツール エクリプス
バッドをするには、ログインかつ
こちらの条件を満たす必要があります。
2017/07/05 04:41
2017/07/05 04:46
2017/07/05 04:49
2017/07/05 05:16
2017/07/05 05:28
2017/07/05 05:39
2017/07/05 05:41
2017/07/05 05:44
2017/07/05 05:55
2017/07/05 07:53
2017/07/06 02:39