Java connection to MySQL database using JDBC method and example "graphic description"

JDBC (Java Data Base Connectivity,java database connection) is a Java API for executing SQL statements that provides unified access to a variety of relational databases, consisting of a set of classes and interfaces written in the Java language. JDBC provides a benchmark to build more advanced tools and interfaces that enable database developers to write database applications.

If you want to use the database to add the driver of the database, different databases have not the driver, here is not explained, the method of adding Jar program driver package is not explained here,

Another article contains an introduction to Http://www.cnblogs.com/taoweiji/archive/2012/12/11/2812295.html

Here is an example of the MySQL database connection, the other database method is similar.

/** * @author ：陶伟基 ，微博：http://weibo.com/taoandtao * @date ：2012/12/11 * @place：广州大学华软软件学院 */importjava.sql.DriverManager;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.sql.Connection;importjava.sql.Statement;publicclassMysqlDemo {    publicstaticvoidmain(String[] args) throwsException {        Connection conn = null;        String sql;        // MySQL的JDBC URL编写方式：jdbc:mysql://主机名称：连接端口/数据库的名称?参数=值        // 避免中文乱码要指定useUnicode和characterEncoding        // 执行数据库操作之前要在数据库管理系统上创建一个数据库，名字自己定，        // 下面语句之前就要先创建javademo数据库        String url = "jdbc:mysql://localhost:3306/javademo?"                + "user=root&password=root&useUnicode=true&characterEncoding=UTF8";        try{            // 之所以要使用下面这条语句，是因为要使用MySQL的驱动，所以我们要把它驱动起来，            // 可以通过Class.forName把它加载进去，也可以通过初始化来驱动起来，下面三种形式都可以            Class.forName("com.mysql.jdbc.Driver");// 动态加载mysql驱动            // or:            // com.mysql.jdbc.Driver driver = new com.mysql.jdbc.Driver();            // or：            // new com.mysql.jdbc.Driver();            System.out.println("成功加载MySQL驱动程序");            // 一个Connection代表一个数据库连接            conn = DriverManager.getConnection(url);            // Statement里面带有很多方法，比如executeUpdate可以实现插入，更新和删除等            Statement stmt = conn.createStatement();            sql = "create table student(NO char(20),name varchar(20),primary key(NO))";            int result = stmt.executeUpdate(sql);// executeUpdate语句会返回一个受影响的行数，如果返回-1就没有成功            if(result != -1) {                System.out.println("创建数据表成功");                sql = "insert into student(NO,name) values(‘2012001‘,‘陶伟基‘)";                result = stmt.executeUpdate(sql);                sql = "insert into student(NO,name) values(‘2012002‘,‘周小俊‘)";                result = stmt.executeUpdate(sql);                sql = "select * from student";                ResultSet rs = stmt.executeQuery(sql);// executeQuery会返回结果的集合，否则返回空值                System.out.println("学号\t姓名");                while(rs.next()) {                    System.out                            .println(rs.getString(1) + "\t"+ rs.getString(2));// 入如果返回的是int类型可以用getInt()                }            }        } catch(SQLException e) {            System.out.println("MySQL操作错误");            e.printStackTrace();        } catch(Exception e) {            e.printStackTrace();        } finally {            conn.close();        }    }}

Java connection to MySQL database using JDBC method and example "graphic description"