connectserver.java

该文件中包含有源代码及一部分的文档,该系统是一个小型的英语单词字典的系统.

package english;

import java.sql.*;
import javax.swing.*;

/**
 * <p>Title: Lounger's English</p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: Loungers</p>
 *
 * @author not attributable
 * @version 1.0
 */

class ConnectServer{
   static Connection con=null;
public static boolean conn(String url,String username,String password)
{
   try{
       Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
      }
   catch(Exception e)
   {
       e.printStackTrace();
       return false;
   }
   try
   {
       con=DriverManager.getConnection(url,username,password);
   }
   catch(SQLException e)
   {
       e.printStackTrace();
       return false;
   }
return true;
}
public static boolean close()
{
    try{
        con.close();
        con=null;
       }
    catch(SQLException e)
       {
        return false;
       }
        return true;
        }
public static void main(String args[])
  {
   if(conn("jdbc:odbc:xsgl","sa",""))
     {
       JOptionPane.showMessageDialog(null,"数据库连接成功!");
       close();
     }
   else
      JOptionPane.showMessageDialog(null,"数据库连接失败!");
   }
}