一区二区在线免费观看,久久午夜精品福利一区二区,一级特黄色大片

package superMarketSystem;
import javax.swing.*;
import java.util.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.Connection;
import java.sql.Driver;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
public class Main extends JFrame implements ActionListener {
JPanel jp1, jp2;
JLabel jl1, jl2;
JButton jb1, jb2, jb3, jb4,jb5;
JTable jt;
JScrollPane jsp;
JTextField jtf;
Model sm;
Statement stat = null;
PreparedStatement ps;
Connection ct = null;
ResultSet rs = null;
public Main() {
jp1 = new JPanel();
jtf = new JTextField(10);
jb1 = new JButton("查詢");
jb1.addActionListener(this);
jl1 = new JLabel("請(qǐng)輸入商品號(hào)：");
jp1.add(jl1);
jp1.add(jtf);
jp1.add(jb1);
jb2 = new JButton("添加");
jb2.addActionListener(this);
jb3 = new JButton("修改");
jb3.addActionListener(this);
jb4 = new JButton("刪除");
jb4.addActionListener(this);
jb5 = new JButton("瀏覽");
jb5.addActionListener(this);
jp2 = new JPanel();
jp2.add(jb2);
jp2.add(jb3);
jp2.add(jb4);
jp2.add(jb5);
sm = new Model();
jt = new JTable(sm);
jsp = new JScrollPane(jt);
this.add(jsp);
this.add(jp1, "North");
this.add(jp2, "South");
setTitle("超市信息管理系統(tǒng)");
setSize(800, 600);
setVisible(true);
setDefaultCloseOperation(EXIT_ON_CLOSE);
}
public static void main(String[] args) {
Main test3 = new Main();
}
public void actionPerformed(ActionEvent arg0) {
if (arg0.getSource() == jb1) {
System.out.println("開(kāi)始進(jìn)行查詢操作");
String name = this.jtf.getText().trim();
String sql = "select * from goods where goodsId = '" + name + "' ";
System.out.println("查詢完成");
sm = new Model(sql);
jt.setModel(sm);
}
else if (arg0.getSource() == jb2) {
System.out.println("開(kāi)始進(jìn)行添加操作");
Add sa = new Add(this, "添加商品信息", true);
System.out.println("添加成功");
sm = new Model();
jt.setModel(sm);
} else if (arg0.getSource() == jb4) {
System.out.println("開(kāi)始進(jìn)行刪除操作");
int rowNum = this.jt.getSelectedRow();
if (rowNum == -1) {
JOptionPane.showMessageDialog(this, "請(qǐng)選中一行");
return;
}
String goodsId = (String) sm.getValueAt(rowNum, 0);
System.out.println("已成功刪除商品號(hào):" + goodsId + "的信息");
try {
Class.forName("com.mysql.cj.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/chaoshi?useSSL=false&serverTimezone=UTC";
String user = "root";
String passwd = "123356";
ct = DriverManager.getConnection(url, user, passwd);
System.out.println("連接成功");
ps = ct.prepareStatement("delete from goods where goodsId = ?");
ps.setString(1,goodsId);
ps.executeUpdate();
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
if (rs != null) {
rs.close();
rs = null;
}
if (ps != null) {
ps.close();
ps = null;
}
if (ct != null) {
ct.close();
ct = null;
}
} catch (Exception e) {
e.printStackTrace();
}
}
sm = new Model();
jt.setModel(sm);
} else if (arg0.getSource() == jb3) {
System.out.println("開(kāi)始進(jìn)行修改操作");
int rowNum = this.jt.getSelectedRow();
if (rowNum == -1) {
JOptionPane.showMessageDialog(this, "請(qǐng)選擇一行");
return;
}
String goodsId = (String) sm.getValueAt(rowNum, 0);
try {
Class.forName("com.mysql.cj.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/chaoshi?useSSL=false&serverTimezone=UTC";
String user = "root";
String passwd = "123356";
ct = DriverManager.getConnection(url, user, passwd);
System.out.println("連接成功");
ps = ct.prepareStatement("delete from goods where goodsId = ?");
ps.setString(1, goodsId);
ps.executeUpdate();
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
if (rs != null) {
rs.close();
rs = null;
}
if (ps != null) {
ps.close();
ps = null;
}
if (ct != null) {
ct.close();
ct = null;
}
} catch (Exception e) {
e.printStackTrace();
}
}
Update su = new Update(this, "修改商品信息", true, sm, rowNum);
System.out.println("修改完成");
sm = new Model();
jt.setModel(sm);
}
else if(arg0.getSource() == jb5){
sm = new Model();
jt.setModel(sm);
}
}
}

復(fù)制代碼

久久久久久久999_99精品久久精品一区二区爱城_成人欧美一区二区三区在线播放_国产精品日本一区二区不卡视频_国产午夜视频_欧美精品在线观看免费