Programmer Group

Now that we have written the fifth chapter, Jira's official system is actually getting farther and farther away. The content of this chapter has basically been completely separate from Jira itself, and has relied on Jira's API interface and database for development.It mainly contains the following functions: Personnel Task Scheduling Managemen ...

Introduction Recent projects use mongo logs for data statistics. Being obsessed with non-relational databases, I bought a copy of MongoDB Actual Warfare and studied it for a while. Record the learning notes and share them. Get ready I installed the latest version of Mono on my Linux server. Record another problem with the installation link. Li ...

I. Simple annotations to mybatis Key commentaries: @ Insert: Insert sql, exactly the same as xml insert sql @ Select: Query sql, exactly the same as xml select sql grammar @ Update: Update sql, exactly the same as xml update sql syntax @ Delete: Delete sql, exactly the same as xml delete sql @ Param: Pa ...

Judgment statement The value of select is passed to a variable IF(@v_count <> 0) BEGIN SELECT @v_team_id=team_id FROM TABLE T WHERE T.column=1; END ELSE BEGIN SET@v_team_name='nothing'; END Multi-line to one-line https://www.cnblogs.com/CreateMyself/p/9058380.htmloracle:listagg SELECT STUFF((SELECT '/' + T. ...

C++/python Connects to MySql Database This article is written by the blogger after consulting and summarizing the online information. If there are errors or inappropriateness, please leave a message for correction. The content is for your reference only. 1.C++ calls MySQL API to connect: Fir ...

import pyodbc   # Database Server Information driver = 'SQL Server' server = 'SHCWSYWFZ46T'   user = 'sa' password = 'sh.0628' database = 'zyroi' # Connect to the database conn = pyodbc.connect(driver=driver, server=server, user=user, \                       password=password, database=database)   ...

Database connection pool Previous problems In fact, the previous code has no problem, enough to operate the database. But getting the connection object (driverManager.getConnection(String driverClassName, String url, String password);) is a resource-intensive step. Creating the connection object eve ...

Links to the original text: http://www.cnblogs.com/riasky/p/3507598.html Execution planning is a commonly used assistant tool for DBA diagnostic problems. Using it, we can find out how resources are consumed or whether the optimizer has ...

Preface Yesterday was written about discovery. It's not too early. I've formed the habit of taking time off from work at night to see what I can write. Today I really don't want to be influenced by what I didn't finish yesterday. So I sat down again and settled down (over the weekend) and began to com ...

Beginning of database transactions Long ago, we wanted to implement a transaction, usually a database transaction based on SQL, which is usually implemented by SQL query language. As follows, we updated the price of two books at the same time: BEGIN TRANSACTION UPDATE tb_Book SET Price=122 WHERE IDENT_CURRENT=1001UPDATE tb_Book SET Price=88 WH ...