java-jdbc小项目实现增删改查

最新推荐文章于 2023-07-06 23:32:14 发布

有点难！

最新推荐文章于 2023-07-06 23:32:14 发布

阅读量857

点赞数 2

分类专栏： javase基础

本文链接：https://blog.csdn.net/toomemetoo/article/details/113414918

版权

javase基础专栏收录该内容

49 篇文章 0 订阅

订阅专栏

建库

--使用数据库db_phone
USE db_phone;
--创建表mobile,有以下字段
--id ,int ,主键，自增长
--brand(品牌) ,字符串，非空
--model(型号),字符串，非空
--price(价格),浮点，非空
--count(数量),整型，非空
--vresion(版本),字符串，非空
CREATE TABLE Mobile(
id INT AUTO_INCREMENT PRIMARY KEY,
brand VARCHAR(50) NOT NULL,
model VARCHAR(50) NOT NULL,
price DOUBLE NOT NULL,
COUNT INT NOT NULL,
VERSION VARCHAR(50) NOT NULL
);
--看下表的结构
DESC mobile;
--表中插入数据
INSERT INTO mobile VALUES(
 1,'华为','mate40',8999,1000,'国行版'
);

INSERT INTO mobile VALUES(
 2,'OPPO','RENO5',3999,3000,'国行版'
);

INSERT INTO mobile VALUES(
 3,'vivo','nex3',4999,2000,'国行版'
);

INSERT INTO mobile VALUES(
 DEFAULT,'mi','cc9',2999,6000,'国行版'
);

INSERT INTO mobile VALUES(
 DEFAULT,'apple','apple11',5999,4000,'美版'
);
--查看表中数据
SELECT * FROM mobile;

准备工作

在ecpilse中，创建Javaproject名为moblieProgram。
新建一个lib文件夹，导入jar包。

第三步：在mobileProgram右击—>properties—>java build path—>libraries—>add ecternal Jars…导入jar包—>apply and close。
在这里插入图片描述

独立增删改查（最简单版，好理解但是不灵活）

这里的增删改查都写死了
查询

package mobileProgram;

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



public class MobileDemo_1 {
	public static void main(String [] args) throws Exception {
		Class.forName("com.mysql.jdbc.Driver");
		
		String url = "jdbc:mysql://localhost:3306/db_phone";//这个只连接库
		String user = "root";
		String password = "12345";
		Connection conn = DriverManager.getConnection(url, user, password);
		
		Statement state = conn.createStatement();
		
		String sql = "select * from mobile";
		ResultSet res = state.executeQuery(sql);
		System.out.println("id" + "	" + "brand" + "	" + 
		"model" + "		" + "price" + "		" + "count" + "		" + "version");
		while(res.next()) {
			int id = res.getInt("id");
			String brand = res.getString("brand");
			String model = res.getString("model");
			double price = res.getDouble("price");
			int count = res.getInt("count");
			String version = res.getString("version");
			System.out.println(id +"	"+brand+"	"+model +"   	"+price +"		"+count +"		"+version);
		}
		
		res.close();
		state.close();
		conn.close();
	}
	
}

添加

package mobileProgram;
//这个是插入一条数据
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;



public class MobileDemo_3 {
	public static void main(String [] args) throws Exception {
		Class.forName("com.mysql.jdbc.Driver");
		
		String url = "jdbc:mysql://localhost:3306/db_phone";//这个只连接库
		String user = "root";
		String password = "12345";
		Connection conn = DriverManager.getConnection(url, user, password);
		
		Statement state = conn.createStatement();
		
		String sql = "insert into mobile values(default , '诺基亚','k898',4899,4500,'国航版')";
		int i = state.executeUpdate(sql);
		if(i == 1) {
			System.out.println("添加成功");
		}else {
			System.out.println("添加失败");
		}
		state.close();
		conn.close();
	}
	
}

删除

package mobileProgram;
//这个是删除一条数据数据
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;



public class MobileDemo_2 {
	public static void main(String [] args) throws Exception {
		Class.forName("com.mysql.jdbc.Driver");
		
		String url = "jdbc:mysql://localhost:3306/db_phone";//这个只连接库
		String user = "root";
		String password = "12345";
		Connection conn = DriverManager.getConnection(url, user, password);
		
		Statement state = conn.createStatement();
		
		String sql = "delete from mobile where price = '4899' ";
		int i = state.executeUpdate(sql);
		if(i == 1) {
			System.out.println("删除成功");
		}else {
			System.out.println("删除失败");
		}
		
		state.close();
		conn.close();
	}
	
}

修改

package mobileProgram;
//这个是修改数据
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;



public class MobileDemo_4 {
	public static void main(String [] args) throws Exception {
		Class.forName("com.mysql.jdbc.Driver");
		
		String url = "jdbc:mysql://localhost:3306/db_phone";//这个只连接库
		String user = "root";
		String password = "12345";
		Connection conn = DriverManager.getConnection(url, user, password);
		
		Statement state = conn.createStatement();
		
		String sql = "UPDATE mobile SET brand = '黑鲨' WHERE price = 4899;";
		int i = state.executeUpdate(sql);
		if(i == 1) {
			System.out.println("修改成功");
		}else {
			System.out.println("修改失败");
		}
		state.close();
		conn.close();
	}
	
}

