自己编写阿里云settings.xml

最新推荐文章于 2025-04-04 19:20:37 发布

鱼巷、猫未随

最新推荐文章于 2025-04-04 19:20:37 发布

阅读量421

点赞数

分类专栏： Spring Boot 文章标签：阿里云 settings.xml

本文链接：https://blog.youkuaiyun.com/weixin_42153410/article/details/98343389

版权

Spring Boot 专栏收录该内容

4 篇文章

订阅专栏

本文介绍了一个基于Java的消息管理系统，包括消息的增删查改、分页查询及回复功能。使用了Apache Commons DbUtils库进行数据库操作，实现了根据学生ID查找消息总数、按页获取消息列表、添加新消息、查找所有消息总数、按页获取教师视图下的消息列表、回复消息及通过ID查找特定消息。

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

打开一个空记事本，复制粘贴下列代码：

package cn.lk.wjyl.dao;

import java.sql.SQLException;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.List;

import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanHandler;
import org.apache.commons.dbutils.handlers.BeanListHandler;
import org.apache.commons.dbutils.handlers.ScalarHandler;

import cn.lk.wjyl.domain.Message;
import cn.lk.wjyl.domain.Student;
import cn.lk.wjyl.utils.JDBCUtils;

public class MessageDao {

	public int findTotalRecordsByStuId(Student stu) throws SQLException {
		String sql="select count(*) from t_message where stuId=?";
		QueryRunner qr=new QueryRunner(JDBCUtils.getDataSource());
		Number num=(Number)qr.query(sql, new ScalarHandler(),stu.getStuId());
		return num.intValue();
	}

	public List<Message> findMessagesWithPage(int startIndex, Student stu) throws SQLException {
		String sql="select top 5 * from t_message where stuId = ? and  messageId not in (select top (?) messageId from t_message where stuId = ? order by leaveWordTime desc) order by leaveWordTime desc";
		QueryRunner qr=new QueryRunner(JDBCUtils.getDataSource());
		return qr.query(sql, new BeanListHandler<Message>(Message.class),stu.getStuId(),startIndex,stu.getStuId());
	}

	public void addMessage(Message msg) throws SQLException {
		String sql="insert into t_message (content,leaveWordTime,stuId) values ( ? , ? , ? )";
		Object[] params= {msg.getContent(),msg.getLeaveWordTime(),msg.getStuId()};
		QueryRunner qr=new QueryRunner(JDBCUtils.getDataSource());
		qr.update(sql,params);
	}

	public int findTotalRecords() throws SQLException {
		String sql="select count(*) from t_message";
		QueryRunner qr=new QueryRunner(JDBCUtils.getDataSource());
		Number num=(Number)qr.query(sql, new ScalarHandler());
		return num.intValue();
	}

	public List<Message> findMessagesWithPageByTeacher(int startIndex) throws SQLException {
		String sql="select top 5 * from t_message where messageId not in (select top (?) messageId from t_message order by leaveWordTime desc) order by leaveWordTime desc";
		QueryRunner qr=new QueryRunner(JDBCUtils.getDataSource());
		return qr.query(sql, new BeanListHandler<Message>(Message.class),startIndex);
	}

	public void replayMessage(String id, String replay) throws SQLException {
		String sql="update t_message set replay =? , replayTime = ? where messageId=?";
		QueryRunner qr=new QueryRunner(JDBCUtils.getDataSource());
		SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd");
		String replayTime=sdf.format(new Date());
		Object[] params= {replay,replayTime,id};
		qr.update(sql,params);
	}
	
	public Message findMessageById(int id) throws SQLException {
		String sql="select * from t_message where messageId = ?";
		QueryRunner qr=new QueryRunner(JDBCUtils.getDataSource());
		return qr.query(sql, new BeanHandler<Message>(Message.class),id);
	}
}

然后保存，命名为settings.xml

打开sts或者eclipse → 顶部的windows →Preferences ↓ 找到之前编写的settings.xml所保存的路径

注意：setting.xml不能删除，所以尽量不要存放在桌面。