链接数据库（jdbc）——实现增删改查

黄尚圈圈

已于 2024-04-29 23:10:12 修改

阅读量529

点赞数 11

文章标签：数据库 java

于 2024-04-25 14:30:00 首次发布

本文链接：https://blog.csdn.net/hs_1024/article/details/138187589

版权

本文详细介绍了如何在Eclipse中，利用Java和JDBC技术连接MySQL数据库，包括查询、插入、更新和删除操作的步骤和代码示例。

摘要由CSDN通过智能技术生成

本文通过java 对本地数据库实现增删改查基础操作，选取软件：eclipse

1.如何链接数据库：

jdbc的详要过程如下我们将按照图示逐步实现

首先new 一个动态web

按图中所示进行新建，随后按照下图导入mysql的jar包

将jar包导入到如图所示 lib 目录下即可开始操作

2. 查

我们先来实现对数据库的搜索

1.此时我们按照链接流程首先要成功加载驱动：

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

会发生报错，不过不影响我们指向 try即可

2.创建链接


	String url = "jdbc:mysql://localhost:3306/school?useUnicode=true&characterEncoding=utf-8";
Connection connection = (Connection) DriverManager.getConnection(url, "root", "passord");

/url参考这里选取本地数据库读者需要检查自己数据库端口号是否3306 ，进行更改 school？是作者本地数据库中的一个数据库，读者根据自己数据库内容自行进行更改

password 是读者本地数据库密码自行进行更改

3.生成对象

Statement statement = (Statement) connection.createStatement();

4.执行sql

	ResultSet set = statement.executeQuery(sql);

5.打印数据

while(set.next()) {
				String id= set.getString("id");
				String name= set.getString("name");
				String sex= set.getString("sex");
				String age= set.getString("age");
				String sno= set.getString("sno");
				String class_num = set.getString("class_num");
				System.out.println(id + " "+name + " "+sex + " " +age+ ""+sno +" "+ class_num);
			}

6.关闭

if(set!= null) {
				set.close();
			}
			if(statement!=null) {
				statement.close();
			}
			if(connection != null) {
				connection.close();
			}

7.数据库参考

本文数据库格式如图具体操作读者自习按照自己数据设定进行操作

8.import包

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

本文应用了以上java 包

9.完整实现

package com.qcby;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class Search {
	public static void main(String[] args) {
		String sql = "select * from student"; 
		search(sql);
	}
	
	
	public static void search(String sql) {
		String url = "jdbc:mysql://localhost:3306/school?useUnicode=true&characterEncoding=utf-8";
		try {
			Class.forName("com.mysql.jdbc.Driver");//1.加载驱动
			//2.创建链接
			Connection connection = (Connection) DriverManager.getConnection(url, "root", "password");//自行更改password
			//3.生成对象
			Statement statement = (Statement) connection.createStatement();
			//4.执行sql语句
			ResultSet set = statement.executeQuery(sql);
			//5.打印数据
			while(set.next()) {
				String id= set.getString("id");
				String name= set.getString("name");
				String sex= set.getString("sex");
				String age= set.getString("age");
				String sno= set.getString("sno");
				String class_num = set.getString("class_num");
				System.out.println(id + " "+name + " "+sex + " " +age+ ""+sno +" "+ class_num);
			}
			//6.关闭
			if(set!= null) {
				set.close();
			}
			if(statement!=null) {
				statement.close();
			}
			if(connection != null) {
				connection.close();
			}
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
		
		
	}
}

3.增

package com.qcby;

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

public class Insert {

	public static void main(String[] args) {
		// TODO Auto-generated method stub
			String sql = "insert into student(name,sex,age,sno,class_num) value( '三','男',12,'211','11')";
			insert(sql);
	}
	public static void insert(String sql) {
		String url = "jdbc:mysql://localhost:3306/school?useUnicode=true&characterEncoding=utf-8";
		
		try {
			Class.forName("com.mysql.jdbc.Driver");//1.驱动
			Connection connection = (Connection)DriverManager.getConnection(url,"root","password");
			Statement statement= (Statement) connection.createStatement();
			int count = statement.executeUpdate(sql);//记录执行 输出1 则执行成功
			System.out.println(count);
			if(statement != null) {
				statement.close();
			}
			if(connection != null) {
				connection.close();
			}
			
			
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
	}

}

4.改

package com.qcby;

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

public class Update {

	public static void main(String[] args) {
		String sql = " update student set name = '区区' where id = '8'";
		update(sql);
	}
	public static void update(String sql) {
		String url = "jdbc:mysql://localhost:3306/school?useUnicode=true&characterEncoding=utf-8";
		try {
			Class.forName("com.mysql.jdbc.Driver");
			Connection connection = (Connection)DriverManager.getConnection(url, "root","password");
			Statement statement = (Statement)connection.createStatement();
			int count = statement.executeUpdate(sql);
			System.out.println(count);
			
			if(statement != null) {
				statement.close();
			}
			if(connection != null) {
				connection.close();
			}
			
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
}

5.删

package com.qcby;

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

public class Delete {
		public static void main(String[] args) {
			String sql = "delete from student where id = '5 ' ";
			delete(sql);
		}
		public static void delete(String sql) {
			String url = "jdbc:mysql://localhost:3306/school?useUnicode=true&characterEncoding=utf-8";
			try {
				Class.forName("com.mysql.jdbc.Driver");
				Connection connection = (Connection)DriverManager.getConnection(url, "root","password");
				Statement statement = (Statement)connection.createStatement();
				int count = statement.executeUpdate(sql);
				System.out.println(count);
				
				if(statement != null) {
					statement.close();
				}
				if(connection != null) {
					connection.close();
				}
				
			} catch (Exception e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		
}