What to do when Spring meets Oracle

Spring is a framework, which itself can collect oracle databases, and you can directly configure the data source.

, checkunit);set the value of the input parameter, idcard);

Register the rotten wide raid type of the output parameter and take a look.

call fn_fjxx_saftyreport (?Landlord, you have two parameters here, but you have set up three hungry brothers. If your function is not a stored procedure, and the function has a return value, you can directly use the ordinary preparestatement to select fn fjxx saftyreport (?).

That's it, don't use call

Use jdbctemplate to get the primary key value of the inserted oracle record In the process of using Spring, we often encounter the primary key value of getting the inserted data We may already use it when using JDBC, but there is also a related method in Spring's JDBCtemplate!

Oracle Database supports transaction processing, which can be committed through commit and rollback is the first way to perform transaction processing.

Transaction processing is also supported in JDBC, but all transactions need to be completed by connection. Otherwise, in the process of transaction processing, it will cause the ** before the error to run, and the ** after the error is not run, which is not allowed in the actual development process, otherwise it will cause a lot of losses.

All database updates in the connection operation are immediately updated, if you want to make a transaction, you should first stop the automatic update operation, and then all updates should be committed via commit() and rolled back if there is a problem.

Configuration file configuration AOP, there are examples on the Internet.

Connecting to an Oracle database using the Spring framework can be done in a way that configures the data source:

Spring database connection configuration.

Oracle is an example to illustrate:

3. SQL Server

3. MySQL

Required,,Three jar packages.

You're talking too generally. A login, in fact, is very complicated, because it involves a hierarchical architecture, different layers have different implementation methods, if you use Struts under Spring management, it is a practice, using Spring's own MVC is another practice, and using the classic 3-layer structure under Spring is another practice.

There are too few points. A lot of people just look at it.

The identity authentication framework, SHIRO, implements common functions for users, roles, and identity authentication.

DB connection pool: druid, which can realize fast query and analysis of large numbers without hidden evidence, and has excellent performance.

The persistence framework, Mybitas, is an excellent persistence framework that supports custom SQL, stored procedures, and advanced mappings.

Quartz supports time task scheduling and is used for common task scheduling functions.

Velocity** Generator allows you to change the first potato in a few minutes to create a set of additional book change functions, which is very powerful.

Front-end UILAYUI ,This set of UI you will feel very cool after you have used it.,It's really good.。

Oracle transactions start when a commit, rollback, or age file connects to the database or starts the first executable SQL statement, and ends when a commit, rollback, or exit the database. If a DDL statement is included in a transaction, the DDL statement is implicitly executed before and after the DDL statement, starting or ending a transaction.

If a transaction must be canceled before committing due to some failure or because the user has changed their mind, the database is restored to the state it was in before those statements and procedures were executed.

The rollback statement can be used in the commit command.