牙医软件，增加用户

package b;

import java.awt.BorderLayout;
import java.awt.Component;
import java.awt.FlowLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.Vector;

import javax.swing.JButton;
import javax.swing.JDialog;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JTextArea;
import javax.swing.JTextField;
import javax.swing.SwingUtilities;
import javax.swing.table.DefaultTableModel;

public class UserInsert extends JDialog implements ActionListener {
	//
	JLabel jl_username = new JLabel("姓名", SwingUtilities.RIGHT);
	JTextField jtf_username = new JTextField(10);
	JLabel jl_gender = new JLabel("性别", SwingUtilities.RIGHT);
	JTextField jtf_gender = new JTextField(10);
	JLabel jl_birthday = new JLabel("出生日期", SwingUtilities.RIGHT);
	JTextField jtf_birthday = new JTextField(10);
	JLabel jl_mobile = new JLabel("手机", SwingUtilities.RIGHT);
	JTextField jtf_mobile = new JTextField(10);
	//
	JLabel jl_laiyuan = new JLabel("来源", SwingUtilities.RIGHT);
	JTextField jtf_laiyuan = new JTextField(10);
	JLabel jl_idcard = new JLabel("身份证号", SwingUtilities.RIGHT);
	JTextField jtf_idcard = new JTextField(10);
	JLabel jl_doctor = new JLabel("主治医生", SwingUtilities.RIGHT);
	JTextField jtf_doctor = new JTextField(10);
	JLabel jl_address = new JLabel("家庭住址", SwingUtilities.RIGHT);
	JTextField jtf_address = new JTextField(10);
	//
	JLabel jl_guominshi = new JLabel("过敏史", SwingUtilities.RIGHT);
	JTextField jtf_guominshi = new JTextField(10);
	JLabel jl_jiwangbingshi = new JLabel("既往病史", SwingUtilities.RIGHT);
	JTextField jtf_jiwangbingshi = new JTextField(10);
	JLabel jl_liuxingbingxueshi = new JLabel("流行病学史", SwingUtilities.RIGHT);
	JTextField jtf_liuxingbingxueshi = new JTextField(10);
	JLabel jl_jiuzhenjingli = new JLabel("就诊经历", SwingUtilities.RIGHT);
	JTextField jtf_jiuzhenjingli = new JTextField(10);
	JLabel jl_beizhu = new JLabel("备注", SwingUtilities.RIGHT);
	JTextArea jta_beizhu = new JTextArea();

	JButton jb = new JButton("保存");

	public UserInsert(boolean b) {

		jl_username.setBounds(0, 0, 200, 30);
		jtf_username.setBounds(200, 00, 200, 30);
		jl_gender.setBounds(400, 0, 200, 30);
		jtf_gender.setBounds(600, 00, 200, 30);
		jl_birthday.setBounds(800, 0, 200, 30);
		jtf_birthday.setBounds(1000, 00, 200, 30);
		jl_mobile.setBounds(1200, 0, 200, 30);
		jtf_mobile.setBounds(1400, 00, 200, 30);
		//
		jl_laiyuan.setBounds(0, 30, 200, 30);
		jtf_laiyuan.setBounds(200, 30, 200, 30);
		jl_idcard.setBounds(400, 30, 200, 30);
		jtf_idcard.setBounds(600, 30, 200, 30);
		jl_doctor.setBounds(800, 30, 200, 30);
		jtf_doctor.setBounds(1000, 30, 200, 30);
		jl_address.setBounds(1200, 30, 200, 30);
		jtf_address.setBounds(1400, 30, 200, 30);
		//
		jl_guominshi.setBounds(0, 60, 200, 30);
		jtf_guominshi.setBounds(200, 60, 200, 30);
		jl_jiwangbingshi.setBounds(400, 60, 200, 30);
		jtf_jiwangbingshi.setBounds(600, 60, 200, 30);
		jl_liuxingbingxueshi.setBounds(800, 60, 200, 30);
		jtf_liuxingbingxueshi.setBounds(1000, 60, 200, 30);
		jl_jiuzhenjingli.setBounds(1200, 60, 200, 30);
		jtf_jiuzhenjingli.setBounds(1400, 60, 200, 30);
		//
		jl_beizhu.setBounds(0, 90, 200, 30);
		jta_beizhu.setBounds(200, 90, 1400, 200);
		jb.setBounds(200, 300, 180, 50);
		jb.addActionListener(this);

		this.add(jl_username);
		this.add(jtf_username);
		this.add(jl_gender);
		this.add(jtf_gender);
		this.add(jl_birthday);
		this.add(jtf_birthday);
		this.add(jl_mobile);
		this.add(jtf_mobile);
		//
		this.add(jl_laiyuan);
		this.add(jtf_laiyuan);
		this.add(jl_idcard);
		this.add(jtf_idcard);
		this.add(jl_doctor);
		this.add(jtf_doctor);
		this.add(jl_address);
		this.add(jtf_address);
		//
		this.add(jl_guominshi);
		this.add(jtf_guominshi);
		this.add(jl_jiwangbingshi);
		this.add(jtf_jiwangbingshi);
		this.add(jl_liuxingbingxueshi);
		this.add(jtf_liuxingbingxueshi);
		this.add(jl_jiuzhenjingli);
		this.add(jtf_jiuzhenjingli);
		this.add(jl_beizhu);
		this.add(jta_beizhu);
		this.add(jb);

		this.setLayout(null);
		this.setModal(true);
		this.setSize(1900, 1000);

	}

	public void Insert() {
		try {
			Class.forName("org.sqlite.JDBC");
			try (Connection conn = DriverManager.getConnection("jdbc:sqlite:mydata.sqlite3")) {
				try (PreparedStatement ps = conn
						.prepareStatement("insert into t_user values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)")) {
					ps.setString(1, jtf_username.getText());
					ps.setString(2, jtf_gender.getText());
					ps.setString(3, jtf_birthday.getText());
					ps.setString(4, jtf_mobile.getText());
					ps.setString(5, jtf_laiyuan.getText());
					ps.setString(6, jtf_idcard.getText());
					ps.setString(7, jtf_doctor.getText());
					ps.setString(8, jtf_address.getText());
					ps.setString(9, jtf_guominshi.getText());
					ps.setString(10, jtf_jiwangbingshi.getText());
					ps.setString(11, jtf_liuxingbingxueshi.getText());
					ps.setString(12, jtf_jiuzhenjingli.getText());
					ps.setString(13, jta_beizhu.getText());
					int i = ps.executeUpdate();
					if (i < 1) {
						return;
					}

					DefaultTableModel dtm = new DefaultTableModel(Main.tableDataAll(), Main.columnNames());
					Main.jt.setModel(dtm);
					System.out.println("加入成功");
					int j = JOptionPane.showConfirmDialog(this, "添加完成，是否需要增加病历？", "选择一个选项",
							JOptionPane.YES_NO_CANCEL_OPTION);
					System.out.println(j);
					if (j != 0) {
						return;
					}


				}
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	public void actionPerformed(ActionEvent e) {
		String s = e.getActionCommand();
		if (s.equals("保存")) {
			this.Insert();
		}
	}

}