JDBC链接数据库

数据库：MySQL

1、在mysql下建立数据库

2、导入JDBC驱动

3、建立数据库连接类

import java.sql.DriverManager;

import com.mysql.jdbc.Connection;

public class conn {

        public java.sql.Connection getCon() {

                try {

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

                            //连接数据库

                             String url = "jdbc:mysql://localhost/数据库名字？useUnicode=true&charcterEncoding=utf-8";

                             //数据库的用户名和密码

                                String user = "root";

                                String password = "root";

                                Connection conn = (Connection) DriverManager.getConnection(url, user, password);

                                System.out.println(conn.getMetaData().getConnection());

                                return conn;

                              }catch(Exception e) {

                                    e.printStackTrace();

                                    return null;

}

}

}