JAVA连接MYSQL进行增删查改

最新推荐文章于 2024-06-29 16:15:57 发布

桑榆207

最新推荐文章于 2024-06-29 16:15:57 发布

阅读量205

点赞数

分类专栏： JAVA

本文链接：https://blog.csdn.net/lanshan1111/article/details/89209971

版权

JAVA 专栏收录该内容

20 篇文章 0 订阅

订阅专栏

增加一条记录：


	<%
		Connection conn;
		PreparedStatement stmt;
		String driver = "com.mysql.jdbc.Driver";
		String url = "jdbc:mysql://localhost:3306/student?useSSL=true";
		String user = "root";
		String password = "sannian1";
		String sql = "insert into scsc values(?)";
		String str = "999";
		int n = 100;
		//初始化各个变量
		try {
			//搭桥连接
			Class.forName(driver);
			conn = DriverManager.getConnection(url, user, password);
			stmt = (PreparedStatement) conn.prepareStatement(sql);
			try {
				//执行查询语句
				stmt.setString(1, str);
				n = stmt.executeUpdate();
				//注意这里不带参数、因为建立stmt对象时已经加了参数
			} catch (Exception e) {
				e.printStackTrace();
			}
			try {
				//拆桥关闭连接
				conn.close();
				stmt.close();
			} catch (Exception e) {
				e.printStackTrace();
			}
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	%>
	成功--------------------<%=n %>

查询记录：


	<%
		Connection conn;
		PreparedStatement stmt;
		String driver = "com.mysql.jdbc.Driver";
		String url = "jdbc:mysql://localhost:3306/student?useSSL=true";
		String user = "root";
		String password = "sannian1";
		String sql = "select * from student";
		int n = 100;
		//初始化各个变量
		try {
			//搭桥连接
			Class.forName(driver);
			conn = DriverManager.getConnection(url, user, password);
			stmt = (PreparedStatement) conn.prepareStatement(sql);
			try {
				//执行查询语句
				ResultSet result=stmt.executeQuery();
				while(result.next())
					System.out.println(result.getString(2));
				//注意这里不带参数、因为建立stmt对象时已经加了参数
			} catch (Exception e) {
				e.printStackTrace();
			}
			try {
				//拆桥关闭连接
				conn.close();
				stmt.close();
			} catch (Exception e) {
				e.printStackTrace();
			}
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	%>

查询sc表中学号为20171789的grade信息


	<%
		Connection conn;
		PreparedStatement stmt;
		String driver = "com.mysql.jdbc.Driver";
		String url = "jdbc:mysql://localhost:3306/student?useSSL=true";
		String user = "root";
		String password = "sannian1";
		String sql = "select * from sc where sno=?";
		int n = 100;
		//初始化各个变量
		try {
			//搭桥连接
			Class.forName(driver);
			conn = DriverManager.getConnection(url, user, password);
			stmt = (PreparedStatement) conn.prepareStatement(sql);
			try {
				//执行查询语句
				//设置参数
				stmt.setInt(1, 20171789);
				ResultSet result=stmt.executeQuery();
				while(result.next())
					System.out.println(result.getInt(3));
				//注意这里不带参数、因为建立stmt对象时已经加了参数
			} catch (Exception e) {
				e.printStackTrace();
			}
			try {
				//拆桥关闭连接
				conn.close();
				stmt.close();
			} catch (Exception e) {
				e.printStackTrace();
			}
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	%>

删除信息：


	<%
		Connection conn;
		PreparedStatement stmt;
		String driver = "com.mysql.jdbc.Driver";
		String url = "jdbc:mysql://localhost:3306/student?useSSL=true";
		String user = "root";
		String password = "sannian1";
		String sql = "delete  from sc where sno=?";
		int n = 100;
		//初始化各个变量
		try {
			//搭桥连接
			Class.forName(driver);
			conn = DriverManager.getConnection(url, user, password);
			stmt = (PreparedStatement) conn.prepareStatement(sql);
			try {
				//执行查询语句
				//设置参数
				stmt.setInt(1, 20171789);
				stmt.executeUpdate();
				/* ResultSet result=stmt.executeQuery();
				while(result.next())
					System.out.println(result.getInt(3)); */
				//注意这里不带参数、因为建立stmt对象时已经加了参数
			} catch (Exception e) {
				e.printStackTrace();
			}
			try {
				//拆桥关闭连接
				conn.close();
				stmt.close();
			} catch (Exception e) {
				e.printStackTrace();
			}
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	%>

修改信息：

<%@page import="java.sql.DriverManager"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
	pageEncoding="UTF-8" import="java.sql.*"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
	<%
		Connection conn;
		PreparedStatement stmt;
		String driver = "com.mysql.jdbc.Driver";
		String url = "jdbc:mysql://localhost:3306/student?useSSL=true";
		String user = "root";
		String password = "sannian1";
		String sql = "update sc set grade=100 where sno=?";
		int n = 100;
		//初始化各个变量
		try {
			//搭桥连接
			Class.forName(driver);
			conn = DriverManager.getConnection(url, user, password);
			stmt =(PreparedStatement)conn.prepareStatement(sql);
			try {
				//执行查询语句
				//设置参数
				stmt.setInt(1, 20171789);
				stmt.executeUpdate();
			} catch (Exception e) {
				e.printStackTrace();
			}
			try {
				//拆桥关闭连接
				conn.close();
				stmt.close();
			} catch (Exception e) {
				e.printStackTrace();
			}
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	%>
	成功--------------------<%=n %>
</body>
</html>