数据库连接

mysql 密码mysql


创建用户zyj   密码zyj
创建一个数据库 scott 
    create database scott;
赋予权限
    grant create,select,insert,update,delete on scott.* to zyj@localhost identified by "zyj";


mysql   mysql








对于 Oracle 数据库连接，采用如下形式： 
jdbc:oracle:thin:@localhost:1521:sid


对于 SQLServer 数据库连接，采用如下形式：
jdbc:microsoft:sqlserver//localhost:1433; DatabaseName=sid


对于 MYSQL 数据库连接，采用如下形式：   
jdbc:mysql://localhost:3306/sid






String driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";  
Class.forName(driver); 
String user="sa";     
String password="sa"; 
String urlString = "jdbc:microsoft:sqlserver://"+ip+":1433;DatabaseName=Student";  
dbconn = DriverManager.getConnection(urlString, user, pwd);  








Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();    
String url="jdbc:oracle:thin:@localhost:1521:orcl";   //orcl为数据库的SID     
String user="scott";     
String password="orcl";     
Connection conn= DriverManager.getConnection(url,user,password);   






 
String driver = "com.mysql.jdbc.Driver";  
String url = "jdbc:mysql://127.0.0.1:3306/databaseName"; // URL指向要访问的数据库名databaseName  
String user = "root";  
String password = "mysql";  
Class.forName(driver);  
Connection conn = DriverManager.getConnection(url, user, password);