java 用jdbc:odbc和 jdbc驱动调用 sqlserver2000 数据库

 

1,jdbc驱动 sqlserver2000

package com.test;
import java.sql.*;

public class test1 {

 
  
 public static void main(String[] args) {
        Connection ct = null; //先定义要用到的对象
        PreparedStatement ps =null;
       ResultSet rs = null;
       try
      {
    
               Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");//加载驱动
              ct = DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;databaseName=test1","sa","sa");//创建连接,test1为数据库名sa为用户名第二个sa为密码
                ps = ct.prepareStatement("select * from goods");//java程序往数据库中发送sql语句
                rs = ps.executeQuery(); //因为是查询调用query()方法,r如果是执行增删查改则用update()方法
               while(rs.next())
              {
                     int goodsId = rs.getInt("goodsId");
                     String goodsName = rs.getString("goodsName");//结果集以此循环读出字段
                        int unitPrice = rs.getInt(3);
                    String categroy = rs.getString("categroy");