import java.awt.BorderLayout; import java.a
三国武将查询系统//Java访问数据库(二)
+"\t\t"+"招募地"+"\t\t"+"坐骑\n");
}
class inputlistener implements ActionListener
{
public void actionPerformed(ActionEvent e)
{
myJTextField.setText("姓"+"\t\t"+"字"+"\t\t"+"武力"+"\t\t"+"智力"+"\t\t"+"德行"+"\t\t"+"兵器"+"\t\t"+"招募地"+"\t\t"+"坐骑\n");
try{
s=input.getText();
String temps=new String();
if(s.equals("all"))
{
temps="select * from v_hero ";
}
else
{
temps="select * from v_hero where 姓名='"+s+"'";
}
//System.out.println(temps);
ResultSet res=statement.executeQuery(temps);
while(res.next())
{
myJTextField.append(res.getString(1)+"\t"+res.getString(2)+"\t\t"+res.getString(3)+"\t\t"+res.getString(4)+"\t\t"+res.getString(5)+"\t"+res.getString(6)+"\t"+res.getString(7)+"\t"+res.getString(8)+"\n");
}
}catch(SQLException ss )
{
myJTextField.append("error!");
}
}
}
class orderlistener implements ActionListener
{
public void actionPerformed(ActionEvent e)
{
myJTextField.setText("姓"+"\t\t"+"字"+"\t\t"+"武力"+"\t\t"+"智力"+"\t\t"+"德行"+"\t\t"+"兵器"+"\t\t"+"招募地"+"\t\t"+"坐骑\n");
try{
String temps=new String();
temps="select * from v_hero order by 武力 desc";
ResultSet res=statement.executeQuery(temps);
while(res.next())
{
myJTextField.append(res.getString(1)+"\t"+res.getString(2)+"\t\t"+res.getString(3)+"\t\t"+res.getString(4)+"\t\t"+res.getString(5)+"\t"+res.getString(6)+"\t"+res.getString(7)+"\t"+res.getString(8)+"\n");
}
}catch(SQLException ss )
{
myJTextField.append("error!");
}
}
}
class orderlistener2 implements ActionListener
{
public void actionPerformed(ActionEvent e)
{
myJTextField.setText("姓"+"\t\t"+"字"+"\t\t"+"武力"+"\t\t"+"智力"+"\t\t"+"德行"+"\t\t"+"兵器"+"\t\t"+"招募地"+"\t\t"+"坐骑\n");
try{
String temps=new String();
temps="select * from v_hero order by 智力 desc";
ResultSet res=statement.executeQuery(temps);
while(res.next())
{
myJTextField.append(res.getString(1)+"\t"+res.getString(2)+"\t\t"+res.getString(3)+"\t\t"+res.getString(4)+"\t\t"+res.getString(5)+"\t"+res.getString(6)+"\t"+res.getString(7)+"\t"+res.getString(8)+"\n");
}
}catch(SQLException ss )
{
myJTextField.append("error!");
}
}
}
class backlistener implements ActionListener
{
public void actionPerformed(ActionEvent e)
{
start.this.setVisible(false);
Login f9=new Login();
f9.setVisible(true);
}
}
public static void main(String[] args)
throws SQLException,ClassNotFoundException
{
//new music();
// System.out.println("ssss");
Class.forName("oracle.jdbc.driver.
OracleDriver");
connection =DriverManager.getConnection
("jdbc:oracle:thin:@localhost:1521:MYSG","scott","scott");
statement =connection.createStatement();
Login log=new Login();
log.setVisible(true);
new music().play(new File("F:\\cc.wav"));
//start one= new start();
//one.setVisible(true);
}
}