整合版增删改查（只有一个java文件，但是代码冗余）

package mobileProgram02;

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

public class MobileDemo_5 {
	public static void main(String [] args) {
		//query();
		//insert();
		//modify();
		//delete();
	}
	//查询
	public static void query() {
		try {
			Class.forName("com.mysql.jdbc.Driver");
			
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}
		String url = "jdbc:mysql://localhost:3306/db_phone";//这个只连接库
		String user = "root";
		String password = "12345";
		Connection conn = null;
		Statement state = null;
		ResultSet res = null;
		String sql = "select * from mobile";
		try {
			conn = DriverManager.getConnection(url, user, password);
			state = conn.createStatement();
			res = state.executeQuery(sql);
		} catch (SQLException e) {
			e.printStackTrace();
		}
		
		System.out.println("id" + "	" + "brand" + "	" + 
		"model" + "		" + "price" + "		" + "count" + "		" + "version");
		try {
			while(res.next()) {
				int id = res.getInt("id");
				String brand = res.getString("brand");
				String model = res.getString("model");
				double price = res.getDouble("price");
				int count = res.getInt("count");
				String version = res.getString("version");
				System.out.println(id +"	"+brand+"	"+model +"   	"+price +"		"+count +"		"+version);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}finally {
			try {
				if( res != null) {
					res.close();
				}
			} catch (SQLException e) {
				e.printStackTrace();
			}
			try {
				if( state != null) {
					state.close();
				}
			} catch (SQLException e) {
				e.printStackTrace();
			}
			try {
				conn.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
			
		}
	}
	//删除
	public static void delete() {
		try {
			Class.forName("com.mysql.jdbc.Driver");
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}
		
		String url = "jdbc:mysql://localhost:3306/db_phone";//这个只连接库
		String user = "root";
		String password = "12345";
		Connection conn = null;
		Statement state = null;
		String sql = "delete from mobile where price = '4899' ";
		int i = -1;
		try {
			conn = DriverManager.getConnection(url, user, password);
			state = conn.createStatement();
			i = state.executeUpdate(sql);
		} catch (SQLException e) {
			e.printStackTrace();
		}
		if(i == 1) {
			System.out.println("删除成功");
		}else {
			System.out.println("删除失败");
		}
		
		try {
			if( state != null) {
				state.close();
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		try {
			if( conn != null) {
				conn.close();
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	//插入
	public static void insert() {
		try {
			Class.forName("com.mysql.jdbc.Driver");
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}
		
		String url = "jdbc:mysql://localhost:3306/db_phone";//这个只连接库
		String user = "root";
		String password = "12345";
		Connection conn = null;
		Statement state = null;
		String sql = "insert into mobile values(default , '诺基亚','k898',4899,4500,'国航版')";
		int i = -1;
		try {
			conn = DriverManager.getConnection(url, user, password);
			state = conn.createStatement();
			i = state.executeUpdate(sql);
		} catch (SQLException e) {
			e.printStackTrace();
		}
		if(i == 1) {
			System.out.println("添加成功");
		}else {
			System.out.println("添加失败");
		}
		
		try {
			if( state != null) {
				state.close();
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		try {
			if( conn != null) {
				conn.close();
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	//修改
	public static void modify() {
		try {
			Class.forName("com.mysql.jdbc.Driver");
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}
		
		String url = "jdbc:mysql://localhost:3306/db_phone";//这个只连接库
		String user = "root";
		String password = "12345";
		Connection conn = null;
		Statement state = null;
		String sql = "UPDATE mobile SET brand = '黑鲨' WHERE price = 4899;";
		int i = -1;
		try {
			conn = DriverManager.getConnection(url, user, password);
			state = conn.createStatement();
			i = state.executeUpdate(sql);
		} catch (SQLException e) {
			e.printStackTrace();
		}
		if(i == 1) {
			System.out.println("修改成功");
		}else {
			System.out.println("修改失败");
		}
		
		try {
			if( state != null) {
				state.close();
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		try {
			if( conn != null) {
				conn.close();
			}
		} catch (SQLException e) {
			e.printStackTrace();
	}
}

后期继续改进

有点难！

关注

2
点赞
踩
12

收藏

觉得还不错? 一键收藏
0
评论
java-jdbc小项目实现增删改查

建库--使用数据库db_phoneUSE db_phone;--创建表mobile,有以下字段--id ,int ,主键，自增长--brand(品牌) ,字符串，非空--model(型号),字符串，非空--price(价格),浮点，非空--count(数量),整型，非空--vresion(版本),字符串，非空CREATE TABLE Mobile(id INT AUTO_INCREMENT PRIMARY KEY,brand VARCHAR(50) NOT NULL,model V
复制链接

扫一扫