dbconnect.java

java 通用连接 MS SQL 的写法

import java.sql.*;
import java.util.*;
import java.io.*;
public class  DBconnect 
{

  private String JDBCDriver = "sun.jdbc.odbc.JdbcOdbcDriver";   
  private String Connection = "jdbc:odbc:onkel_bas";
  private String user_name = "sa";
  private String user_pass = "";
   Connection con;
   Statement stmt;


public boolean connectDB () {
   boolean temp = false ;
  try
{
	Class.forName(JDBCDriver).newInstance();
      con = DriverManager.getConnection(Connection,user_name , user_pass);
      stmt = con.createStatement();
      temp = true ;
}
catch (Exception e)
{

	System.out.println(e) ;
}

   return  temp ;
}

public Statement getDBStatement () {
   return stmt ;

}

public void closeDB () {

	try
	{
	stmt.close() ;
    con.close() ;
	}
	catch (Exception e)
	{
	}

}
	public static void main(String[] args) 
	{
	
	}
}