?? appmain.java
字號:
}catch(java.sql.SQLException sqls){
sqls.printStackTrace();
} catch (Exception a) {
// TODO 自動生成 catch 塊
a.printStackTrace();
}
}
});
}
return jMenuItem3;
}
/**
* This method initializes jMenuItem4
*
* @return javax.swing.JMenuItem
*/
private JMenuItem getJMenuItem4() {
if (jMenuItem4 == null) {
jMenuItem4 = new JMenuItem();
jMenuItem4.setText("銷售商品");
jMenuItem4.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
Xiaoshou xiaoshou=new Xiaoshou();
jPanel.add("two",xiaoshou);
myc.show(jPanel,"two");
}
});
}
return jMenuItem4;
}
/**
* This method initializes jMenuItem5
*
* @return javax.swing.JMenuItem
*/
private JMenuItem getJMenuItem5() {
if (jMenuItem5 == null) {
jMenuItem5 = new JMenuItem();
jMenuItem5.setText("銷售報表");
jMenuItem5.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
String sql="select * from tb_sellHistory";
try{
Connection con=CommonaJdbc.connection;
PreparedStatement pstmt=con.prepareStatement(sql);
ResultSet rs=null;
rs=pstmt.executeQuery();
resultSetToExcel(rs,1);
Runtime.getRuntime().exec("cmd /c start .\\bb.xls");
}catch(java.sql.SQLException sqls){
sqls.printStackTrace();
} catch (Exception a) {
//TODO 自動生成 catch 塊
a.printStackTrace();
}
}
});
}
return jMenuItem5;
}
/**
* This method initializes jMenuItem6
*
* @return javax.swing.JMenuItem
*/
private JMenuItem getJMenuItem6() {
if (jMenuItem6 == null) {
jMenuItem6 = new JMenuItem();
jMenuItem6.setText("銷售歷史");
jMenuItem6.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
XiaoshouLS ls=new XiaoshouLS();
jPanel.add("four",ls);
myc.show(jPanel,"four");
}
});
}
return jMenuItem6;
}
/**
* This method initializes jMenuItem7
*
* @return javax.swing.JMenuItem
*/
private JMenuItem getJMenuItem7() {
if (jMenuItem7 == null) {
jMenuItem7 = new JMenuItem();
jMenuItem7.setText("銷售盤點");
jMenuItem7.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
Pandian pd=new Pandian();
pd.setVisible(true);
pd.setBounds(200,200,400,200);
}
});
}
return jMenuItem7;
}
/**
* This method initializes jMenuItem8
*
* @return javax.swing.JMenuItem
*/
private JMenuItem getJMenuItem8() {
if (jMenuItem8 == null) {
jMenuItem8 = new JMenuItem();
jMenuItem8.setText("用戶管理");
jMenuItem8.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
YH yh=new YH();
jPanel.add("six",yh);
myc.show(jPanel,"six");
yh.pack();
}
});
}
return jMenuItem8;
}
/**
* This method initializes jMenuItem9
*
* @return javax.swing.JMenuItem
*/
private JMenuItem getJMenuItem9() {
if (jMenuItem9 == null) {
jMenuItem9 = new JMenuItem();
jMenuItem9.setText("關于軟件");
jMenuItem9.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
if(gy)
{jPanel.add("zero",jLabel);
myc.show(jPanel,"zero");
Guanyu gy=new Guanyu();
gy.setVisible(true);
gy.setBounds(300,200,408,342);
}
}
});
}
return jMenuItem9;
}
/**
* This method initializes jToolBar
*
* @return javax.swing.JToolBar
*/
private JToolBar getJToolBar() {
if (jToolBar == null) {
jToolBar = new JToolBar();
jToolBar.setComponentOrientation(java.awt.ComponentOrientation.LEFT_TO_RIGHT);
jToolBar.setOrientation(javax.swing.JToolBar.HORIZONTAL);
jToolBar.add(getJButton());
jToolBar.add(getJButton1());
jToolBar.add(getJButton2());
jToolBar.add(getJButton3());
}
return jToolBar;
}
/**
* This method initializes jButton
*
* @return javax.swing.JButton
*/
private JButton getJButton() {
if (jButton == null) {
jButton = new JButton();
jButton.setIcon(new ImageIcon("./images/ImageBar12.jpg"));
jButton.setPreferredSize(new java.awt.Dimension(78,66));
jButton.setActionCommand(""); // Generated
jButton.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
if(bl)
{jPanel.add("zero",jLabel);
myc.show(jPanel,"zero");
Beifen bf=new Beifen();
bf.setVisible(true);
bf.setBounds(300,200,500,400);
}
}
});
}
return jButton;
}
/**
* This method initializes jButton1
*
* @return javax.swing.JButton
*/
private JButton getJButton1() {
if (jButton1 == null) {
jButton1 = new JButton();
jButton1.setIcon(new ImageIcon("./images/ImageBar21.jpg"));
jButton1.setPreferredSize(new java.awt.Dimension(78,66));
jButton1.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
ShangpinGL shangpin= new ShangpinGL();
jPanel.add("one",shangpin);
myc.show(jPanel,"one");
}
});
}
return jButton1;
}
/**
* This method initializes jButton2
*
* @return javax.swing.JButton
*/
private JButton getJButton2() {
if (jButton2 == null) {
jButton2 = new JButton();
jButton2.setToolTipText("");
jButton2.setIcon(new ImageIcon("./images/antispyX.png"));
jButton2.setPreferredSize(new java.awt.Dimension(78,66)); // Generated
jButton2.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
Xiaoshou xiaoshou=new Xiaoshou();
jPanel.add("two",xiaoshou);
myc.show(jPanel,"two");
}
});
}
return jButton2;
}
/**
* This method initializes jButton3
*
* @return javax.swing.JButton
*/
private JButton getJButton3() {
if (jButton3 == null) {
jButton3 = new JButton();
jButton3.setIcon(new ImageIcon("./images/ImageBar22_en.jpg"));
jButton3.setPreferredSize(new java.awt.Dimension(78,66)); // Generated
jButton3.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
try {
CommonaJdbc.connection.close();
} catch (SQLException e1) {
// TODO 自動生成 catch 塊
e1.printStackTrace();
}
System.exit(0);
}
});
}
return jButton3;
}
/**
* This method initializes jPanel
*
* @return javax.swing.JPanel
*/
private JPanel getJPanel() {
if (jPanel == null) {
try {
jLabel = new JLabel();
jPanel = new JPanel();
jPanel.setLayout(myc); // Generated
jLabel.setName("jLabel"); // Generated
jLabel.setText("JLabel"); // Generated
jLabel.setIcon(new ImageIcon("./images/main.jpg")); // Generated
jPanel.setPreferredSize(new java.awt.Dimension(751,595)); // Generated
jPanel.add(jLabel, jLabel.getName()); // Generated
}
catch (java.lang.Throwable e) {
// TODO: Something
}
}
return jPanel;
}
public void resultSetToExcel(ResultSet rs,int index) throws Exception
{
HSSFSheet sheet = workbook.getSheetAt(index);
HSSFRow row ;
HSSFCell cell ;
HSSFFont f = workbook.createFont();
HSSFCellStyle style = workbook.createCellStyle();
style.setFont(f);
f.setFontHeightInPoints((short) 8);//字號
style.setAlignment(HSSFCellStyle.ALIGN_CENTER);//左右居中
style.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);//上下居中
ResultSetMetaData md=rs.getMetaData();
int nColumn=md.getColumnCount();
int iRow=3;
//寫入各條記錄，每條記錄對應Excel中的一行
while(rs.next())
{
row = sheet.createRow(iRow);
row.setHeight((short)450);
for(int j=1;j<=nColumn;j++)
{
cell =row.createCell((short)(j-1));
cell.setCellStyle(style);
cell.setCellType(HSSFCell.CELL_TYPE_STRING);
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
cell.setCellValue(rs.getObject(j).toString());
}
iRow++;
}
FileOutputStream fOut = new FileOutputStream("bb.xls");
workbook.write(fOut);
fOut.flush();
fOut.close();
}
public void DataToExcelSheetAt() throws Exception
{
POIFSFileSystem fs = new POIFSFileSystem(new FileInputStream("./Book1.xls"));
workbook = new HSSFWorkbook(fs);
}
}// @jve:decl-index=0:visual-constraint="29,-65"
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -