jdbc连接sqlserver2000

/*
 * 创建日期 2009-2-20
 *
 * 更改所生成文件模板为
 * 窗口 > 首选项 > Java > 代码生成 > 代码和注释
 */
package com.czmcc.democenter.common.sms;

import java.sql.*;
import java.util.ArrayList;
import java.util.List;
import java.util.PropertyResourceBundle;
import java.util.ResourceBundle;

/**
 * @author wh
 *
 * 更改所生成类型注释的模板为
 * 窗口 > 首选项 > Java > 代码生成 > 代码和注释
 */
public class SMSLogic {
 private Connection conn = null;
 private PreparedStatement stmt = null;
 private ResultSet rs = null;
 private String dbUrl = null;
 private String dbUsr = null;
 private String dbPwd = null;
 
 public SMSLogic(){
   dbUrl ="jdbc:microsoft:sqlserver://192.168.0.21:1433;DatabaseName=note_sms";
   dbUsr=sa;
   dbPwd=infox1eies2sps3was4!;
 }
 
 public Connection getConnection(){
  System.out.println("正在连接数据库.....................");
  try {
   Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
   conn = DriverManager.getConnection(dbUrl, dbUsr, dbPwd);
   System.out.println("成功连接数据库.....................");
  } catch (Exception e) {
   System.out.println("无法连接SQL SERVER数据库.....................");
   e.printStackTrace();
  }
  return conn;
 }
 
 public void DBCleanUp(ResultSet rs , PreparedStatement stmt , Connection conn) {
   try{
      if (rs != null)  rs.close();
   }catch(Exception e){
    e.printStackTrace();
   }

   try{
      if (stmt != null)  stmt.close();
   }catch(Exception e){
    e.printStackTrace();
   }
   try{
      if (conn != null)  conn.close();
   }catch(Exception e){
    e.printStackTrace();
   }
 }
 public int querySMSNum(){
  int i = 0;
  conn = getConnection();
  try {
   //String sql = "insert into AOR_PHOTOFILE(PHOTOFILEID, FILENAME, FILEDESC, PHOTOTYPE, STATUS, CREATEDATE) values(?,?,?,?,?,current date)";
   String sql = "select count(*) SMSCount from notetable";
   stmt = conn.prepareStatement(sql);
   rs = stmt.executeQuery();
   while(rs.next()){ 
   i =  rs.getInt("SMSCount");
   }
   System.out.println("成功查询"+i+"条短信.....................");
  } catch (SQLException e) {
   e.printStackTrace();
  }finally{
   DBCleanUp(rs,stmt,conn);
  }
  return i;
 }
 public void deleteSMS(){
  conn = getConnection();
  try {
   String sql = "delete  from  notetable";
   stmt = conn.prepareStatement(sql);
   stmt.executeUpdate();
   conn.commit();
   System.out.println(".........成功删除短信...........");
  } catch (SQLException e) {
   e.printStackTrace();
  }finally{
   DBCleanUp(rs,stmt,conn);
  }
 
 }
 public void deleteSMS(int id){
   conn = getConnection();
   try {
    String sql = "delete  from  notetable where ID = ?";
    stmt = conn.prepareStatement(sql);
    stmt.setInt(1,id);
    stmt.executeUpdate();
    conn.commit();
    System.out.println(".........成功删除上行短信...........");
   } catch (SQLException e) {
    e.printStackTrace();
   }finally{
    DBCleanUp(rs,stmt,conn);
   }
 
  }
 //保存1条短信到数据库
 public void SaveSMS(String phone,String content,String interfaceno,String type){
  conn = getConnection();
  try {
   String sql = "insert into notetable(phone,content,interfaceno,TYPE) values(?,?,?,?)";
   stmt = conn.prepareStatement(sql);
   stmt.setString(1,phone);
   stmt.setString(2,content);
   stmt.setString(3,interfaceno);
   stmt.setString(4,type);
   stmt.executeUpdate();
   conn.commit();
   System.out.println(".........成功插入短信...........");
   System.out.println("手机号码="+phone);
   System.out.println("短信内容="+content);
   System.out.println("服务端口号="+interfaceno);
  } catch (SQLException e) {
   e.printStackTrace();
  }finally{
   DBCleanUp(rs,stmt,conn);
  }
 
 }
 
 //查询上行短信
 public List queryReceviedSMS(String type){
   List list = new ArrayList();
   SMSInfo smsinfo = null;
   int i = 0;
   conn = getConnection();
   if(conn!=null){
   try {
    //String sql = "insert into AOR_PHOTOFILE(PHOTOFILEID, FILENAME, FILEDESC, PHOTOTYPE, STATUS, CREATEDATE) values(?,?,?,?,?,current date)";
    String sql = "select *  from notetable where TYPE = ? ";
    stmt = conn.prepareStatement(sql);
    stmt.setString(1,type);
    rs = stmt.executeQuery();
    while(rs.next()){
    i++;
    int id = rs.getInt("ID");
    System.out.println("id..."+id);
    String phone  =  rs.getString("PHONE");
    String content  =  rs.getString("CONTENT");
    String interfaceno  =  rs.getString("INTERFACENO");
    smsinfo = new SMSInfo();
    smsinfo.setId(id);
    smsinfo.setPhone(phone);
    smsinfo.setContent(content);
    smsinfo.setInterfaceno(interfaceno);
    list.add(smsinfo);
    }
    
    System.out.println("成功查询"+i+"条上行短信.....................");
   } catch (SQLException e) {
    e.printStackTrace();
   }finally{
    DBCleanUp(rs,stmt,conn);
   }
   }
   return list;
 }
 
 public static void main(String[] args) {
  SMSLogic sl = new SMSLogic(); 
//  sl.deleteSMS();
 sl.SaveSMS("13831741057","1","106573175064615","0");
 sl.SaveSMS("13831741057","1","106573175064616","0");
//  sl.querySMSNum();
        System.out.println("A="+SMSInfo.Acartoon);
  System.out.println("B="+SMSInfo.Bcartoon);
 }
}