import java.awt.BorderLayout;
import java.awt.EventQueue;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.JFrame;
import javax.swing.JPanel;
import javax.swing.border.EmptyBorder;
import javax.swing.JButton;
import javax.swing.JLabel;
import javax.swing.ImageIcon;
import java.awt.Font;
import java.awt.Color;
import java.awt.Toolkit;
public class dba extends JFrame {
private JPanel contentPane;
public dba() {
setIconImage(Toolkit.getDefaultToolkit().getImage("D:\\app\\Administrator\\oradata\\mysg\\\u56FE\u6807.png"));
setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
setBounds(80, 20, 1240, 700);
setTitle("欢迎管理");
contentPane = new JPanel();
contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));
setContentPane(contentPane);
contentPane.setLayout(null);
JButton btnNewButton = new JButton("\u589E\u52A0\u6B66\u5C06");
btnNewButton.setIcon(new ImageIcon("D:\\app\\Administrator\\oradata\\mysg\\\u589E\u52A0\u6B66\u5C06.jpg"));
btnNewButton.setForeground(new Color(255, 0, 0));
btnNewButton.setBackground(new Color(105, 105, 105));
btnNewButton.setFont(new Font("长城行楷体", Font.ITALIC, 28));
btnNewButton.setBounds(80, 81, 164, 42);
contentPane.add(btnNewButton);
btnNewButton.addActionListener(new addli
三国武将查询系统//Java访问数据库(七)
;
lblNewLabel.setBounds(0, 0, 1240, 700);
contentPane.add(lblNewLabel);
btnNewButton.addActionListener(new backlistener());
}
class inputlistener implements ActionListener
{
public void actionPerformed(ActionEvent e)
{
try{
s=input.getText();
s2=input2.getText();
String temps=new String();
if(s.equals("all"))
{
myJTextField.setText("武将名"+"\t\t\t"+"参加的战争"+"\t\t\t"+"主要战绩\n");
temps="select * from v_hero_war ";
ResultSet res=start.statement.executeQuery(temps);
while(res.next())
{
myJTextField.append(res.getString(1)+"\t\t"+res.getString(2)+"\t\t"+res.getString(3)+"\t\t"+"\n");
}
}
else if(s2.equals("all"))
{
myJTextField.setText("战争名"+"\t\t "+"参战阵营"+"\t\t "+"战果"+"\t\t "+"战争地点"+"\t\t\t\t"+"时间\n");
temps="select * from war";
ResultSet res=start.statement.executeQuery(temps);
while(res.next())
{
myJTextField.append(res.getString(1)+"\t\t"+res.getString(2)+"\t\t"+res.getString(3)+"\t\t"+res.getString(4)+"\t\t"+res.getString(5)+"\n");
}
}
else
{
myJTextField.setText("武将名"+"\t\t\t"+"参加的战争"+"\t\t\t"+"主要战绩\n");
temps="select * from v_hero_war where 武将='"+s+"' and 战争='"+s2+"'";
ResultSet res=start.statement.executeQuery(temps);
while(res.next())
{
myJTextField.append(res.getString(1)+"\t\t"+res.getString(2)+"\t\t"+res.getString(3)+"\n");
}
}
System.out.println(temps);
}catch(SQLException ss )
{
myJTextField.append("error!");
}
}
}
class backlistener implements ActionListener
{
public void actionPerformed(ActionEvent e)
{
war.this.setVisible(false);
Login f9=new Login();
f9.setVisible(true);
}
}
}