總框架：

本篇所含框架：

package denglu;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import java.awt.event.MouseEvent;

import java.awt.event.MouseListener;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.Vector;

import javax.swing.JButton;

import javax.swing.JComboBox;

import javax.swing.JFrame;

import javax.swing.JLabel;

import javax.swing.JOptionPane;

import javax.swing.JPanel;

import javax.swing.JScrollPane;

import javax.swing.JTable;

import javax.swing.JTextField;

import javax.swing.table.DefaultTableModel;

public class puTongYongHuJieMian extends JFrame {

class shijian_table implements MouseListener, ActionListener {

public puTongYongHuJieMian HanDengLuHouJieMianNeiRong = null;

public shijian_table(puTongYongHuJieMian dengLuHouJieMianNeiRong) {

this.HanDengLuHouJieMianNeiRong = dengLuHouJieMianNeiRong;

}

// HanDengLuHouJieMianNeiRong(含登錄后界面內容)

// DengLuHouJieMianNeiRong(登錄后界面內容)

// 把窗體等內容都賦值傳給HanDengLuHouJieMianNeiRong是為了方便下面如

// HanDengLuHouJieMianNeiRong.txt_name.getText();的“點(.)式引用,由“.”

// 后面的精確后綴條件提示等引用精確內容”

@Override

public void actionPerformed(ActionEvent arg0) {

String name = HanDengLuHouJieMianNeiRong.wenBenKuang_name.getText();

String price = HanDengLuHouJieMianNeiRong.wenBenKuang_price

.getText();

String type = HanDengLuHouJieMianNeiRong.wenBenKuang_typeid

.getText();

String jieshao = HanDengLuHouJieMianNeiRong.wenBenKuang_spjieshao

.getText();

// ArrayList jiHe = new ArrayList();

// // jiHe集合

//

// if (HanDengLuHouJieMianNeiRong.address1.isSelected()) {

// jiHe.add(HanDengLuHouJieMianNeiRong.address1.getText());

// }

// if (HanDengLuHouJieMianNeiRong.address2.isSelected()) {

// jiHe.add(HanDengLuHouJieMianNeiRong.address2.getText());

// }

// if (HanDengLuHouJieMianNeiRong.address3.isSelected()) {

// jiHe.add(HanDengLuHouJieMianNeiRong.address3.getText());

// }

// String typeName = HanDengLuHouJieMianNeiRong.xiaLaKuang

// .getSelectedItem().toString();

String sql = "insert into tushu values('" + name + "'" + ","

+ price + "," + type + ",'" + jieshao + "')";

// String sql2 = "insert into ts_type(ts_typename) values('"

// + typeName + "')";

// if (DBUtils.ZSG(sql) && DBUtils.ZSG(sql2)) {

if (DBUtils.ZSG(sql)) {

JOptionPane.showMessageDialog(null, "增加成功");

HanDengLuHouJieMianNeiRong.chaxunchushihua();

} else {

JOptionPane.showMessageDialog(null, "出現了未知的錯誤，增加失敗");

}

}

@Override

public void mouseClicked(MouseEvent arg0) {

if (arg0.getClickCount() == 2) {

int row = HanDengLuHouJieMianNeiRong.biaoGe1.getSelectedRow();

String leixing = HanDengLuHouJieMianNeiRong.biaoGe1.getValueAt(

row, 4).toString();

HanDengLuHouJieMianNeiRong.wenBenKuang_Bianhao

.setText(HanDengLuHouJieMianNeiRong.biaoGe1.getValueAt(

row, 0).toString());

HanDengLuHouJieMianNeiRong.wenBenKuang_name

.setText(HanDengLuHouJieMianNeiRong.biaoGe1.getValueAt(

row, 1).toString());

HanDengLuHouJieMianNeiRong.wenBenKuang_price

.setText(HanDengLuHouJieMianNeiRong.biaoGe1.getValueAt(

row, 2).toString());

HanDengLuHouJieMianNeiRong.wenBenKuang_typeid

.setText(HanDengLuHouJieMianNeiRong.biaoGe1.getValueAt(

row, 3).toString());

HanDengLuHouJieMianNeiRong.wenBenKuang_spjieshao

.setText(HanDengLuHouJieMianNeiRong.biaoGe1.getValueAt(

row, 5).toString());

HanDengLuHouJieMianNeiRong.wenBenKuang_typename

.setText(leixing);

// 給下拉框內容賦值:

for (int i = 0; i < HanDengLuHouJieMianNeiRong.xiaLaKuang

.getItemCount(); i++) {

if (HanDengLuHouJieMianNeiRong.xiaLaKuang.getItemAt(i)

.toString().equals(leixing)) {

HanDengLuHouJieMianNeiRong.xiaLaKuang

.setSelectedItem(leixing);

}

}

}

if (arg0.isMetaDown()) {

int num = JOptionPane.showConfirmDialog(null, "是否確認刪除這條信息?");

if (num == 0) {

int row = HanDengLuHouJieMianNeiRong.biaoGe1

.getSelectedRow();

String sql = "delete tushu where ts_id="

+ HanDengLuHouJieMianNeiRong.biaoGe1.getValueAt(

row, 0) + "";

if (DBUtils.ZSG(sql)) {

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

HanDengLuHouJieMianNeiRong.chaxunchushihua();

// 刪除成功再查詢一遍表格就可以實現表格的刷新，但是我們的查詢寫在了構造方法里,內容很多，

// 這里想要使用又要在寫一遍，很麻煩，那么現在我們寫一個方法 將查詢內容封裝進去，再想查詢的

// 時候只要調用查詢的方法即可

} else {

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

}

}

}

}

@Override

public void mouseEntered(MouseEvent arg0) {

// TODO Auto-generated method stub

}

@Override

public void mouseExited(MouseEvent arg0) {

// TODO Auto-generated method stub

}

@Override

public void mousePressed(MouseEvent arg0) {

// TODO Auto-generated method stub

}

@Override

public void mouseReleased(MouseEvent arg0) {

// TODO Auto-generated method stub

}

}

static JButton anNiu_zengJia = null;

// gunDongTiao(滾動條)

static JTable biaoGe1 = null;

// xiaLaKuang(下拉框)

static DefaultTableModel biaoGeMoXing1 = null;

// biaoGeMoXing1(表格模型1)

static JScrollPane gunDongTiao = null;

// 集合(jiHe)，標題(biaoti)

static Vector> Vector_jiHe_biaoGeNeiRong = null;

// wenBenKuang(文本框)

static Vector Vector_jiHe_biaoti = null;

// 文字(wenZi)

static JTextField wenBenKuang_Bianhao, wenBenKuang_name, wenBenKuang_price,

wenBenKuang_typeid, wenBenKuang_spjieshao, wenBenKuang_typename;

// biaoGe1(表格1)

static JLabel wenZi_Bianhao, wenZi_name, wenZi_price, wenZi_typeid,

wenZi_tjtypeName_xiaLaKuang, wenZi_spjieshao, wenZi_tjtypeName;

// anNiu_zengJia按鈕_增加

public static JComboBox xiaLaKuang = null;

// biaoGeNeiRong(表格內容)

JPanel mianBan1, mianBan2 = null;

// mianBan(面板)

public puTongYongHuJieMian() {

this.setTitle("普通用戶登錄后的界面");

this.setSize(800, 600);

this.setLayout(null);

this.setLocationRelativeTo(null);

wenZi_Bianhao = new JLabel("添加或查找編號");

wenZi_name = new JLabel("添加或查找名稱");

wenZi_price = new JLabel("添加或查找價格");

wenZi_tjtypeName = new JLabel("添加或查找類型名稱");

wenZi_tjtypeName_xiaLaKuang = new JLabel("查找類型名稱");

wenZi_typeid = new JLabel("添加或查找類型ID");

wenZi_spjieshao = new JLabel("添加或查找介紹");

anNiu_zengJia = new JButton("添加數據");

anNiu_zengJia.setBounds(530, 390, 100, 30);

anNiu_zengJia.addActionListener(new shijian_table(this));

this.add(anNiu_zengJia);

wenZi_Bianhao.setBounds(510, 100, 100, 30);

wenZi_name.setBounds(510, 140, 100, 30);

wenZi_price.setBounds(510, 180, 100, 30);

wenZi_typeid.setBounds(510, 220, 130, 30);

wenZi_spjieshao.setBounds(510, 260, 100, 30);

wenZi_tjtypeName.setBounds(510, 300, 170, 30);

wenZi_tjtypeName_xiaLaKuang.setBounds(510, 340, 170, 30);

this.add(wenZi_Bianhao);

this.add(wenZi_name);

this.add(wenZi_price);

this.add(wenZi_typeid);

this.add(wenZi_spjieshao);

this.add(wenZi_tjtypeName_xiaLaKuang);

this.add(wenZi_tjtypeName);

wenBenKuang_Bianhao = new JTextField();// 畫框框的界面

wenBenKuang_Bianhao.setEditable(false);

wenBenKuang_name = new JTextField();

wenBenKuang_price = new JTextField();

wenBenKuang_typeid = new JTextField();

wenBenKuang_spjieshao = new JTextField();

wenBenKuang_typename = new JTextField();

wenBenKuang_Bianhao.setBounds(640, 100, 130, 30);

wenBenKuang_name.setBounds(640, 140, 130, 30);

wenBenKuang_price.setBounds(640, 180, 130, 30);

wenBenKuang_typeid.setBounds(640, 220, 130, 30);

wenBenKuang_spjieshao.setBounds(640, 260, 130, 30);

wenBenKuang_typename.setBounds(640, 300, 130, 30);

this.add(wenBenKuang_Bianhao);

this.add(wenBenKuang_name);

this.add(wenBenKuang_price);

this.add(wenBenKuang_typeid);

this.add(wenBenKuang_spjieshao);

this.add(wenBenKuang_typename);

Vector_jiHe_biaoti = new Vector();

Vector_jiHe_biaoti.add("編號");

Vector_jiHe_biaoti.add("名稱");

Vector_jiHe_biaoti.add("價格");

Vector_jiHe_biaoti.add("類型ID");

Vector_jiHe_biaoti.add("類型名稱");

Vector_jiHe_biaoti.add("介紹");

String sql = "select * from tushu as a inner join ts_Type as"

+ " b on(a.ts_TypeID=b.ts_TypeID)";

ResultSet res = DBUtils.Select(sql);

try {

Vector_jiHe_biaoGeNeiRong = new Vector>();

while (res.next()) {

Vector v = new Vector();

v.add(res.getInt("ts_ID"));

v.add(res.getString("ts_Name"));

v.add(res.getDouble("ts_price"));

v.add(res.getInt("ts_TypeID"));

v.add(res.getString("ts_TypeName"));

v.add(res.getString("ts_Jieshao"));

Vector_jiHe_biaoGeNeiRong.add(v);

biaoGeMoXing1 = new DefaultTableModel(

Vector_jiHe_biaoGeNeiRong, Vector_jiHe_biaoti);

}

biaoGeMoXing1 = new DefaultTableModel(Vector_jiHe_biaoGeNeiRong,

Vector_jiHe_biaoti) {

@Override

public boolean isCellEditable(int a, int b) {

return false;

}

};

biaoGe1 = new JTable(biaoGeMoXing1);

biaoGe1.addMouseListener(new shijian_table(this));

biaoGe1.setBounds(0, 0, 400, 500);

gunDongTiao = new JScrollPane(biaoGe1);

gunDongTiao.setBounds(0, 0, 450, 150);

mianBan1 = new JPanel();/*

* JPanel1 = new JPanel(); 不可在gundong = new

* JScrollPane(JTable1);上面

*/

mianBan1.add(gunDongTiao);

// 加this.add(gundong);刪mianBan1.add(gunDongTiao );會有直接的滾動條，但變只可刪一次

mianBan1.setBounds(0, 0, 450, 250);

this.add(mianBan1);

} catch (SQLException e) {

e.printStackTrace();

}

shangPinLeiXingXiaLaKuang();

this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

this.setVisible(true);

// 這里引用chaxunchushihua();沒作用

}

// public void XXX() 格式就是封裝查詢的方法，可調用，無加靜態屬性的單詞

public void chaxunchushihua() {

// 判斷JPanel是不是為空

if (this.mianBan1 != null) {

// 面板1不為空說明面板1中有內容，就把面板1內容用從this中用remove移除，下面再加新內容

this.remove(mianBan1);

}

Vector_jiHe_biaoti = new Vector();

Vector_jiHe_biaoti.add("編號");

Vector_jiHe_biaoti.add("名稱");

Vector_jiHe_biaoti.add("價格");

Vector_jiHe_biaoti.add("類型ID");

Vector_jiHe_biaoti.add("類型名稱");

Vector_jiHe_biaoti.add("介紹");

String sql = "select * from tushu as a inner join ts_Type as"

+ " b on(a.ts_TypeID=b.ts_TypeID)";

ResultSet res = DBUtils.Select(sql);

try {

Vector_jiHe_biaoGeNeiRong = new Vector>();

while (res.next()) {

Vector v = new Vector();

v.add(res.getInt("ts_ID"));

v.add(res.getString("ts_Name"));

v.add(res.getDouble("ts_price"));

v.add(res.getInt("ts_TypeID"));

v.add(res.getString("ts_TypeName"));

v.add(res.getString("ts_Jieshao"));

Vector_jiHe_biaoGeNeiRong.add(v);

biaoGeMoXing1 = new DefaultTableModel(

Vector_jiHe_biaoGeNeiRong, Vector_jiHe_biaoti);

}

biaoGeMoXing1 = new DefaultTableModel(Vector_jiHe_biaoGeNeiRong,

Vector_jiHe_biaoti) {

@Override

public boolean isCellEditable(int a, int b) {

return false;

}

};

biaoGe1 = new JTable(biaoGeMoXing1);

// XXX.addMouseListener(new XXX(this));為給表格添加鼠標點擊事件的格式，多總結和記錄格式等法

biaoGe1.addMouseListener(new shijian_table(this));

gunDongTiao = new JScrollPane(biaoGe1);

gunDongTiao.setBounds(0, 0, 450, 150);

mianBan1 = new JPanel();

mianBan1.add(gunDongTiao);

mianBan1.setBounds(0, 0, 450, 250);

this.add(mianBan1);

} catch (SQLException e) {

e.printStackTrace();

}

// 釋放資源:this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

this.setVisible(true);

}

// shangPinLeiXingXiaLaKuang(商品類型下拉框)

public void shangPinLeiXingXiaLaKuang() {

String sql = "select * from ts_type";

ResultSet res = DBUtils.Select(sql);

xiaLaKuang = new JComboBox();

try {

while (res.next()) {

// com1. setSelectedIndex(Integer.parseInt(res. getObject(1).

// toString()));

xiaLaKuang.addItem(res.getObject(2).toString());

// xiaLaKuang.addItem(res.getObject(1).toString());

}

} catch (SQLException e) {

e.printStackTrace();

}

xiaLaKuang.setBounds(640, 340, 130, 30);

this.add(xiaLaKuang);

}

}

