總框架：

SQL部分：

create table yonghu(

? yh_ID int primary key identity(1,1),

? yh_Uname varchar(30) not null,

? yh_Pwd varchar(30) not null,

? yh_Name varchar(30) not null,

? yh_Age int,

? yh_Sex varchar(20),

? yh_Phone varchar(100),

? yh_Address varchar(200),

? yh_Jieshao varchar(500),

? ?yh_Q varchar(500),

? ? yh_AQ varchar(500)

);

insert into yonghu values('1','11','詩書畫唱1',21,'男','19999999999','江西','陽光帥氣的男孩子','你愛好多嗎？','多');

insert into yonghu values('2','22','詩書畫唱2',22,'男','29999999999','北京','陽光帥氣的男孩子','你看過的書多嗎？','多');

insert into yonghu values('3','33','詩書畫唱3',23,'男','39999999999','上海','陽光帥氣的男孩子','你會的技能多嗎？','多');

insert into yonghu values('4','44','詩書畫唱4',24,'男','49999999999','湖南','陽光帥氣的男孩子','你喜歡的動漫嗎？','多');

insert into yonghu values('5','55','詩書畫唱5',25,'男','59999999999','浙江','陽光帥氣的男孩子','你喜歡的歌曲多嗎？','多');

create table ts_Type(

ts_TypeID int primary key identity(1,1),

ts_TypeName varchar(100) not null

);

insert into ts_Type values('奇幻');

insert into ts_Type values('愛情');

insert into ts_Type values('日常');

insert into ts_Type values('科普');

create table tushu(

? ts_ID int primary key identity(1,1),

? ts_Name varchar(100) not null,

? ts_Price decimal(10,2) not null,

? ts_TypeID int,

? ts_Jieshao varchar(300)

);

insert into tushu values('《奧秘》',12,1,'好');

insert into tushu values('《愛你》',2,2,'good');

insert into tushu values('《詩書》',4,1,'棒');

insert into tushu values('《科普》',3,2,'強');

drop table yonghu, tushu,dingdanxiangqing,ts_Type

drop table tushu

select * from yonghu;

select * from tushu;

select * from ts_Type;

drop table dingdan

create table dingdan(

? dingdan_ID int primary key identity(1,1),

? yh_ID int,

? dingdanxiangqing_ID int

)

insert into dingdan values(1,1);

insert into dingdan values(1,2);

insert into dingdan values(1,3);

insert into dingdan values(2,4);

insert into dingdan values(2,5);

insert into dingdan values(2,6);

insert into dingdan values(3,7);

create table dingdanxiangqing(

? dingdanxiangqing_ID int primary key identity(1,1),

? sp_ID int,

? sp_num int

)

insert into dingdanxiangqing values(1,3);

insert into dingdanxiangqing values(2,4);

insert into dingdanxiangqing values(1,5);

insert into dingdanxiangqing values(3,5);

insert into dingdanxiangqing values(4,2);

insert into dingdanxiangqing values(5,1);

insert into dingdanxiangqing values(3,3);

insert into dingdanxiangqing values(4,3);

select * from yonghu;

select * from shangpin;

select * from sp_Type;

本篇框架：

package denglu;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.ArrayList;

import javax.swing.ButtonGroup;

import javax.swing.JButton;

import javax.swing.JCheckBox;

import javax.swing.JComboBox;

import javax.swing.JFrame;

import javax.swing.JLabel;

import javax.swing.JOptionPane;

import javax.swing.JPasswordField;

import javax.swing.JRadioButton;

import javax.swing.JTextArea;

import javax.swing.JTextField;

