JDBC Connection MySQL

1, add jar package in Lib;

2, DBHelper class:

public class dbhelper{

Private static final String Driver = "Com.mysql.jdbc.Driver"; Database-driven

Private static final String URL = "Jdbc:mysql://localhost:3306/shopping?useunicon = True&ccharacterencoding=utf-8" ; Connection Address

Private static final String username = "root"; Database user Name

Private static final String password = ""; Database Password

private static Connection coon = null;

The static code block is responsible for loading the driver

static{

try{

Class.forName (driver);

}

catch (Exception ex) {

Ex.printstacktrace ();

}

}

Singleton mode Returns a database connection object

public static Connection getconnection () throws exception{

if (conn = = null) {

Connection con = drivermanager.getconnection (Url,username,password);

Return conn;

}

Return conn;

}

}

JDBC Connection MySQL