Java-web-jdbc复习_在javaweb中设置所访问的数据库ur1关键字-优快云博客

本文链接：https://blog.youkuaiyun.com/qgfyuhg/article/details/121902063

这是一个关于Java使用JDBC进行数据库操作的示例，展示了如何创建UserBean对象并使用PreparedStatement插入数据到MySQL数据库中。主要涉及数据库连接、预编译SQL语句和资源关闭等步骤。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

这是userbean代码
package com.wonuxy.entity;

public class User {
	private String uid;
	private String uname;
	private String pwd;
	private String email;
	
	public User() {
		super();
	}

	public User(String uid, String uname, String pwd, String email) {
		super();
		this.uid = uid;
		this.uname = uname;
		this.pwd = pwd;
		this.email = email;
	}

	public String getUid() {
		return uid;
	}

	public void setUid(String uid) {
		this.uid = uid;
	}

	public String getUname() {
		return uname;
	}

	public void setUname(String uname) {
		this.uname = uname;
	}

	public String getPwd() {
		return pwd;
	}

	public void setPwd(String pwd) {
		this.pwd = pwd;
	}

	public String getEmail() {
		return email;
	}

	public void setEmail(String email) {
		this.email = email;
	}

	@Override
	public String toString() {
		return "User [uid=" + uid + ", uname=" + uname + ", pwd=" + pwd + ", email=" + email + "]";
	}
	
}

这是jdbc
package com.wonuxy.dao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;

import com.wonuxy.entity.User;

public class UserDao {
	public void insertUser(User user) {
		Connection connection=null;
		PreparedStatement prepareStatement=null;
		try {
			// 加载驱动
			String className = "com.mysql.jdbc.Driver";
			String ur1 = "jdbc:mysql://localhost:3306/db1";
			String username = "root";
			String password = "";
			Class.forName(className);
			connection = DriverManager.getConnection(ur1, username, password);
			// 定义sql语句
			String sql = "insert into user values(?,?,?,?)";
			// 创建执行sql的preparedStatement对象
			prepareStatement = connection.prepareStatement(sql);
			// 添加构建数
			prepareStatement.setString(1, user.getUid());
			prepareStatement.setString(2, user.getUname());
			prepareStatement.setString(3, user.getPwd());
			prepareStatement.setString(4, user.getEmail());
			//执行增删改都用这个
			prepareStatement.executeUpdate();
		} catch (Exception e) {

			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally {
			//关闭资源，这里要把声明对象放到外面
			//先用的后关，后出来的先关
			if (prepareStatement!=null) {
				try {
					prepareStatement.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
				if (connection!=null) {
					try {
						connection.close();
					} catch (SQLException e) {
						// TODO Auto-generated catch block
						e.printStackTrace();
					}
				}
			}
		}
	}
}

eclipse常见快捷键

格式化 ctrl+shift+F

ctr1+1 提示

alt+shift+L 自动生成方法返回值变量类型

alt+shift+z 添加外部代码结构异常-y if-3

alt+shift+R 变量改名,集体改名

ctrl+/ 添加/删除单行注释

ctrl+shift+/ 添加多行注释

ctrl+shift+\ 删除多行注释

ctrl+shift+T 搜索源码

ctrl+T 查看类型的层次

ctrl+O 查看类的成员