java连接mysql数据库 java连接sql server数据库

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class TestOne {

  private static Connection connection;
  private static Statement statement;
  private static ResultSet result;

  public static void main(String[] args) {
    try {
      //加载jdbc驱动程序
      Class.forName(".mysql.jdbc.Driver");
      //指明主机名（默认为127.0.0.1）和端口号（默认为3306）以及数据库名（必须指定）
      String url = "jdbc:mysql://localhost:3306/test1";
      //与数据库建立连接
      connection =  DriverManager.getConnection(url, "root", "123456");
      //创建一个Statement对象将SQL语句发送到数据库
      statement = connection.createStatement();
      //将查询结果返回给result
      result = statement.executeQuery("select from user");
      while(result.next()){
        System.out.println("name:" + result.getString(1) + "      password:" + result.getString(2));
      }
      connection.close();
      result.close();
      statement.close();
    } catch (ClassNotFoundException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    } catch (SQLException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    }finally{
      try {
        if(connection != null)
          connection.close();
        if(result != null)
          result.close();
        if(statement != null)
          statement.close();
      } catch (SQLException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
      }
    }
  }
}
/
  mysql> select from user;
 +----------+----------+
 | name   | password |
 +----------+----------+
 | lisi   | 123456  |
 | wangwu  | 123456  |
 | zhangsan | 123456  |
 +----------+----------+
 3 rows in set (0.54 sec)
 
 在java中的输出结果
 name:lisi    password:123456
 name:wangwu    password:123456
 name:zhangsan    password:123456
 /

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class TestDemo {

  public static void main(String[] args) {
    String url="jdbc:sqlserver://localhost:1433;DatabaseName=Contellation";
    Connection conn = null;
    try {
      Class.forName(".microsoft.sqlserver.jdbc.SQLServerDriver");
      conn = DriverManager.getConnection(url, "sa", "");
      Statement statement=conn.createStatement();
      ResultSet rs = statement.executeQuery("select  from dbo.登陆表 ");
      while(rs.next()){
        System.out.println("用户名" + rs.getString(1) + "  密码" + rs.getString(2));
      }
      conn.close();
    } catch (ClassNotFoundException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    } catch (SQLException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    } 
  }
}
/
  java中的输出结果
  用户名张三  密码123456
 用户名李四  密码111111
 用户名王五  密码123654
 用户名王延暾  密码0123456789
 用户名曾安新 密码123456
 /