connectsql.java

物业管理系统

package wuYeGuanLi;

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

public class ConnectSql{
  public ConnectSql() {
  }
  public boolean connectSql(String user,String password){//连接数据库
    //String url = "jdbc:odbc:sqlserver://localhost:1433;DatabaseName=wuYe";
    String url = "jdbc:odbc:wuYe";
    //String url = "jdbc:microsoft:sqlserver://localhost:1433; DatabaseName=tuShuGuang";
    //取得连接的url名
    String tempUser =user;//用户名
    String tempPassword =password ;//密码
    Connection con;
    //实例化一个Connection对象
    try {
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      //加载jdbc-odbc桥驱动
    } catch(java.lang.ClassNotFoundException e) {
      System.err.print("ClassNotFoundException: ");
      //加载jdbc-odbc桥错误
      System.err.println(e.getMessage());
      //其他错误
    }
    try {
      con = DriverManager.getConnection(url, user, password);
      //上面的语句关闭声明和连接
    } catch(SQLException ex) {
        System.err.println("SQLException: " + ex.getMessage());
        //显示数据库连接错误或者查询错误
        return false;
    }
    return true;
  }
}