How do efficiently integrate MySQL into my project?

<p>For reference, my current project is here: <a href="https://github.com/Jake-Ruston/a-level-cw/tree/master/src" rel="nofollow">https://github.com/Jake-Ruston/a-level-cw/tree/master/src</a></p> <p>So in <code>model/User.go</code> I have my <code>Register</code> function, which is supposed to validate inputs &amp; then insert that data into the database.</p> <p>In <code>handler/register.go</code> I have the lines</p> <pre><code>if err := user.Register(uType, cpWord); err != nil { fmt.Println(&#34;ERROR Register:&#34;, err) return } </code></pre> <p>which just calls that function. </p> <p>I don&#39;t know how to properly make use of connecting to MySQL and executing a query. Lines <code>22&gt;24</code> in <code>User.go</code> is where I would put the query, which I assumed would be something along the lines of</p> <pre><code>if _, e := db.Exec(&#34;INSERT INTO login SET user_type=&#39;?&#39;, username=&#39;?&#39;, password=&#39;?&#39;&#34;, uType, u.Username, hashedPassword); e != nil { fmt.Println(&#34;ERROR Exec:&#34;, err) return e } </code></pre> <p>but where do I put the <code>sql.Open(&#34;mysql&#34;, &#34;root:redacted@/exam-management&#34;)</code> line? I&#39;m going to need to query the database in multiple files so it doesn&#39;t make sense to keep opening it everywhere.</p> <hr/>**评论：**<br/><br/>nstratos: <pre><p>Please have a look at this thread. I think the answer will help you: </p> <p><a href="https://forum.golangbridge.org/t/best-practice-to-use-go-sql-driver-mysql-package/8028" rel="nofollow">https://forum.golangbridge.org/t/best-practice-to-use-go-sql-driver-mysql-package/8028</a></p></pre>irene634: <pre><p>I would recommend using this: <a href="https://github.com/jinzhu/gorm" rel="nofollow">https://github.com/jinzhu/gorm</a></p></pre>