First, SQL server2008
Using Sqljdbc4.jar
private static String Driver = "Com.microsoft.sqlserver.jdbc.SQLServerDriver";
Private String Dburl = "jdbc:sqlserver://10.6.2.70:1399; Databasename=projectmanagerdb ";
Access the Database account
Private String DbUser = "sa";
Password to access the database
Private String Dbpass = "7777";
Using jtds-1.3.1
Database driver name
private static String Driver = "Net.sourceforge.jtds.jdbc.Driver";
Database access Path
Private String Dburl = "Jdbc:jtds:sqlserver://localhost/projectmanagerdb";
Access the Database account
Private String DbUser = "sa";
Password to access the database
Private String Dbpass = "";
Second, Mysql
Using Mysql-connector-java-5.1.27-bin.jar
Class.forName ("Com.mysql.jdbc.Driver");
Con=drivermanager.getconnection ("Jdbc:mysql://localhost/ssworkplat", "root", "123321");
JDBC Registration Driver