Shulou(Shulou.com)05/31 Report--

Today, I will talk to you about how to connect MySQL and SQL Server 2008 databases in Java. Many people may not know much about it. In order to let everyone know more, Xiaobian summarized the following contents for everyone. I hope everyone can gain something according to this article.

1, Java connection mysql database code

Class.forName("com.mysql.jdbc.Driver").newInstance();

Stringurl="jdbc:mysql://localhost:3306/website? characterEncoding=utf8";//website is database name; read Chinese characters in mysql

Stringuser="root";//login mysql username and password

Stringpwd="xuebuyuan.com";

con=DriverManager.getConnection(url,user,pwd);

Java connection sqlserver2008 code

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver").newInstance();

Stringurl="jdbc:sqlserver://localhost:1433;DatabaseName=website";

Stringuser="sa";//Login sqlserver username and password

Stringpwd="xuebuyuan.com";

con=DriverManager.getConnection(url,user,pwd);

After reading the above, do you have any further understanding of how to connect mysql and sqlserver2008 databases in java? If you still want to know more knowledge or related content, please pay attention to the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.