The implementation of Mysql database operation based on JDBC JAVA language on IDEA: linking, searching, inserting, modifying and deleting records
On the JDBC operation of Mysql database
The general way of JAVA operating database
1. Loading drive
The purpose of loading driver is to make Java have the ability to link the specified database.
Java load driver only needs one line of code
//1. Loading drive
Class.forName("com.mysql.jdbc.Driver"); ...
Posted by joePHP on Wed, 30 Oct 2019 10:27:24 -0700
Use the front and back end to separate and search the database data of the book management system
The user login page displays the renderings:
The previous js+JQuery code shows:
<!DOCTYPE html>
<html>
<head lang="en">
<meta charset="UTF-8">
<title></title>
<script src="jquery.js"></script>
<style>
body{
background-image: url(t01f6feb7e1e ...
Posted by Nuser on Wed, 30 Oct 2019 09:16:46 -0700
Using the idea of encapsulation to write the addition, deletion, query and modification of MySQL
The items involved in this experiment are as follows:
It mainly involves four java files:
Test.java
Userinfo.java
Userinfodao.java
DBUtil.java
Let's explain one by one:
The Userinfo code is as follows: this part is mainly entity class, corresponding to database.
package com.zhongruan.util.bean;
public ...
Posted by NTM on Wed, 30 Oct 2019 08:08:22 -0700
Fix Swing -- SQL test tool writing
Be careful:
1. The scope of use of the modifier private public protect is the current class, all classes, the same package and its subclasses; the use of static final;
2. The form of variable used for text is as this.settitle ("swing SQL test");
3. Do not write business logic code in ...
Posted by samusk on Wed, 30 Oct 2019 07:38:16 -0700
Local deployment of distributed monitoring CAT server
I. CAT introduction
CAT (Central Application Tracking) is an open-source distributed real-time monitoring system developed by meituan reviews based on Java. The Infrastructure Department of meituan reviews hopes to provide industry-leading and unified solutions in the fields of basic storage, high-performance communication, large-scale online ...
Posted by Tonata on Tue, 29 Oct 2019 18:45:51 -0700
Apache Commons DbUtils integrates Spring framework to realize simple CRUD
Commons DbUtils is an open source tool class library provided by Apache, which can simply encapsulate JDBC and simplify the development of JDBC. Commons DbUtils is very convenient to integrate the Spring Framework, which is relatively lightweight. It is very convenient to execute SQL statements (especially query statements). It can replace the ...
Posted by mrman23 on Tue, 29 Oct 2019 08:47:31 -0700
oracle+mybatis bulk insert data
1.Oracle batch operation
My watch structure is
1.1 batch insertion
1.1.1 primary key does not use sequence
insert into students(sid,sname,ssal,ssex)
select 9,'Zhang San',3000,'male' from dual
union all select 10,'Li Si',4000,'male' from dual
union all select 11,'Xiaohong',5000,'female' from dual
...
Posted by Alkimuz on Mon, 28 Oct 2019 08:29:39 -0700
Python Road [chapter 29]: django ORM model layer
ORM introduction
An important part of MVC or MVC framework is ORM, which realizes the decoupling of data model and database, that is, the design of data model does not need to rely on specific database, and the database can be easily replaced through simple configuration, which greatly reduces the workload of developers and does not need to f ...
Posted by aximbigfan on Sun, 27 Oct 2019 23:49:45 -0700
iClient for OpenLayers drawing graphics library
iClient for OpenLayers drawing graphics library
By yangjl
In the process of support, I once met a small customer partner who asked me how to store the drawn graphics. In fact, there are many ways. I chose a simpler way to create my own service by using nodejs and connect mysql to store the graphics ...
Posted by kbrij on Sun, 27 Oct 2019 20:06:31 -0700
cursor, view, storage function and trigger usage of Mysql database
1. cursor
Using cursors to solve the problem that sql statements can't handle row records, we want to be a traversal array in java.
BEGIN
DECLARE river_id VARCHAR(32); -- Custom variable
DECLARE river_name VARCHAR(50); -- Custom variable
DECLARE done INT DEFAULT FALSE; -- Traverse d ...
Posted by duncanwil on Sun, 27 Oct 2019 04:51:29 -0700