import java.sql.*;
import java.awt.*;
import java.net.*;
import java.awt.event.*;
import java.sql.*;
class Window extends Frame implements ActionListener
{TextArea text;Panel panel;TextField xingming;
Button button1,button2;
Window()
{super("成绩查询");
setLayout(new BorderLayout());setBackground(Color.cyan);
setBounds(150,150,300,120);setVisible(true);
text=new TextArea();button1=new Button("确定");
button2=new Button("查询所有人的成绩");xingming=new TextField(16);
panel=new Panel();
panel.add(new Label("输入被查询的学生的姓名"));panel.add(xingming);
panel.add(button1);
add(panel,"North"); add(text,"Center");
add(button2,"South");
text.setEditable(false);
text.setBackground(Color.pink);
button1.addActionListener(this);
button2.addActionListener(this);
addWindowListener(new WindowAdapter()
{public void windowClosing(WindowEvent e)
{setVisible(false);System.exit(0);}});
}
public void actionPerformed(ActionEvent e)
{if(e.getSource()==button1)
{text.setText("查询结果"+'\n');
try{Liststudent1();}
catch(SQLException ee){}
}
else if(e.getSource()==button2)
{text.setText("查询结果"+'\n');
try{Liststudent2();}
catch(SQLException ee){}
}
}
public void Liststudent1() throws SQLException
{String name;int math,english,physics,sum;
try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
catch(ClassNotFoundException e){}
Connection con=DriverManager.getConnection("jdbc.odbc:student","admin","admin");
Statement sql=con.createStatement();
ResultSet rs=sql.executeQuery("SELECT * FROM student");
while(rs.next())
{name=rs.getString("姓名");math=rs.getInt("数学");
physics=rs.getInt("物理");english=rs.getInt("英语");
sum=english+math+physics;
if((name.trim()).equals(xingming.getText().trim()))
{text.append("****"+"\n"+name+"的成绩: "+"\n"+"数学: "+math+"英语: "+english+"物理:"+physics+"总分"+sum+'\n');
}
}
if((text.getText().trim()).equals("查询结果"))
{text.setText("没有该人的成绩");
}
}
public void Liststudent2() throws SQLException
{String name;int math,english,physics,sum;java.sql.Statement sql=null;
try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
catch(ClassNotFoundException e){}
Connection con=DriverManager.getConnection("jdbc.odbc:student","admin","admin");(1)
sql=con.createStatement();
ResultSet rs=sql.executeQuery("SELECT * FROM student");
while(rs.next())
{name=rs.getString("姓名");math=rs.getInt("数学");
physics=rs.getInt("物理");english=rs.getInt("英语");
sum=english+math+physics;
text.append("****"+"\n"+name+"的成绩: "+"\n"+"数学: "+math+"英语: "+english+"物理:"+physics+"总分"+sum+'\n');
}
}
}
public class Lu
{public static void main(String args[])
{Window window=new Window();
window.pack();
}
}
就在(1)这句好像就连不上。请大家帮忙看看?
import java.awt.*;
import java.net.*;
import java.awt.event.*;
import java.sql.*;
class Window extends Frame implements ActionListener
{TextArea text;Panel panel;TextField xingming;
Button button1,button2;
Window()
{super("成绩查询");
setLayout(new BorderLayout());setBackground(Color.cyan);
setBounds(150,150,300,120);setVisible(true);
text=new TextArea();button1=new Button("确定");
button2=new Button("查询所有人的成绩");xingming=new TextField(16);
panel=new Panel();
panel.add(new Label("输入被查询的学生的姓名"));panel.add(xingming);
panel.add(button1);
add(panel,"North"); add(text,"Center");
add(button2,"South");
text.setEditable(false);
text.setBackground(Color.pink);
button1.addActionListener(this);
button2.addActionListener(this);
addWindowListener(new WindowAdapter()
{public void windowClosing(WindowEvent e)
{setVisible(false);System.exit(0);}});
}
public void actionPerformed(ActionEvent e)
{if(e.getSource()==button1)
{text.setText("查询结果"+'\n');
try{Liststudent1();}
catch(SQLException ee){}
}
else if(e.getSource()==button2)
{text.setText("查询结果"+'\n');
try{Liststudent2();}
catch(SQLException ee){}
}
}
public void Liststudent1() throws SQLException
{String name;int math,english,physics,sum;
try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
catch(ClassNotFoundException e){}
Connection con=DriverManager.getConnection("jdbc.odbc:student","admin","admin");
Statement sql=con.createStatement();
ResultSet rs=sql.executeQuery("SELECT * FROM student");
while(rs.next())
{name=rs.getString("姓名");math=rs.getInt("数学");
physics=rs.getInt("物理");english=rs.getInt("英语");
sum=english+math+physics;
if((name.trim()).equals(xingming.getText().trim()))
{text.append("****"+"\n"+name+"的成绩: "+"\n"+"数学: "+math+"英语: "+english+"物理:"+physics+"总分"+sum+'\n');
}
}
if((text.getText().trim()).equals("查询结果"))
{text.setText("没有该人的成绩");
}
}
public void Liststudent2() throws SQLException
{String name;int math,english,physics,sum;java.sql.Statement sql=null;
try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
catch(ClassNotFoundException e){}
Connection con=DriverManager.getConnection("jdbc.odbc:student","admin","admin");(1)
sql=con.createStatement();
ResultSet rs=sql.executeQuery("SELECT * FROM student");
while(rs.next())
{name=rs.getString("姓名");math=rs.getInt("数学");
physics=rs.getInt("物理");english=rs.getInt("英语");
sum=english+math+physics;
text.append("****"+"\n"+name+"的成绩: "+"\n"+"数学: "+math+"英语: "+english+"物理:"+physics+"总分"+sum+'\n');
}
}
}
public class Lu
{public static void main(String args[])
{Window window=new Window();
window.pack();
}
}
就在(1)这句好像就连不上。请大家帮忙看看?
解决方案 »
- 页面表单像PO中的Set集合传值
- label和input输入域提交数据
- 请问eclipse中的SVN怎么用?
- 级联添加中的no session or session was closed问题
- JXL导出报表出现了java.lang.NoClassDefFoundError: jxl/format/CellFormat怎么解决
- java web开发发展迷惑
- c3p0不释放连接?
- spring和struts整合 使用MappingDispatchAction spring的xml文件如何配置
- 使用javaMail发送邮件错误
- spring security3 最大会话限制的问题
- 又是编码问题。为什么老是乱码啊,晕啊!!大家救救我,是mysql+java+hibernate
- JMS的Queue问题
还有执行Liststudent2()出现的异常是什么?
单看代码是没错误的