Parametrzied hell I was trying to parametrize the table name and field name as there were different tables but similar query. The code looked like below. 123string sql = @"SELECT * FROM @table_name;"command.P 2022-08-23 Tech Sql
Lanhuacao (Orchid Grass) I have tried to write in English since I started to study at UBC. But there was a time when I was waiting for offers from UBC and other schools. I shared one bed with my cousin in Shanghai and we woul 2022-08-20 Life Songs
Project Hackathon I finished my first in-person hackathon today and I have so many feelings right now. Just want to write them down to help me remember all the moments and moods. The business styleThe team that won the 2022-03-06 Tech Hackathon
Set a Mobile Table I’m building a book page for my blog. I decided to make it a table so that I can copy the information to excel if needed. 1. Make it adaptive for mobile devices1234567891011121314151617181920212223242 2022-01-23 Tech Blog
Notes of React 2 React ref 4th Set JSDB1. install json servercreate a new folder copy json file from GitHub 123yarn add json-servernpx json-server --watch db.json --port 3003 // since we don't have json setting f 2021-12-24 Tech React
Transfer Hexo Blog from Windows to Mac My old laptop died last week after working for me for five years. And I bought a new M1 mac the next day. It is not hard to transfer hexo blog to a mac. The following are steps I take. Step 1 Install 2021-11-30 Tech Mac
Notes of React React ref 1st Create React File Online Browser create-react-app github npx is a command of npm which is a tool to manage packages in node.js 12345npx create-react-app react-store cd react-store`npm 2021-11-25 Tech React
Blog Bookmarks This post is to list some interesting blogs or posts I somehow found. 1. https://overreacted.io/a blog about JavaScript Easy to read, colors are delightful 2. https://www.gaficat.com/use the same the 2021-11-22 Tech Blog
Steps to Deploy a Springboot Program Deploy a springboot blog0. Intro项目本身技术栈比较简单 javaweb mysql maven springboot 部署思路就是直接将项目打包至云服务器运行,服务器端只需要安装jdk和mysql 1. Install environmentjava环境# yum install -y java-1.8.0-openjdk.x86_64 mysql环境在官网下载 2021-11-18 Tech Deploy
Solutions to AWS problems 1. get root privilege sudo password root su root 之后输入root密码后就可以使用 参考链接:https://www.bbsmax.com/A/MyJxvE7Vdn/ 2. connect local host 用Xshell的时候直接用密钥连接,不需要再type密码,不然可能会报不必要的错 3. mysql安装没有root密码卸 2021-11-16 Tech AWS