Java连接MySql数据库实现增删改查（非Dao模式）

Java连接MySql数据库实现增删改查（非Dao）

注：Dao模式增删改查请查看我的另一篇博客，此篇为简单操作数据库增删改查，适用新手
注：连接MySql需要导入相应jar包：mysql-connector-java-8.0.18.jar

增：

public class TestOne {
	public static void main(String[] args) throws Exception {

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

		Connection conn = DriverManager.getConnection(
				"jdbc:mysql:///one?useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC", "root", "123456");

		Statement sm = conn.createStatement();

		String sql = "insert into tuser values('dd',18)";
		int r = sm.executeUpdate(sql);// 更新数据
		if (r > 0) {
			System.out.println("添加成功！");
		} else {
			System.out.println("添加失败！");
		}
		System.out.println(conn);

	}
}

删：

public class TestOne {
	public static void main(String[] args) throws Exception {

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

		Connection conn = DriverManager.getConnection(
				"jdbc:mysql:///one?useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC", "root", "123456");

		Statement sm = conn.createStatement();
		String sql = "delete from user where username = 'a'";

		int r = sm.executeUpdate(sql);// 更新数据
		if (r > 0) {
			System.out.println("失败！");
		} else {
			System.out.println("成功！");
		}
		System.out.println(conn);

	}
}

改：

public class TestOne {
	public static void main(String[] args) throws Exception {

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

		Connection conn = DriverManager.getConnection(
				"jdbc:mysql:///one?useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC", "root", "123456");

		Statement sm = conn.createStatement();
		String sql = "update user set username ='ddd' where username='123'";

		int r = sm.executeUpdate(sql);// 更新数据
		if (r > 0) {
			System.out.println("成功！");
		} else {
			System.out.println("失败！");
		}
		System.out.println(conn);

	}
}

查：

public class TestOne {
	public static void main(String[] args) throws Exception {

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

		Connection conn = DriverManager.getConnection(
				"jdbc:mysql:///one?useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC", "root", "123456");

		Statement sm = conn.createStatement();

		String sql = "select * from user where username = 'a' and password = '2'";

		ResultSet rs = null;
		rs = sm.executeQuery(sql);
		if (rs.next()) {
			System.out.println("成功！");
		} else {
			System.out.println("失败！");
		}
		System.out.println(conn);

	}
}

以上就是简单的使用java对MySql数据库进行增删改查，有错误请指出。