>(转载）利用Java访问SQL Server2000数据库</P>><BR> <BR> 运行程序等其他技术问题，请看这里 ： <a href="http://www.now.net.cn/support/" target="_blank" >http://www.now.net.cn/support/</A> <BR> <BR> 将代码保存在jdbc.java文件中 <BR> <BR> import java.awt.*;import java.awt.event.*;import java.sql.*; <BR> public class jdbc //定义主类 <BR> {public static void main(String args[]) <BR> {GUI gui=new GUI(); //创建类GUI的对象 <BR> gui.pack(); //装载执行GUI类 <BR> } <BR> } <BR> class GUI extends Frame implements Action Listener <BR> { TextArea text; Panel panel; TextField sno; Button btn; <BR> GUI() //构造方法 <BR> { super("物资情况查询");setLayout(new BorderLayout()); <BR> setBackground(Color.cyan); <BR> setVisible(true);text=new TextArea(); <BR> btn=new Button("查询"); sno=new TextField(16); <BR> panel=new Panel(); <BR> panel.add(new Label("输入被查询的物资编号：")); <BR> panel.add(sno); panel.add(btn); <BR> add("North",panel); add(text,"Center"); <BR> text.setEditable(false);btn.addActionListener(this); <BR> addWindowListener(new WindowAdapter() <BR> { public void windowClosing(WindowEvent e) <BR> { setVisible(false); System.exit(0); <BR> } <BR> }); <BR> } <BR> public void actionPerformed(ActionEvent e) { <BR> if(e.getSource()==btn) //当用户按下查询按钮时 <BR> { text.setText("查询结果“+”\n’); //显示提示信息 <BR> try <BR> { Liststudent(); } <BR> catch(SQLException ee) { } <BR> } <BR> } <BR> public void Liststudent() throws SQLException //针对数据库的操作 <BR> { String bh,mc,xh,lb,dw,sj; <BR> int sl; float dj,je; <BR> try <BR> { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); } <BR> catch(ClassNotFoundException e) { } <BR> Connection con=DriverManager.getConnection("jdbc
dbc:wzgl"); <BR> Statement sql=con.createStatement(); //创建Statement对象 <BR> ResultSet rs=sql.executeQuery("select * from wuzi"); <BR> while(rs.next()) //输出被查询的情况 <BR> { bh=rs.getString("物资编号");mc=rs.getString("物资名称"); <BR> xh=rs.getString("规格型号");lb=rs.getString("类别"); <BR> dw=rs.getString("计量单位");sl=rs.getInt("数量"); <BR> dj=rs.getFloat("单价"); je=rs.getFloat("金额"); <BR> sj=rs.getDate("时间").toString(); <BR> if(bh.trim().equals(sno.getText().trim())) <BR> {text.append(\n+"物资编号"+" "+"物资名称"+" "+"规格型号"+" "+"类别"+" "+"计量单位"+" "+"数量"+" "+"单价"+" "+"金额"+" "+"时间"+\n); <BR> text.append(\n+bh+" "+mc+" "+xh+" "+lb+" "+dw+" "+sl+" "+dj+" "+je+" "+sj+" "+\n); } <BR> } <BR> } <BR> } <BR> <BR> <BR> ----------------------------------------------------------------------------------- <BR> 哪位需要域名注册，虚拟主机 支持 asp asp.net java php的都有！ Q我了：168075865 ~~ </P> ^$ \2 G3 K8 l> 有新款虚拟主机呀----http://www.now.net.cn/host<BR></P>| 欢迎光临 数学建模社区-数学中国 (http://www.madio.net/) | Powered by Discuz! X2.5 |