class shijian_zhuce implements ActionListener {

public static zhuCe chuangkouneirong2 = null;

public shijian_zhuce(zhuCe shangPinLeiXingXiaLaKuang1) {

this.chuangkouneirong2 = shangPinLeiXingXiaLaKuang1;

// chuangkouneirong窗口內(nèi)容

}

@Override

public void actionPerformed(ActionEvent arg0) {

JOptionPane.showMessageDialog(null, "點擊了注冊按鈕");

String String_uname = chuangkouneirong2.JTextField_uname.getText();// 得到用戶名

String String_pwd = chuangkouneirong2.JPasswordField_pwd1.getText();// 得到密碼

String String_pwd1 = chuangkouneirong2.JPasswordField_pwd2.getText();// 得到確認密碼

String String_TureName = chuangkouneirong2.JTextField_name.getText();// 得到用戶名

String String_age = chuangkouneirong2.JComboBox_age.getSelectedItem()

.toString();

// String String_age = zc.JTextField_age.getText();// 得到年齡

String String_sex = "男";

// 判斷用戶是否選擇是女:

if (chuangkouneirong2.rb2.isSelected()) {

String_sex = "女";

}

String String_phone = chuangkouneirong2.JTextField_phone.getText();// 得到電話號碼

// String String_address = zc.JTextField_address.getText();// 得到地址

ArrayList<String> jiHe = new ArrayList<String>();

// jiHe集合

if (chuangkouneirong2.address1.isSelected()) {

jiHe.add(chuangkouneirong2.address1.getText());

}

if (chuangkouneirong2.address2.isSelected()) {

jiHe.add(chuangkouneirong2.address2.getText());

}

if (chuangkouneirong2.address3.isSelected()) {

jiHe.add(chuangkouneirong2.address3.getText());

}

String String_address = " ";

for (int i = 0; i < jiHe.size(); i++) {

String_address += jiHe.get(i) + " ";// 將集合中的內(nèi)容轉(zhuǎn)換為字符串

}

String String_jieshao = chuangkouneirong2.JTextArea_jieshao.getText();// 得到介紹

String String_Q = chuangkouneirong2.JTextField_Q.getText();// 得到問題

String String_A = chuangkouneirong2.JTextField_A.getText();// 得到答案

// 判斷兩次輸入的秘密是否一致:

if (!String_pwd.equals(String_pwd1)) {

JOptionPane.showMessageDialog(null, "兩次密碼輸入不一致， 請重新輸入");

return;

}

String sql_panduanuname = "select * from yonghu where yh_uname='"

+ String_uname + "'";

ResultSet res_select_uname = DBUtils.Select(sql_panduanuname);

try {

if (res_select_uname.next()) {

JOptionPane.showMessageDialog(null, "用戶名已經(jīng)存在了，請重新輸入");

return;

}

} catch (SQLException e) {

e.printStackTrace();

}

String sql = "insert into yonghu(yh_uname,yh_pwd,yh_Name"

+ ",yh_age,yh_sex,yh_phone,yh_address"

+ ",yh_jieshao,yh_Q,yh_A,yh_type) values('" + String_uname

+ "','"

+ String_pwd + "','"

+ String_TureName + "'," + String_age + ",'" + String_sex

+ "','" + String_phone + "','" + String_address + "','"

+ String_jieshao + "','" + String_Q + "','" + String_A + "'"

+ ",'普通用戶')";

if (DBUtils.ZSG(sql)) {

JOptionPane.showMessageDialog(null, "注冊成功");

} else {

JOptionPane.showMessageDialog(null, "出現(xiàn)了未知的錯誤，請重試");

}

}

}

