java操作mysql

---

1. 下载java的mysql驱动

mysql-connector-java-5.1.26-bin.jar 下载

2. 导入工程

在工程的树状文件结构里右击以上jar文件选择build path再选择add to build path

3. 代码如下

import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class JavaMysqlConnection{

    public static void main(String[] args){
        //variables used to operate the mysql database
        Connection connection = null;
        Statement statement = null;
        String sql = null;
        ResultSet resultSet = null;
        //the information of mysql database
        String user = "root";
        String password = "root";
        String url = "jdbc:mysql://localhost/test";
        //look up the mysql diriver , is it useful ?
        try{
            Class.forName("com.mysql.jdbc.Driver");
        }catch(ClassNotFoundException e){
            System.out.println("mysql driver is not ready ...");
            e.printStackTrace();
        }
        // open a mysql connection to java application
        try{
            connection = DriverManager.getConnection(url,user,password);//url,user,password
        }catch(SQLException e){
            System.out.println("there is sql exception when connecting ...");
            e.printStackTrace();
        }
        // operate the mysql
        try{
            statement = connection.createStatement();
            sql = "select * from test";//sql to execute
            resultSet = statement.executeQuery(sql);
            while(resultSet.next()){
                System.out.println("id:"+resultSet.getInt("id")+"\tname:"+resultSet.getString("name")+"\tage:"+resultSet.getInt("age")+"\tdescription:"+resultSet.getString("description"));
            }
        }catch(SQLException e){
            System.out.println("there is sql exception ...");
            e.printStackTrace();
        }
        // close the connection
        try{
        	if(resultSet!=null){
        		resultSet.close();
        		resultSet = null;
        	}
        	if(statement!=null){
        		statement.close();
        		statement = null;
        	}
        	if(connection!=null){
        		connection.close();
        		connection = null;
        	}
        }catch(Exception e){
        	System.out.println("something was wrong when closing the connection to mysql ...");
        	e.printStackTrace();
        }

        System.out.println("java connection to mysql is ending...");
    }
}

4. insert

sql = "insert into test(id, name, age, description) values(88,'sofia', 19, 'this is sofia ...')";
statement.executeUpdate(sql);

5. update

sql = "update test set name='tony' where id>6";
statement.executeUpdate(sql);

6. delete

sql = "delete from test where name='tony'";
statement.execute(sql);

7. 参考

波纹的博客

赏

×

纯属好玩

扫码打赏，你说多少就多少

打开支付宝扫一扫，即可进行扫码打赏哦