利用JTDS连接数据库并操作示例

               

/**
 * 利用JTDS连接数据库并操作,来源www.sourceforge.net
 */
import java.sql.*;

import net.sourceforge.*;
import net.sourceforge.jtds.jdbc.Driver;

/**
 * 利用JTDS连接数据库并操作
 */
public class

test
{
  public test()
  {
  }

  public static void main(String[] args)
  {
    try
    {
      Class.forName("net.sourceforge.jtds.jdbc.Driver");
      Connection con;
      con =
          DriverManager.getConnection("jdbc:jtds:sqlserver://172.16.16.87;DatabaseName=flb_test",
                                      "sa", "123");
      Statement stmt = con.createStatement();
      //stmt.execute("drop table test");
      //stmt.e