package ordersystem;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.swing.JOptionPane;
import javax.swing.JTable;
public class materil extends javax.swing.JFrame {
String url = "jdbc:sqlserver://localhost:1433;DatabaseName=20190650";
String username = "sa";
String password = "123";
Connection conn = null;
Statement stmt = null;
PreparedStatement pstm =null;
private javax.swing.JButton jButton1;
private javax.swing.JButton jButton10;
private javax.swing.JButton jButton2;
private javax.swing.JButton jButton8;
private javax.swing.JButton jButton9;
private javax.swing.JPanel jPanel2;
private javax.swing.JScrollPane jScrollPane1;
private javax.swing.JTable jTable1;
private javax.swing.JTextField jTextField1;
private javax.swing.JToggleButton jToggleButton1;
private javax.swing.JToggleButton jToggleButton2;
public materil() {
initComponents();
}
private void connectdb() {
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
conn = DriverManager.getConnection(url, username, password);
} catch (ClassNotFoundException cnfe) {
JOptionPane.showMessageDialog(null, "数据源错误", "错误", JOptionPane.ERROR_MESSAGE);
} catch (SQLException sqle) {
JOptionPane.showMessageDialog(null, "数据操作错误", "错误", JOptionPane.ERROR_MESSAGE);
}
}
private void initComponents() {
jPanel2 = new javax.swing.JPanel();
jToggleButton1 = new javax.swing.JToggleButton();
jToggleButton2 = new javax.swing.JToggleButton();
jButton1 = new javax.swing.JButton();
jScrollPane1 = new javax.swing.JScrollPane();
jTable1 = new javax.swing.JTable();
jButton8 = new javax.swing.JButton();
jButton9 = new javax.swing.JButton();
jButton10 = new javax.swing.JButton();
jTextField1 = new javax.swing.JTextField();
jButton2 = new javax.swing.JButton();
setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
jPanel2.setBackground(new java.awt.Color(120, 150, 190));
jPanel2.setBorder(javax.swing.BorderFactory.createTitledBorder(null, "外卖点餐系统", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, new java.awt.Font("微软雅黑", 1, 24), new java.awt.Color(255, 255, 255))); // NOI18N
jPanel2.setAutoscrolls(true);
jToggleButton1.setText("退出");
jToggleButton1.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jToggleButton1ActionPerformed(evt);
}
});
jToggleButton2.setText("返回");
jToggleButton2.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jToggleButton2ActionPerformed(evt);
}
});
jButton1.setText("修改");
jButton1.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton1ActionPerformed(evt);
}
});
jTable1.setModel(new javax.swing.table.DefaultTableModel(
new Object [][] {
{null, null, null, null},
{null, null, null, null},
{null, null, null, null},
{null, null, null, null}
},
new String [] {
"Title 1", "Title 2", "Title 3", "Title 4"
}
));
jScrollPane1.setViewportView(jTable1);
jButton8.setText("刷新");
jButton8.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton8ActionPerformed(evt);
}
});
jButton9.setText("删除");
jButton9.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton9ActionPerformed(evt);
}
});
jButton10.setText("查询进购记录");
jButton10.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton10ActionPerformed(evt);
}
});
jButton2.setText("增加");
jButton2.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton2ActionPerformed(evt);
}
});
javax.swing.GroupLayout jPanel2Layout = new javax.swing.GroupLayout(jPanel2);
jPanel2.setLayout(jPanel2Layout);
jPanel2Layout.setHorizontalGroup(
jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel2Layout.createSequentialGroup()
.addContainerGap()
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel2Layout.createSequentialGroup()
.addGap(0, 699, Short.MAX_VALUE)
.addComponent(jToggleButton2)
.addGap(18, 18, 18)
.addComponent(jToggleButton1))
.addGroup(jPanel2Layout.createSequentialGroup()
.addComponent(jScrollPane1)
.addContainerGap())
.addGroup(jPanel2Layout.createSequentialGroup()
.addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE, 228, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(18, 18, 18)
.addComponent(jButton10)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jButton2)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(jButton1)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(jButton9)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jButton8)
.addGap(54, 54, 54))))
);
jPanel2Layout.setVerticalGroup(
jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel2Layout.createSequentialGroup()
.addGap(15, 15, 15)
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jButton10)
.addComponent(jButton1)
.addComponent(jButton9)
.addComponent(jButton8)
.addComponent(jButton2))
.addGap(18, 18, 18)
.addComponent(jScrollPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 383, Short.MAX_VALUE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE
没有合适的资源?快使用搜索试试~ 我知道了~
温馨提示
用Java实现图形界面,连接数据库,实现的外卖点餐系统,可供课设,比赛,实训等使用。详情可见:https://www.bilibili.com/video/BV1kz421m7su/?pop_share=1&vd_source=07282a5ee1f4cb87c501587c6bcb5435
资源详情
资源评论
资源推荐
收起资源包目录
java swing+sql server实现的外卖点餐系统,适用于课设、大作业 (114个子文件)
materil.class 15KB
gongyingshang.class 15KB
gengxincaidan.class 15KB
huiyuan.class 14KB
Order.class 13KB
Evaluate.class 13KB
guanli.class 13KB
menu1.class 12KB
selectshop.class 11KB
zhuce.class 11KB
guanlidenglu.class 10KB
shouye.class 10KB
guanlidenglu$2.class 915B
selectshop$4.class 903B
selectshop$3.class 903B
shouye$1.class 879B
gongyingshang$2.class 775B
gengxincaidan$1.class 775B
gengxincaidan$2.class 775B
gongyingshang$1.class 775B
gongyingshang$6.class 770B
gengxincaidan$6.class 770B
gengxincaidan$7.class 769B
gongyingshang$3.class 769B
gongyingshang$4.class 769B
gengxincaidan$4.class 769B
gongyingshang$5.class 769B
gengxincaidan$5.class 769B
guanlidenglu$1.class 769B
gongyingshang$7.class 769B
gengxincaidan$3.class 769B
guanlidenglu$3.class 763B
guanlidenglu$4.class 763B
selectshop$1.class 757B
selectshop$2.class 757B
selectshop$5.class 751B
Evaluate$2.class 745B
Evaluate$1.class 745B
materil$2.class 739B
Evaluate$4.class 739B
huiyuan$2.class 739B
huiyuan$1.class 739B
Evaluate$3.class 739B
materil$1.class 739B
huiyuan$6.class 734B
materil$6.class 734B
huiyuan$3.class 733B
huiyuan$4.class 733B
guanli$2.class 733B
guanli$1.class 733B
materil$3.class 733B
huiyuan$5.class 733B
materil$7.class 733B
materil$5.class 733B
materil$4.class 733B
shouye$3.class 733B
guanli$8.class 727B
guanli$9.class 727B
guanli$6.class 727B
menu1$1.class 727B
guanli$5.class 727B
Order$1.class 727B
shouye$2.class 727B
zhuce$1.class 727B
Order$2.class 727B
zhuce$2.class 727B
menu1$2.class 727B
shouye$4.class 727B
guanli$4.class 727B
guanli$7.class 727B
guanli$3.class 727B
menu1$6.class 721B
menu1$3.class 721B
Order$3.class 721B
Order$4.class 721B
zhuce$3.class 721B
menu1$5.class 721B
Order$5.class 721B
menu1$4.class 721B
Order$6.class 721B
gongyingshang$8.class 577B
gengxincaidan$8.class 577B
guanlidenglu$5.class 573B
selectshop$6.class 565B
Evaluate$5.class 557B
huiyuan$7.class 553B
materil$8.class 553B
guanli$10.class 551B
shouye$5.class 549B
zhuce$4.class 545B
menu1$7.class 545B
Order$7.class 545B
.classpath 825B
.gitignore 184B
Takeout Order Management System.iml 2KB
materil.java 16KB
gongyingshang.java 16KB
gengxincaidan.java 15KB
guanli.java 15KB
Evaluate.java 15KB
共 114 条
- 1
- 2
ES·Lad
- 粉丝: 131
- 资源: 10
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
评论2