数据库开发实践-报告模板

数据库开发实践-报告模板（只上传部分）

基于Java GUI

数据库开发实践-报告（目录）

如图章节

用例共5个
eg:

第二章 数据库设计

第三章 系统实现

连接数据库

在这里插入代码片
```Private String dbUrl="jdbc:mysql://localhost:3306/db_food?use 
Unicode=true&characterEncoding=utf8";                          
	private String dbUserName="root";
	private String dbPassword="123456";
	private String jdbcName="com.mysql.cj.jdbc.Driver";
	public Connection getCon() throws Exception{
		Class.forName(jdbcName);
		Connection con=DriverManager.getConnection(dbUrl,dbUserName,dbPassword);
		return con;
	}
		public void closeCon(Connection con) throws Exception{
		if(con!=null){
			con.close();
		}
	}
	public static void main(String[] args) {
		DbUtil dbUtil=new DbUtil();
		try {
			dbUtil.getCon();
			System.out.println("数据库连接成功");
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			System.out.println("数据库连接失败");
		}
		
	}

**登录功能**
public User login(Connection con,User user) throws Exception{
		User resultUser = null;
		String sql="select *from user where userName=? and password=?";
		PreparedStatement pstmt=con.prepareStatement(sql);
		pstmt.setString(1, user.getUserName());
		pstmt.setString(2, user.getPassword());
		ResultSet rs=pstmt.executeQuery();
		if(rs.next()){
			resultUser = new User();
			resultUser.setUserName(rs.getString("userName"));
			resultUser.setPassword(rs.getString("password"));
			resultUser.setRank(rs.getInt("rank"));
			resultUser.setId(rs.getInt("id"));
		}
		return resultUser;
	}

**增加用户功能**
public int userAdd(Connection con,User user) throws Exception{
		String sql="insert into `user` values(null,?,?,?,?)";
		PreparedStatement pstmt=con.prepareStatement(sql);
		pstmt.setString(1, user.getUserName());
		pstmt.setString(2, user.getPassword());
		pstmt.setString(3, user.getEmail());
		pstmt.setInt(4, user.getRank());
		return pstmt.executeUpdate();
	}

**修改用户功能**
	public int userModify(Connection con,User user) throws Exception{
		String sql="update `user` set userName=?,password=?,email=? where id=?";
		PreparedStatement pstmt=con.prepareStatement(sql);
		pstmt.setString(1, user.getUserName());
		pstmt.setString(2, user.getPassword());
		pstmt.setString(3, user.getEmail());
		pstmt.setInt(4, user.getId());;
		return pstmt.executeUpdate();
	}

## 总结

![在这里插入图片描述](https://img-blog.csdnimg.cn/f4cc5910a7a44def8dee7828e80c0b4c.png)