Using JdbcTemplate
The principle is to load the driver Class.forName ("Com.mysql.jdbc.Driver");
and connecting the database connection conn=drivermanager.getconnection ("jdbc:mysql://localhost:3306/sw_database?user=root& Password=root ");
Complete Drivermanagerdatasource datasource=new Drivermanagerdatasource () with an object;
PackageCom.swift;Importorg.springframework.jdbc.core.JdbcTemplate;ImportOrg.springframework.jdbc.datasource.DriverManagerDataSource;Importorg.springframework.stereotype.Component; @Component (Value= "Jdbctemplatedemo") Public classJdbctemplatedemo { Public BooleanAdd () {//Setting Up Database informationDrivermanagerdatasource datasource=NewDrivermanagerdatasource (); Datasource.setdriverclassname ("Com.mysql.jdbc.Driver"); Datasource.seturl ("Jdbc:mysql://localhost:3306/sw_database"); Datasource.setusername ("Root"); Datasource.setpassword ("Root"); //Create a JdbcTemplate object, set the data sourceJdbcTemplate jdbctemplate=NewJdbcTemplate (DataSource); String SQL= "INSERT into Sw_user (Username,password) VALUES (?,?)"; intCount=jdbctemplate.update (SQL, "Doomsday", "20171125"); if(count==1) { return true; } return false; }}
Adding a database operation using the JdbcTemplate object to use the Update method directly from the data source is much easier than before.
Before you finish, you need to press the following method:
PreparedStatement ps=conn.preparestatement ("INSERT into Sw_user (Username,password) VALUES (?,?)");
Ps.setstring (1, "Doomsday");
Ps.setstring (2, "20171125");
ResultSet rs=ps.executequery ();(not the sentence, this is the SELECT statement)
int count=ps.executeupdate ();
if (count==1) {return true;}
The top code uses spring frame annotations to generate object methods
The XML configuration file code is as follows:
<?XML version= "1.0" encoding= "UTF-8"?><Beansxmlns= "Http://www.springframework.org/schema/beans"Xmlns:xsi= "Http://www.w3.org/2001/XMLSchema-instance"Xmlns:context= "Http://www.springframework.org/schema/context"xsi:schemalocation= "Http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd Http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd " > <!--Turn on annotation scanning - <Context:component-scanBase-package= "Com.swift"></Context:component-scan> </Beans>
To test using the Servlet class:
PackageCom.swift;Importjava.io.IOException;Importjavax.servlet.ServletException;ImportJavax.servlet.annotation.WebServlet;ImportJavax.servlet.http.HttpServlet;Importjavax.servlet.http.HttpServletRequest;ImportJavax.servlet.http.HttpServletResponse;ImportOrg.springframework.context.ApplicationContext;ImportOrg.springframework.context.support.ClassPathXmlApplicationContext; @WebServlet ("/servlettest") Public classServlettestextendsHttpServlet {Private Static Final LongSerialversionuid = 1L; Publicservlettest () {Super(); } protected voidDoget (HttpServletRequest request, httpservletresponse response)throwsservletexception, IOException {response.setcharacterencoding ("Utf-8"); Response.setcontenttype ("Text/html;charset=utf-8"); Response.getwriter (). Append ("Served at:"). Append (Request.getcontextpath ()); ApplicationContext Context=NewClasspathxmlapplicationcontext ("Beanzhujie.xml"); Jdbctemplatedemo Jdbctemplatedemo= (Jdbctemplatedemo) context.getbean ("Jdbctemplatedemo"); if(Jdbctemplatedemo.add ()) {Response.getwriter (). Append ("Account Registration is successful"); }Else{response.getwriter (). Append ("Registration Failed"); } } protected voidDoPost (HttpServletRequest request, httpservletresponse response)throwsservletexception, IOException {doget (request, response); }}
The results in the browser are as follows:
Successfully added data in Navicat Premium, with the following results:
The spring framework adds database operations to the DAO layer's JdbcTemplate operations crud add