手头一时没有JDBC的连接的代码，那位有现成的给贴一份吧！

Question

sql server :import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.DriverManager;
public class SQLConnection {
  private static   SQLConnection _instance=null;
  private static   Connection conn=null;
  private static   Statement st=null;
  private static String username="sa";
  private static String userpwd="";
  private final String url="jdbc:microsoft:sqlserver://HLNOTEBOOK:1433;DatabaseName=TestDB";
  public static SQLConnection getInstance(){
    if(_instance==null||conn==null||st==null){
      _instance=new SQLConnection();
    }
    return _instance;
  }
  public SQLConnection() {
    try{
      Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
      conn = DriverManager.getConnection(
              url,username ,userpwd);
      st = conn.createStatement();
      System.out.println("建立连接成功");
         }catch(SQLException e){
      e.printStackTrace();
    }catch(Exception e2){
      e2.printStackTrace();
    }
  }
  public static void main(String [] args){
    SQLConnection co=SQLConnection.getInstance();
    String sql = "select * from JAVATEST";
    try
    {
         ResultSet rs=st.executeQuery(sql);      while(rs.next())
      {
        System.out.println(rs.getString("BOOK_ID"));
      }
        rs.close();
      st.close();
    }
    catch(Exception er)
    {
      er.printStackTrace(System.out);
    }
  }
}

Answer 1

odbc:import java.io.*;
import java.sql.*;
class BookQuery
  {
    public static void main(String args[])
      {
        try
         {
           Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
         }
        catch(ClassNotFoundException ce)
          {
            System.out.println("SQLException: "+ce.getMessage());
          }
        try
          {
            Connection con=DriverManager.getConnection("jdbc:odbc:bookbase");
            Statement stmt=con.createStatement();
            ResultSet rs=stmt.executeQuery("select * from JAVATEST");
            while(rs.next())
              {
                System.out.println(
                        "书号: "+rs.getInt(1)+"\t"+
                        "书名: "+rs.getString(2)+"\t"+
                        "作者: "+rs.getString(3)+"\t"+
                        "单价: "+rs.getFloat(4));
              }
           stmt.close();
           con.close();
          }
        catch(SQLException e)
          {
            System.out.println("SQLException: "+e.getMessage());
           }
       }
   }

Answer 2

http://expert.csdn.net/Expert/topic/2077/2077183.xml?temp=.8751642
自己去看吧！

Answer 3

package beans;
import java.sql.*;public class xmgl 
{
    String sDBDriver="com.inet.tds.TdsDriver";
    String sConnStr="jdbc:inetdae7:localhost?database=xmgl&charset=gb2312";
public String user;
public String password;
    Connection conn=null;
    ResultSet rs=null;    public void setLoginuser(String user)
{
this.user=user;
}

public void setLoginpassword(String password)
{
this.password=password;
}
    public xmgl() {
        try {
              Class.forName(sDBDriver);
            }
        catch (java.lang.ClassNotFoundException e)
        {
               System.err.println("homeworkbean():"+e.getMessage());
         }
     }
    
    public ResultSet executeQuery(String sql)
    {
        rs=null;
        try {
               conn=DriverManager.getConnection(sConnStr,user,password);
               Statement stmt=conn.createStatement();
               rs=stmt.executeQuery(sql);
   stmt.close();
            }
         catch (SQLException ex)
         {
             System.err.println("aq.executeQuery:"+ex.getMessage());
          }
         return rs;
     }    public void executeInsert(String sql)
    {
         try {
               conn=DriverManager.getConnection(sConnStr,user,password);
               Statement stmt=conn.createStatement();
               stmt.executeUpdate(sql);
    stmt.close();
  
            }
         catch (SQLException ex)
         {
             System.err.println("aq.executeInsert:"+ex.getMessage());
          }
      }public void executeUpdate(String sql)
    {
         try {
               conn=DriverManager.getConnection(sConnStr,user,password);
               Statement stmt=conn.createStatement();
               stmt.executeUpdate(sql);
   stmt.close();
            }
         catch (SQLException ex)
         {
             System.err.println("aq.executeUpdate:"+ex.getMessage());
          }
      }
    public void executeDelete(String sql)
    {
         try {
               conn=DriverManager.getConnection(sConnStr,user,password);
               Statement stmt=conn.createStatement();
               stmt.executeUpdate(sql);
    stmt.close();
            }
         catch (SQLException ex)
         {
             System.err.println("aq.executeDelete:"+ex.getMessage());
          }
      }
   public void rsclose()
{
   try{
       rs.close();
   }
      catch (SQLException ex)
         {
             System.err.println("aq.executeQuery:"+ex.getMessage());
          }
}
public void connclose()
{
try{
conn.close();
}
catch (SQLException ex)
         {
             System.err.println("aq.executeQuery:"+ex.getMessage());
          }
}
}