使用JDBC操作数据库

使用JDBC操作数据库

创建UpdateJdbc（增删改）

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
public class UpdateJdbc {
    public static void main(String[] args) throws Exception{
        final String DRIVER = "com.mysql.jdbc.Driver";
        final String URL = "jdbc:mysql://localhost:3306/testdb?useUnicode=true&characterEncoding=utf-8&useSSL=true";
        final String USERNAME = "root";
        final String PASSWORD = "123.";
        //加载驱动
        Class.forName(DRIVER);
        //创建连接对象
        Connection con = DriverManager.getConnection(URL,USERNAME,PASSWORD);
        //创建执行对象
        Statement sta = con.createStatement();
        //创建SQL指令
//        String insertSql = "insert into test(testName,age,gender) value('周芷若',18,default)";
//        String deleteSql = "delete from test where testId between 2 and 4";
//        String UpdateSql = " update test set gender='女' WHERE testId=5";
//        String UpdateSql = "UPDATE TEST SET age='25' WHERE testId=1";
        String UpdateSql = "UPDATE TEST SET testName='张佳佳' WHERE testId=1";
//        String insertSql = "insert into test(testName,age,gender) value('西施',18,'女')";
        //执行SQL执行
        int rst = sta.executeUpdate(UpdateSql);
        //根据不同返回值做不同的处理
        if (rst>0){
            System.out.println("新增成功");
        }else{
            System.out.println("新增失败");
        }
    }
}

创建SelectJdbc（查）

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.text.MessageFormat;

public class SelectJdbc {
    public static void main(String[] args) throws Exception{
        final String DRIVER = "com.mysql.jdbc.Driver";
//       192.168.10.68
        final String URL = "jdbc:mysql://localhost:3306/testdb?useUnicode=true&characterEncoding=utf-8&useSSL=true";
        final String USERNAME = "root";
        final String PASSWORD = "123.";
        //加载驱动
        Class.forName(DRIVER);
        //创建连接对象
        Connection con = DriverManager.getConnection(URL,USERNAME,PASSWORD);
        //创建执行对象
        Statement sta = con.createStatement();
        //创建SQL指令
        String selectSql = "select * from test";
        //执行SQL执行
        ResultSet rst = sta.executeQuery(selectSql);
        //展示查询结果  MessageFormat占位符
        while(rst.next()){
            System.out.println(MessageFormat.format("{0}\t{1}\t{2}\t{3}",
                rst.getInt(1),
                rst.getString("testName"),
                rst.getInt(3),
                rst.getString("gender")));
        }
    }
}