public class zhuCe extends JFrame {

// 愛好使用復(fù)選框來做

static JCheckBox address1, address2, address3 = null;

public static JButton JButton_zhuce = null;

// 使用下拉框來當(dāng)年齡

static JComboBox JComboBox_age = null;

public static JPasswordField JPasswordField_pwd1,

JPasswordField_pwd2 = null;

// public static JTextArea jta_adress, jta_jieshao = null;

/* JTextArea類是一 個顯示純文本的多行(DuoHang)區(qū)域。 */

static JTextArea JTextArea_jieshao = null;

public static JTextField JTextField_uname, JTextField_name,

JTextField_phone, JTextField_jieshao, JTextField_Q,

JTextField_A = null;

public static JLabel lb_uname, lb_pwd, lb_qrpwd, lb_name, lb_age, lb_sex,

lb_phone, lb_address, lb_jieshao, lb_Q, lb_A = null;

// 性別使用JRadioButton來做

static JRadioButton rb1, rb2 = null;

public zhuCe() {

this.setLayout(null);

this.setSize(600, 700);

this.setTitle("注冊界面（只有普通用戶才要注冊）");

this.setLocationRelativeTo(null);

lb_uname = new JLabel("用戶名");

lb_pwd = new JLabel("用戶密碼");

lb_qrpwd = new JLabel("確認密碼");

lb_name = new JLabel("真實姓名");

lb_age = new JLabel("年齡");

lb_sex = new JLabel("性別");

lb_phone = new JLabel("電話");

lb_address = new JLabel("地址");

lb_jieshao = new JLabel("介紹");

lb_Q = new JLabel("問題");

lb_A = new JLabel("答案");

lb_uname.setBounds(80, 100, 70, 30);

lb_pwd.setBounds(80, 140, 70, 30);

lb_qrpwd.setBounds(80, 180, 70, 30);

lb_name.setBounds(80, 220, 70, 30);

lb_age.setBounds(80, 260, 70, 30);

lb_sex.setBounds(80, 300, 70, 30);

lb_phone.setBounds(80, 340, 70, 30);

lb_address.setBounds(80, 380, 70, 30);

lb_jieshao.setBounds(80, 420, 70, 30);

lb_Q.setBounds(80, 460, 70, 30);

lb_A.setBounds(80, 500, 70, 30);

this.add(lb_uname);

this.add(lb_pwd);

this.add(lb_qrpwd);

this.add(lb_name);

this.add(lb_age);

this.add(lb_sex);

this.add(lb_phone);

this.add(lb_address);

this.add(lb_jieshao);

this.add(lb_Q);

this.add(lb_A);

JTextField_uname = new JTextField();

JPasswordField_pwd1 = new JPasswordField();

JPasswordField_pwd2 = new JPasswordField();

JTextField_name = new JTextField();

rb1 = new JRadioButton("男", true);

rb2 = new JRadioButton("女");

this.add(rb1);

this.add(rb2);

JComboBox_age = new JComboBox();

ButtonGroup bg = new ButtonGroup();

bg.add(rb1);

bg.add(rb2);

for (int i = 18; i < 60; i++) {

JComboBox_age.addItem(i);

}

this.add(JComboBox_age);

// JTextField_age = new JTextField();

// JTextField_sex = new JTextField();

JTextField_phone = new JTextField();

// JTextField_address = new JTextField();

address1 = new JCheckBox("中國", true);

address2 = new JCheckBox("日本");

address3 = new JCheckBox("美國");

JTextField_Q = new JTextField();

JTextField_A = new JTextField();

JTextArea_jieshao = new JTextArea();

JTextArea_jieshao.setColumns(8);

JTextArea_jieshao.setRows(4);

JTextArea_jieshao.setLineWrap(true);

this.add(JTextArea_jieshao);

JTextField_uname.setBounds(160, 100, 140, 30);

JPasswordField_pwd1.setBounds(160, 140, 140, 30);

JPasswordField_pwd2.setBounds(160, 180, 140, 30);

JTextField_name.setBounds(160, 220, 140, 30);

// JTextField_age.setBounds(160, 260, 140, 30);

JComboBox_age.setBounds(160, 260, 140, 30);

// JTextField_sex.setBounds(160, 300, 140, 30);

rb1.setBounds(160, 300, 40, 30);

rb2.setBounds(200, 300, 40, 30);

JTextField_phone.setBounds(160, 340, 140, 30);

// JTextField_address.setBounds(160, 380, 140, 30);

address1.setBounds(160, 380, 80, 30);

address2.setBounds(240, 380, 70, 30);

address3.setBounds(320, 380, 70, 30);

JTextArea_jieshao.setBounds(160, 420, 140, 40);

JTextField_Q.setBounds(160, 460, 140, 30);

JTextField_A.setBounds(160, 500, 140, 30);

this.setLocationRelativeTo(null);

this.add(JTextField_uname);

this.add(JPasswordField_pwd1);

this.add(JPasswordField_pwd2);

this.add(JTextField_name);

// this.add(JTextField_age);

// this.add(JTextField_sex);

this.add(JTextField_phone);

// this.add(JTextField_address);

this.add(JTextField_Q);

this.add(JTextField_A);

this.add(address1);

this.add(address2);

this.add(address3);

JButton_zhuce = new JButton("確認注冊");

JButton_zhuce.addActionListener(new shijian_zhuce(this));

JButton_zhuce.setBounds(100, 580, 120, 30);

this.add(JButton_zhuce);

// this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

this.setVisible(true);

}

}

部分效果展示：

鼠標(biāo)左鍵雙擊選中的那一行后：

鼠標(biāo)右鍵：