数据库的连接语句

一：Mysql的数据库连接语句
   
 Class.forName("com.mysql.jdbc.Driver");
     Connection con = DriverManager.getConnection.      

 ("jdbc:mysql://localhost/bookinfo","root","123");
     Statement st = con.createStatement();
     String sql = "select * from book";
     ResultSet rs = st.executeQuery(sql);
       while(rs.next()){
      }

二：sqlserver的数据库连接语句
 
 Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
     Connection con = DriverManager.getConnection.            

 ("jdbc:microsoft:sqlserver://localhost:1433;databaseName=bookinfo","sa","123");
 
 
   PreparedStatement ps = con.prepareStatement("select * from book");
 
 
   ResultSet rs = ps.executeQuery();
 
 
   while(rs.next()){
 
    out.println(rs.getString(2));
 
  }

三：sqlserver2005的数据库连接语句
   
 Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
     Connection con = DriverManager.getConnection.            

("jdbc:sqlserver://localhost:1433;databaseName=bookinfo","sa","123");
 
 
   PreparedStatement ps = con.prepareStatement("select * from book");
 
 
   ResultSet rs = ps.executeQuery();
 
 
   while(rs.next()){
 
    out.println(rs.getString(2));
 
  }

 四：oracle的数据库连接语句

 jdbc:oracle:thin:@<server>[:<1521>]:<database_name>
  Class.forName("oracle.jdbc.driver.OracleDriver");
     Connection con = DriverManager.getConnection.            

  ("jdbc:oracle:thin:@localhost:1521:bookinfo","zhangsan","123");
 
 
   PreparedStatement ps = con.prepareStatement("select * from book");
 
 
   ResultSet rs = ps.executeQuery();
 
 
   while(rs.next()){
 
    out.println(rs.getString(2));
 
  }