package JING;//借还信息表*//
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.*;
import java.util.Calendar;
import javax.swing.*;
public class ThroughInformation extends JFrame implements ActionListener{
private static final long serialVersionUID = 1L;
JButton Borrow, Update, Back, Select1; //创建按钮
JTable table; //创建表格
Object body[][] = new Object[50][10];
String fields[] = { "借条单号", "产品名称", "产品目前状态", "借出数量","归还数量","计量单位", "借出时间", "归还时间","仓库管理员工号","借货人姓名" };
Connection conn;
Statement st;
ResultSet rs;
JTabbedPane tp;
CONN Conn=new CONN();
public ThroughInformation() {
super("------------产品借-还情况------------");
this.setSize(1200,700);
this.setLocation(500, 200);
this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
JPanel ps = new JPanel();
Borrow = new JButton("借还填写"); //按钮文字定义
Select1 = new JButton("借出查询"); //按钮文字定义
Update = new JButton("归还查询"); //按钮文字定义
Back = new JButton("返回"); //按钮文字定义
Borrow.addActionListener(this);
Select1.addActionListener(this);
Update.addActionListener(this);
Back.addActionListener(this);
ps.add(Borrow);
ps.add(Select1);
ps.add(Update);
ps.add(Back);
this.connection();
table = new JTable(body, fields);
tp = new JTabbedPane();
tp.add("借还信息", new JScrollPane(table));
this.getContentPane().add(tp, "Center");
this.getContentPane().add(ps, "East");
this.setVisible(true);
}
//数据库连接
public void connection() {
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
conn = DriverManager.getConnection("jdbc:sqlserver://127.0.0.1:1433;DatabaseName = DB","sa","123456");
st = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
} catch (Exception ex) {
ex.printStackTrace();
System.out.println("连接错误：" + ex.getMessage());
}
}
public static void main(String[] args) {
ThroughInformation dt = new ThroughInformation();
}
public void actionPerformed(ActionEvent e) {
if (e.getSource() == Borrow) {
add();
}
if (e.getSource() == Select1) {
select1();
}
if (e.getSource() == Update) {
select2();
}
if (e.getSource() == Back) {
this.setVisible(false);
new MainInterface();
}
}
/*//更新
private void update() {
try {
int row = table.getSelectedRow();
JTextField t[] = new JTextField[15];
t[0] = new JTextField("输入产品编号：");
t[0].setEditable(false);
t[1] = new JTextField();
t[1].setText((String) body[row][1]);
t[2] = new JTextField("输入产品状态：");
t[2].setEditable(false);
t[3] = new JTextField();
t[3].setText((String) body[row][2]);
t[4] = new JTextField("输入借还数量：");
t[4].setEditable(false);
t[5] = new JTextField();
t[5].setText((String) body[row][3]);
t[6] = new JTextField("输入计量单位：");
t[6].setEditable(false);
t[7] = new JTextField();
t[7].setText((String) body[row][4]);
t[8] = new JTextField("输入借出时间：");
t[8].setEditable(false);
t[9] = new JTextField();
t[9].setText((String) body[row][5]);
t[10] = new JTextField("输入归还时间：");
t[10].setEditable(false);
t[11] = new JTextField();
t[11].setText((String) body[row][6]);
String but[] = { "确定", "取消" };
int go = JOptionPane.showOptionDialog(null, t, "修改信息", JOptionPane.YES_OPTION,
JOptionPane.INFORMATION_MESSAGE, null, but, but[0]);
if (go == 0) {
//String 借条单号 = (String)t[1].getText();
String 产品单号1 = (String)t[1].getText();
String 产品状态1 = (String)t[3].getText();
int 借还数量1 = Integer.parseInt(t[5].getText());
String 计量单位1 = (String)t[7].getText();
String 借出时间1 = (String)t[9].getText();
String 归还时间1 = (String)t[11].getText();
String str = "update 借条信息 set 产品单号='"+ 产品单号1 +"',产品状态='"+ 产品状态1 +"',借还数量'"+ 借还数量1 +"',计量单位'"+ 计量单位1 +"',借出时间'"+ 借出时间1 +"',归还时间'"+ 归还时间1
+ "'where 借条单号='" + body[row][0] + "' ";
st.executeUpdate(str);
JOptionPane.showMessageDialog(null, "数据已经修改成功！");
this.select();
st.executeUpdate(str);
//JOptionPane.showMessageDialog(null, "数据已经成功插入！");
}
} catch (Exception ex) {
ex.printStackTrace();
JOptionPane.showMessageDialog(null, "更新数据失败！");
}
}*/
private void select() {
String str = "select 借条单号, 产品名称, 产品目前状态, 借出数量,归还数量,"
+ " 借出时间, 归还时间,仓库管理员工号,借货人姓名 from 借还信息,产品信息"
+ " where 产品信息.产品编号=借还信息.产品编号";
filltable(str);
}
private void select1() {
String str = "select 借条单号, 借还信息.产品编号, 产品目前状态, 借出数量,归还数量,"
+ " 借出时间, 归还时间,仓库管理员工号,借货人姓名 from 借还信息,产品信息"
+ " where 产品目前状态 = '借' and 产品信息.产品编号=借还信息.产品编号";
filltable(str);
}
private void select2() {
String str = "select 借条单号, 借还信息.产品编号, 产品目前状态, 借出数量,归还数量,"
+ " 借出时间, 归还时间,仓库管理员工号,借货人姓名 from 借还信息, 产品信息"
+ " where 产品目前状态 = '还'and 产品信息.产品编号=借还信息.产品编号";
filltable(str);
}
private void filltable(String str) {
try {
for(int x=0;x<body.length;x++){
body[x][0]=null;
body[x][1]=null;
body[x][2]=null;
body[x][3]=null;
body[x][4]=null;
body[x][5]=null;
body[x][6]=null;
body[x][7]=null;
body[x][8]=null;
// body[x][9]=null;
}
int i = 0;
rs = st.executeQuery(str);
while(rs.next()){
body[i][0]=rs.getString("借条单号");
body[i][1]=rs.getString("产品编号");
body[i][2]=rs.getString("产品目前状态");
body[i][3]=rs.getString("借出数量");
body[i][4]=rs.getString("归还数量");
body[i][5]=rs.getString("借出时间");
body[i][6]=rs.getString("归还时间");
body[i][7]=rs.getString("仓库管理员工号");
body[i][8]=rs.getString("借货人姓名");
// body[i][9]=rs.getString("归还数量");
i=i+1;
}
this.repaint(i);
} catch (Exception ex){
System.out.println("数据操作失败1！");
ex.printStackTrace();
}
}
private voi
SQL SERVER +java界面的库存管理系统.zip （141个子文件） 
assumedExternalFilesCache 4B _0.cfe 129B _0.cfs 314B ThroughInformation.class 9KB DeliveryInformation.class 8KB IncomingInformation.class 8KB seletnian$Select.class 6KB seletbianhao.class 6KB selectcukd.class 6KB selectrukd.class 6KB Select.class 6KB SeliInterface.class 5KB InventoryInformation.class 5KB ProductInformation.class 5KB WarehouseInformation.class 4KB BorrowInformation.class 4KB CustomerInformation.class 4KB ManagerInformation.class 4KB Querywindow.class 4KB Userlogin.class 4KB CONNECTION.class 3KB MainInterface.class 3KB ConnectionUtil.class 3KB Userlogin$1.class 2KB CONNECTION$2.class 1KB CONN.class 1KB seletnian$Select$2.class 1KB MainInterface$4.class 1KB MainInterface$3.class 1KB MainInterface$2.class 1KB MainInterface$1.class 1KB MainInterface$5.class 1KB Querywindow$10.class 1020B Querywindow$12.class 1019B Querywindow$11.class 1019B Querywindow$1.class 1018B MainInterface$6.class 1018B Querywindow$2.class 1017B Querywindow$3.class 1015B Querywindow$13.class 1014B Querywindow$9.class 1005B seletbianhao$2.class 1005B Querywindow$5.class 1004B Querywindow$8.class 1004B Querywindow$6.class 1003B Querywindow$7.class 1001B Querywindow$4.class 1000B seletnian$Select$1.class 999B selectrukd$2.class 991B selectcukd$2.class 991B Select$2.class 963B seletbianhao$1.class 945B selectcukd$1.class 933B selectrukd$1.class 933B Select$1.class 909B CONNECTION$3.class 703B Userlogin$2.class 685B CONNECTION$1.class 664B seletyue.class 377B seletnian.class 329B .classpath 286B variablesAndContainers.dat 129B index.db 0B
数据库基本表.docx 21KB externalFilesCache 4B properties.index 57B version.ini 102B introstate 62B
sqljdbc.jar 506KB sqljdbc.jar 506KB ThroughInformation.java 12KB DeliveryInformation.java 9KB IncomingInformation.java 8KB Querywindow.java 8KB selectcukd.java 6KB seletbianhao.java 6KB selectrukd.java 6KB seletnian.java 6KB Select.java 6KB SeliInterface.java 4KB Userlogin.java 4KB InventoryInformation.java 4KB ProductInformation.java 3KB CONNECTION.java 3KB MainInterface.java 3KB BorrowInformation.java 3KB ManagerInformation.java 3KB CustomerInformation.java 3KB WarehouseInformation.java 3KB ConnectionUtil.java 2KB CONN.java 824B seletyue.java 222B
4.jpg 530KB 6.jpg 315KB 3.jpg 65KB 1.jpg 7KB server-config.json 2KB DB_log.ldf 2MB .lock 0B write.lock 0B共 141 条
- 1
- 2
资源评论
