数据库SpringTemplate语法格式

àì夳堔傛蜴生んèń 2022-05-13 08:54 160阅读 0赞

package JDBCTemplate;

import com.alibaba.druid.pool.DruidDataSourceFactory;

import javax.sql.DataSource;  
import java.io.IOException;  
import java.sql.Connection;  
import java.sql.ResultSet;  
import java.sql.SQLException;  
import java.sql.Statement;  
import java.util.Properties;

public class JDBCUtils \{  
private static DataSource ds;  
static \{  
try \{  
Properties pp =new Properties();  
pp.load(JDBCUtils.class.getClassLoader().getResourceAsStream(“druid.properties”));  
ds = DruidDataSourceFactory.createDataSource(pp);  
\} catch (IOException e) \{  
e.printStackTrace();  
\} catch (Exception e) \{  
e.printStackTrace();  
\}  
\}  
public static DataSource getDataSource()\{  
return ds;  
\}  
//获取链接  
public static Connection getConnection() throws SQLException \{  
return ds.getConnection();  
\}  
//释放资源  
public static void close(Statement stat,Connection conn)\{  
close(null,stat,conn);  
\}  
public static void close(ResultSet rs,Statement stat,Connection conn)\{  
if(rs!=null)\{  
try \{  
rs.close();  
\} catch (SQLException e) \{  
e.printStackTrace();  
\}  
\}  
if(stat!=null)\{  
try \{  
stat.close();  
\} catch (SQLException e) \{  
e.printStackTrace();  
\}  
\}  
if(conn!=null)\{  
try \{  
conn.close();  
\} catch (SQLException e) \{  
e.printStackTrace();  
\}  
\}  
\}  
\}

/*=====================================*/  
/*测试类*/  
package JDBCTemplate;

import org.springframework.jdbc.core.JdbcTemplate;

public class Test \{  
public static void main(String\[\] args) \{  
//创建对象  
JdbcTemplate template = new JdbcTemplate(JDBCUtils.getDataSource());  
//定义SQL语句  
String sql = “UPDATE zhifubao SET money = money+1000 WHERE id = 1”;  
//执行SQL  
int update = template.update(sql);  
System.out.println(“update = ” + update);  
\}  
\}

/*===========配置文件druid.properties内容===========*/  
driverClassName=com.mysql.jdbc.Driver  
url=jdbc:mysql://127.0.0.1:3306/db1  
username=root  
password=123  
initialSize=5  
maxActive=10  
maxWait=3000