Database connection Statements

Java connection MySQL

　　Protected final static String Db_driver = "Com.mysql.jdbc.Driver";

Protected final String Db_url = "Jdbc:mysql://localhost:3306/melancholy?characterencoding=utf8&usessl=true";

Protected final String Db_user = "a0109151216";

Protected final String db_pwd = "44045d6f";

Class.forName (Db_driver);

Connection = Drivermanager.getconnection (Db_url, Db_user, db_pwd);

Java connection to SQL Server

　　private static final String Db_driver = "Com.microsoft.sqlserver.jdbc.SQLServerDriver";

private static final String Db_url = "Jdbc:sqlserver://localhost:1433;databasename=easybuy";

private static final String Db_user = "sa";

private static final String db_pwd = "sa";

Class.forName (Db_driver);

conn = Drivermanager.getconnection (DB_URL,DB_USER,DB_PWD);

C # connect to MySQL

　　<connectionStrings>

<add name = "Mainconnectionstring"

Connectionstring= "Server=localhost;database=melancholy; Uid=root; Pwd=root.; "

Providername= "System.Data.MySqlClient"/>

</connectionStrings>

C # connecting SQL Server

　　<connectionStrings>

<add name = "Myhomeconnectionstring"

connectionstring= "Data source=.;i Nitial Catalog=hotelmanageex; User Id=sa; Password=sa "

Providername= "System.Data.SqlClient"/>

</connectionStrings>

Database connection Statements