データベースに接続するには


1.       
Class.forName("oracle.jdbc.driver.OracleDriver"); 
2. 
     
Connection conn = DriverMananger.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:xe","   ","  "); 
3     
4        
/    ,     mysql-connector-java-3.1.12.zip      
//mysql-connector-java-3.1.12-bin.jar      
import java.sql.*;
public class DbUtil {
   public static void main(String[] args){
       String driver = "com.mysql.jdbc.Driver";     //  
       String url = "jdbc:MySql://localhost/login"; //   URL
       String user="root";                          //      
       String password = "mysql";                   //     
 try {
 Class.forName(driver);
 Connection dcon = DriverManager.getConnection(url,user,password);
 String sql = "select * from login;";
 Statement stmt = dcon.createStatement();
    ResultSet rs = stmt.executeQuery(sql);
      while(rs.next())
        {
     System.out.print("id:"+rs.getInt("id")+",  :"+rs.getString("name"));
        }
    }
  catch (Exception e)
   {
 e.printStackTrace();
 }
}}