import java.awt.*;//import java.net.*;
import java.sql.*;import java.awt.event.*;
class DataWindows extends Frame implements ActionListener
{ TextField text;TextArea chinesetext; Button button; ResultSet rs=null;Statement Ex1Stmt=null;Connection Ex1Con;
DataWindows()
{ super("查询表单");
setBounds(150,150,300,120);
setVisible(true);
text=new TextField(16);
chinesetext=new TextArea(5,10);
button=new Button("确 定");
Panel p1=new Panel(),p2=new Panel();
p1.add(new Label("输入要查询的编号:"));
p1.add(text);
p2.add(button);
add(p1,"North");add(p2,"South");add(chinesetext,"Center");
button.addActionListener(this);
addWindowListener(new WindowAdapter()
{ public void windowClosing(WindowEvent e)
{ System.exit(0);
}
});
}
public void actionPerformed(ActionEvent e)
{ if(e.getSource()==button)
{ chinesetext.setText("查询结果");
try{ Liststudent();
}
catch(SQLException ee) {}
}
}
public void Liststudent() throws SQLException
{ String cname,ename;
try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){}
Ex1Con=DriverManager.getConnection("jdbc:odbc:text","","");
Ex1Stmt=Ex1Con.createStatement();
rs=Ex1Stmt.executeQuery("SELECT * FROM text");
boolean boo=false;
while((boo=rs.next())==true)
{
ename=rs.getString("编号");
cname=rs.getString("姓名");
if(ename.equals(text.getText()))
{
chinesetext.append('/n'+cname);
break;
}
}
Ex1Con.close();
if(boo==false)
{ chinesetext.append('/n'+"没有该单词");
}
}
}
public class example23_9
{ public static void main(String args[])
{ DataWindows window=new DataWindows();window.pack();
}
}
我不知道为什么显示不出数据?
import java.sql.*;import java.awt.event.*;
class DataWindows extends Frame implements ActionListener
{ TextField text;TextArea chinesetext; Button button; ResultSet rs=null;Statement Ex1Stmt=null;Connection Ex1Con;
DataWindows()
{ super("查询表单");
setBounds(150,150,300,120);
setVisible(true);
text=new TextField(16);
chinesetext=new TextArea(5,10);
button=new Button("确 定");
Panel p1=new Panel(),p2=new Panel();
p1.add(new Label("输入要查询的编号:"));
p1.add(text);
p2.add(button);
add(p1,"North");add(p2,"South");add(chinesetext,"Center");
button.addActionListener(this);
addWindowListener(new WindowAdapter()
{ public void windowClosing(WindowEvent e)
{ System.exit(0);
}
});
}
public void actionPerformed(ActionEvent e)
{ if(e.getSource()==button)
{ chinesetext.setText("查询结果");
try{ Liststudent();
}
catch(SQLException ee) {}
}
}
public void Liststudent() throws SQLException
{ String cname,ename;
try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){}
Ex1Con=DriverManager.getConnection("jdbc:odbc:text","","");
Ex1Stmt=Ex1Con.createStatement();
rs=Ex1Stmt.executeQuery("SELECT * FROM text");
boolean boo=false;
while((boo=rs.next())==true)
{
ename=rs.getString("编号");
cname=rs.getString("姓名");
if(ename.equals(text.getText()))
{
chinesetext.append('/n'+cname);
break;
}
}
Ex1Con.close();
if(boo==false)
{ chinesetext.append('/n'+"没有该单词");
}
}
}
public class example23_9
{ public static void main(String args[])
{ DataWindows window=new DataWindows();window.pack();
}
}
我不知道为什么显示不出数据?