使用jdbcTemplate 原理是把載入驅動Class.forName("com.mysql.jdbc.Driver"); 和連接資料庫Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/sw_datab ...
使用jdbcTemplate
原理是把載入驅動Class.forName("com.mysql.jdbc.Driver");
和連接資料庫Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/sw_database?user=root&password=root");
用一個對象完成DriverManagerDataSource dataSource=new DriverManagerDataSource();
package com.swift; import org.springframework.jdbc.core.JdbcTemplate; import org.springframework.jdbc.datasource.DriverManagerDataSource; import org.springframework.stereotype.Component; @Component(value="jdbcTemplateDemo") public class JdbcTemplateDemo { public boolean add() { //設置資料庫信息 DriverManagerDataSource dataSource=new DriverManagerDataSource(); dataSource.setDriverClassName("com.mysql.jdbc.Driver"); dataSource.setUrl("jdbc:mysql://localhost:3306/sw_database"); dataSource.setUsername("root"); dataSource.setPassword("root"); //創建JdbcTemplate對象,設置數據源 JdbcTemplate jdbcTemplate=new JdbcTemplate(dataSource); String sql="insert into sw_user(username,password) values(?,?)"; int count=jdbcTemplate.update(sql, "doomsday","20171125"); if(count==1) { return true; } return false; } }
添加資料庫操作使用JdbcTemplate對象根據數據源直接使用update方法完成,比之前簡便很多。
之前完成需按下邊方法:
PreparedStatement ps=conn.prepareStatement("insert into sw_user(username,password) values(?,?)");
ps.setString(1,“doomsday”);
ps.setString(2, “20171125”);
//ResultSet rs=ps.executeQuery();(不是這句,這句是select 語句的)
int count=ps.executeUpdate();
if(count==1) {return true;}
上邊代碼使用Spring框架註解生成對象方法
xml配置文件代碼如下:
<?xml version="1.0" encoding="UTF-8"?> <beans xmlns="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"> <!-- 開啟註解掃描 --> <context:component-scan base-package="com.swift"></context:component-scan> </beans>
使用Servlet類進行測試:
package com.swift; import java.io.IOException; import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import org.springframework.context.ApplicationContext; import org.springframework.context.support.ClassPathXmlApplicationContext; @WebServlet("/ServletTest") public class ServletTest extends HttpServlet { private static final long serialVersionUID = 1L; public ServletTest() { super(); } protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setCharacterEncoding("utf-8"); response.setContentType("text/html;charset=utf-8"); response.getWriter().append("Served at: ").append(request.getContextPath()); ApplicationContext context=new ClassPathXmlApplicationContext("beanZhujie.xml"); JdbcTemplateDemo jdbcTemplateDemo=(JdbcTemplateDemo) context.getBean("jdbcTemplateDemo"); if(jdbcTemplateDemo.add()) { response.getWriter().append("帳號註冊成功"); }else { response.getWriter().append("註冊失敗"); } } protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doGet(request, response); } }
瀏覽器中的到結果如下:
navicat premium 中成功添加數據,結果如下: