java连接mysql

来源：互联网发布：网络英文怎么写编辑：程序博客网时间：2024/06/05 12:00

package com.wangchong.study.sql;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class SimpeleJdbc {    /**     * @param args     */    public static void main(String[] args) throws SQLException,            ClassNotFoundException {        // 加载mysql的驱动        Class.forName("com.mysql.jdbc.Driver");        System.out.println("Driver loaded");        // 建立一个连接        Connection connection = DriverManager.getConnection(                "jdbc:mysql://localhost/test", "root", "XXXXXXXXX"); //三个引号内分别是本地数据库，mysql的用户名，密码        System.out.println("Database connected");        // 创建一个Statement        Statement statement = connection.createStatement();        // 定义sql语句        String create_sql = "create table student(id int,name varchar(20),primary key(id))";        String insert_sql = "insert into student values(1,'zhao')";        String insert2_sql = "insert into student values(2,'qian')";        String select_sql = "select * from study";        // 执行sql语句        // 当sql语句会更改数据库时，应该用executeUpdate方法，如果失败，返回一个-1        // 查询用executeQuery方法        int resultset = statement.executeUpdate(create_sql);        System.out.println("success1");        resultset = statement.executeUpdate(insert_sql);        System.out.println("success2");        resultset = statement.executeUpdate(insert2_sql);        System.out.println("success3");        ResultSet rs = statement.executeQuery(select_sql);        System.out.println("success4");        while (rs.next()) {            System.out.println(rs.getString(1) + "\t" + rs.getString(2));        }        // close connection        connection.close();    }}

在之前需要把mysql的驱动jar包导入到项目中，
提供下载地址：http://pan.baidu.com/s/1uPHIA

0 0