package denglu;

import java.awt.Color;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import java.awt.event.FocusEvent;

import java.awt.event.FocusListener;

import java.sql.ResultSet;

import java.sql.SQLException;

import javax.swing.JButton;

import javax.swing.JFrame;

import javax.swing.JLabel;

import javax.swing.JOptionPane;

import javax.swing.JTextField;

class shijian_zhmm implements FocusListener, ActionListener {

public zhaoHuiMiMa shijian_zhaoHuiMiMa1 = null;

public shijian_zhmm(zhaoHuiMiMa shijian_zhaoHuiMiMa2) {

this.shijian_zhaoHuiMiMa1 = shijian_zhaoHuiMiMa2;

}

@Override

public void actionPerformed(ActionEvent arg0) {

String String_uname = shijian_zhaoHuiMiMa1.txt_uname.getText().trim();

String String_wenti = shijian_zhaoHuiMiMa1.txt_wenti.getText().trim();

String String_daan = shijian_zhaoHuiMiMa1.txt_daan.getText().trim();

String sql = "select * from yonghu where yh_Uname='" + String_uname

+ "'and yh_Q='" + String_wenti + "'and yh_A='" + String_daan

+ "'";

ResultSet res = DBUtils.Select(sql);

try {

if (res.next()) {

new chongzhimimajiemian();

gongjvClass.uname = String_uname;

} else {

// JOptionPane.showMessageDialog(null,"XXX")是用來提示用戶答案輸入錯誤的格式

JOptionPane.showMessageDialog(null, "答案輸入錯誤");

shijian_zhaoHuiMiMa1.lb_daan1.setText("答案輸入錯誤");

shijian_zhaoHuiMiMa1.lb_daan1.setForeground(Color.red);

}

} catch (SQLException e) {

e.printStackTrace();

}

}

@Override

public void focusGained(FocusEvent arg0) {

// focusGained(FocusEvent arg0)是 失去焦點事件的格式

}

@Override

public void focusLost(FocusEvent arg0) {

String uname = shijian_zhaoHuiMiMa1.txt_uname.getText().trim();

String sql = "select * from yonghu where yh_uname='" + uname + "'";

ResultSet res = DBUtils.Select(sql);

try {

if (res.next()) {

String shiJian_wenti = res.getString("yh_Q");

shijian_zhaoHuiMiMa1.txt_wenti.setText(shiJian_wenti);

shijian_zhaoHuiMiMa1.lb_uname1.setText("");

} else {

shijian_zhaoHuiMiMa1.lb_uname1.setText("用戶名錯誤");

shijian_zhaoHuiMiMa1.lb_uname1.setForeground(Color.red);

}

} catch (SQLException e) {

e.printStackTrace();

}

}

}

