jdbc-odbc-bridge连接sql2000.txt

这是一个桥连sql2000的例子 内容详尽

import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import sun.jdbc.odbc.JdbcOdbcDriver;
public class jdbc  //定义主类
{public static void main(String args[])
  {GUI gui=new GUI();  //创建类GUI的对象
   gui.pack();  //装载执行GUI类
  }
}
class GUI extends Frame
implements ActionListener
{ TextArea text; Panel panel; TextField sno; Button btn;
GUI()     //构造方法
{ super("物资情况查询");setLayout(new BorderLayout());
 setBackground(Color.cyan);
 setVisible(true);text=new TextArea();
 btn=new Button("查询"); sno=new TextField(16);
 panel=new Panel();
 panel.add(new Label("输入被查询的物资编号："));
 panel.add(sno); panel.add(btn);
 add("North",panel); add(text,"Center");
    text.setEditable(false);btn.addActionListener(this);
 addWindowListener(new WindowAdapter()
 { public void windowClosing(WindowEvent e)
  { setVisible(false); System.exit(0);
    }
   });
  }
  public void actionPerformed(ActionEvent e)    {
   if(e.getSource()==btn)     //当用户按下查询按钮时
   { text.setText("查询结果"+"\n");    //显示提示信息
    try
    { Liststudent();  }
    catch(SQLException ee) { ee.printStackTrace();}
   }
  }
  public void Liststudent() throws SQLException  //针对数据库的操作
  { String bh,mc,xh,lb,dw,sj;
   int sl;  float dj,je;
   try
   { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); }
   catch(ClassNotFoundException e) {e.printStackTrace();}
   Connection con=DriverManager.getConnection("jdbc:odbc:wzgl","sa","");
   Statement sql=con.createStatement();  //创建Statement对象
   ResultSet rs=sql.executeQuery("select * from wuzi");
   while(rs.next())   //输出被查询的情况
   { bh=rs.getString("物资编号");mc=rs.getString("物资名称");
     xh=rs.getString("规格型号");lb=rs.getString("类别");
              dw=rs.getString("计量单位");sl=rs.getInt("数量");
              dj=rs.getFloat("单价"); je=rs.getFloat("金额");
     sj=rs.getDate("时间").toString();
     if(bh.trim().equals(sno.getText().trim()))
             {text.append('\n'+"物资编号"+" "+"物资名称"+"   "+"规格型号"+"     "+"类别"+"     "+"计量单位"+"     "+"数量"+" "+"单价"+" "+"金额"+"   "+"时间"+"\n");
                text.append("\n"+bh+" "+mc+" "+xh+" "+lb+" "+dw+" "+sl+" "+dj+" "+je+" "+sj+" "+"\n"); }}

  }}

保存为jdbc.java


二。

启动sql2000，将下面教本在查询分析器中执行 

create database mydata
go
use mydata
go

CREATE TABLE [wuzi] (
 [物资编号] [varchar] (3) COLLATE Chinese_PRC_CI_AS NULL ,
 [物资名称] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
 [规格型号] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
 [类别] [varchar] (8) COLLATE Chinese_PRC_CI_AS NULL ,
 [计量单位] [varchar] (8) COLLATE Chinese_PRC_CI_AS NULL ,
 [数量] [int] NULL ,
 [单价] [float] NULL ,
 [金额] [float] NULL ,
 [时间] [datetime] NULL 
) ON [PRIMARY]
GO
insert into wuzi values('001','peanut','#5','-5*3','斤',56,20,1120,2005-12-9)
go
insert into wuzi values('002','apple','*8','-9$6','斤',56,20,1120,2005-12-9)
go
insert into wuzi values('003','potato','#5','-5*3','斤',56,20,1120,2005-12-9)
go
insert into wuzi values('004','apple','*8','-9$6','斤',56,20,1120,2005-12-9)
go
insert into wuzi values('005','orage','#5','-5*3','斤',56,20,1120,2005-12-9)
go
insert into wuzi values('006','banana','*8','-9$6','斤',56,20,1120,2005-12-9)
go
select * from wuzi;
go


三。配置相应数据源：

--管理工具->ODBC数据源-〉系统DSN-〉添加-〉 Sql server-〉数据源：wzgl 服务器：（local）-〉
--使用网络登录Id或winnt验证-〉更改默认的数据库为：mydata-〉下一步-〉完成-〉测试数据源