java调用mysql数据库的基本操作方法

最新推荐文章于 2024-07-28 08:35:58 发布

actionzh

最新推荐文章于 2024-07-28 08:35:58 发布

阅读量2.1w

点赞数 12

分类专栏： java 文章标签： java mysql 数据库

本文链接：https://blog.csdn.net/actionzh/article/details/53193328

版权

java 专栏收录该内容

15 篇文章 0 订阅

订阅专栏

一. 关于java与mysql数据库的连接：

		//加载数据库驱动
		Class.forName("com.mysql.jdbc.Driver");
		
		//获取连接//http://baidu.com
		Connection connection =DriverManager.getConnection("jdbc:mysql://localhost:3306/shopping?user=root&password=&char		acterEncoding=utf-8");
		
		//通过连接创建statement
		Statement statement =connection.createStatement();
		//定义sql
		//执行sql语句，得到结果resultset
		ResultSet rs=statement.executeQuery("select * from allshop where shopname='"+name+"'");

二. 关于mysql数据库的增删查改找

1.向数据库增加数据

try {//加载数据库驱动
		Class.forName("com.mysql.jdbc.Driver");
		
		//获取连接//http://baidu.com
		Connection connection =DriverManager.getConnection("jdbc:mysql://localhost:3306/shopping?user=root&password=&char		acterEncoding=utf-8");
		
		//通过连接创建statement
		Statement statement =connection.createStatement();

String sql1 = "INSERT INTO buyer_order VALUES(NULL,'"+添加项+"','"+添加项+','"+添加项+"');";
//如果不添加数据则写为NULL
		
			statement = connection.createStatement();
			statement.execute(sql1);

			connection.close();
		
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

2.删除数据库中的数据

	try {
			String sql = ("Delete from buyer_gouwuche where ids="+del+"");
			statement.executeUpdate(sql);  
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

3.查询数据库中的数据

ResultSet rs=statement.executeQuery("select * from allshop where shopname='"+name+"'");
		
		if(rs.next())
	    {System.out.println("记录存在");}
		 else
			 
		 {System.out.println("记录不存在");}

4.修改数据库中的数据

try {
			Class.forName("com.mysql.jdbc.Driver");
			
			Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/shopping?user=root&password=&useUnicode=true&characterEncoding=utf-8");
			PreparedStatement pst = connection.prepareStatement("update buyer_mytaobao set phonenumber=?,name=?,adress=? where phonenumber='"+phone+"'");
			System.out.println(cm.getPhonenumber());
			System.out.println(cm.getName());
			System.out.println(cm.getAdress());
			
			pst.setString(1, cm.getPhonenumber());
			pst.setString(2, cm.getName());
			pst.setString(3, cm.getAdress());
			 pst.executeUpdate();
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

5.获取数据库中的数据

String sql = ("select * from allshop where ids='"+id+"' ");
			System.out.println("new sql");
			// 执行sql语句
			ResultSet rs;
			try {
				rs = statement.executeQuery(sql);
				if (rs.next()) {
					// int id = rs.getInt("id");
					String name = rs.getString("shopname");
					float price = rs.getFloat("shopunitprice");
					String image = rs.getString("image");
					System.out.println(id);
					System.out.println(name);
					System.out.println(price);
					System.out.println(image);
					GoodsMessage g = new GoodsMessage(id, name, image, price);
					return g;
				}
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}

以上就是我所总结的关于java对mysql数据库的一些使用方法。