public class zhaoHuiMiMa extends JFrame {

static JButton btn_queren, btn_quxiao = null;

static JLabel lb_uname, lb_wenti, lb_daan = null;

static JLabel lb_uname1, lb_wenti1, lb_daan1 = null;

/*

* 找回密碼思路:1.寫一個文本框用來填用戶名，用戶名需要添加焦點獲取事件，如果失去焦點后去數據庫查詢用戶輸入

* 的用戶名是否存在，如果存在就將其問題查詢出來,添加到第二 個文本框上(第二個文本框是不能手動輸

* 入的),讓用戶輸入答案，輸入完畢后點擊確定按鈕時判斷用戶名，問題和答案是否一致， 如果一致說明 用戶輸入的答案是正確的， 之后跳到重置密碼界面

*/

static JTextField txt_uname, txt_wenti, txt_daan = null;

public zhaoHuiMiMa() {

// 基本必須的內容：布局方式、大小居中、釋放資源(找回密碼頁面不需要釋放資源)、顯示

// 布局方式

this.setTitle("找回密碼頁面");

this.setLayout(null);

// 大小居中

this.setSize(500, 500);

this.setLocationRelativeTo(null);

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

lb_wenti = new JLabel("問題");

lb_daan = new JLabel("答案");

lb_uname1 = new JLabel("請輸入用戶名");

lb_daan1 = new JLabel("請輸入答案");

txt_uname = new JTextField();

txt_wenti = new JTextField();

txt_daan = new JTextField();

txt_uname.addFocusListener(new shijian_zhmm(this));

lb_uname1.setForeground(Color.blue);

lb_daan1.setForeground(Color.blue);

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

lb_wenti.setBounds(100, 140, 100, 30);

lb_daan.setBounds(100, 180, 100, 30);

lb_uname1.setBounds(310, 105, 100, 30);

lb_daan1.setBounds(310, 185, 100, 30);

this.add(lb_uname);

this.add(lb_wenti);

this.add(lb_daan);

this.add(lb_uname1);

this.add(lb_daan1);

txt_uname.setBounds(210, 100, 100, 30);

txt_wenti.setBounds(210, 140, 100, 30);

txt_wenti.setEditable(false);

txt_daan.setBounds(210, 180, 100, 30);

this.add(txt_uname);

this.add(txt_wenti);

this.add(txt_daan);

btn_queren = new JButton("確認且回答正確后跳轉重置密碼頁面");

btn_queren.addActionListener(new shijian_zhmm(this));

btn_quxiao = new JButton("取消");

btn_queren.setBounds(10, 230, 290, 30);

btn_quxiao.setBounds(340, 230, 70, 30);

this.add(btn_queren);

this.add(btn_quxiao);

// 顯示

this.setVisible(true);

}

}

《新程序員》：云原生和全面數字化實踐50位技術專家共同創作，文字、視頻、音頻交互閱讀

總結

以上是生活随笔為你收集整理的java getselectedrow_Java swing（2）自己设计完善的独特功能图书管理系统，获取下拉框等的文字内容等...的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。