- 浏览: 263319 次
- 性别:
- 来自: 济南
文章分类
- 全部博客 (303)
- c (31)
- c++ (16)
- java (18)
- c# (1)
- python (3)
- java web (6)
- oracle (7)
- sqlserver (2)
- mysql (2)
- android (24)
- android系统 (15)
- android多媒体部分 (15)
- android游戏 (12)
- linux (26)
- javaScript (1)
- ajax (1)
- node JS (2)
- html (5)
- apache (3)
- jboss (1)
- weblogic (0)
- 通信协议 (10)
- 云计算 (1)
- 分布式 (5)
- ejb (1)
- webservice (5)
- 设计模式 (16)
- JNI (6)
- swing (13)
- 版本控制 (1)
- UML (1)
- xml (4)
- spring (5)
- hibernate (5)
- struts1 (3)
- struts2 (4)
- ibatis (0)
- tomcat (2)
- 心得体会 (1)
- css (1)
- 嵌入式 (41)
- arm体系结构 (10)
thread local(thread 的局部变量)解决多线程并发,为每个使用该变量的线程提供独
立的副本,
jdk5.0后,threadlocal支持泛型
接口方法:
//设置当前线程中局部变量的值
void set(Object value)
//返回当前线程对应的局部变量
public Object get()
//删除当前线程局部变量的值
public void remove()
//返回当前线程局部变量的初始值
protected Object initialValue()
示例程序
所需jar 包
commons-logging-1.1.1.jar
junit-4.10.jar
log4j-1.2.15.jar
log4jdbc4-1.2.jar
mysql-connector-java-5.1.7-bin.jar
slf4j-api-1.6.1.jar
slf4j-log4j12-1.6.1.jar
/*==============================================================*/
/* DBMS name: MySQL 5.0 */
/* Created on: 2012-11-8 11:58:12 */
/*==============================================================*/
drop table if exists t_classroom;
drop table if exists t_student;
drop table if exists t_student_classroom;
/*==============================================================*/
/* Table: t_classroom */
/*==============================================================*/
create table t_classroom
(
roomid varchar(16) not null,
roomname varchar(16),
primary key (roomid)
);
/*==============================================================*/
/* Table: t_student */
/*==============================================================*/
create table t_student
(
sno varchar(8) not null,
sname varchar(16),
sage int,
gender varchar(16),
sbrith date,
primary key (sno)
);
/*==============================================================*/
/* Table: t_student_classroom */
/*==============================================================*/
create table t_student_classroom
(
sno varchar(8) not null,
roomid varchar(16) not null,
primary key (sno, roomid)
);
alter table t_student_classroom add constraint FK_fk_roomid foreign key (roomid)
references t_classroom (roomid) on delete restrict on update restrict;
alter table t_student_classroom add constraint FK_fk_sno foreign key (sno)
references t_student (sno) on delete restrict on update restrict;
示例代码如下:
/**
* 教室
*
* @time 下午2:41:21
* @author retacn yue
* @Email zhenhuayue@sina.com
*/
public class ClassRoom {
private String classRoomId;
private String classRoomName;
public String getClassRoomId() {
return classRoomId;
}
public void setClassRoomId(String classRoomId) {
this.classRoomId = classRoomId;
}
public String getClassRoomName() {
return classRoomName;
}
public void setClassRoomName(String classRoomName) {
this.classRoomName = classRoomName;
}
}
/**
* 学生
*
* @time 下午2:40:57
* @author retacn yue
* @Email zhenhuayue@sina.com
*/
public class Student {
private String sNo;
private String sName;
private String sAge;
private String gender;
private String sBirth;
private String classRoomId;
private String classRoomName;
public String getsNo() {
return sNo;
}
public void setsNo(String sNo) {
this.sNo = sNo;
}
public String getsName() {
return sName;
}
public void setsName(String sName) {
this.sName = sName;
}
public String getsAge() {
return sAge;
}
public void setsAge(String sAge) {
this.sAge = sAge;
}
public String getGender() {
return gender;
}
public void setGender(String gender) {
this.gender = gender;
}
public String getsBirth() {
return sBirth;
}
public void setsBirth(String sBirth) {
this.sBirth = sBirth;
}
public String getClassRoomId() {
return classRoomId;
}
public void setClassRoomId(String classRoomId) {
this.classRoomId = classRoomId;
}
public String getClassRoomName() {
return classRoomName;
}
public void setClassRoomName(String classRoomName) {
this.classRoomName = classRoomName;
}
}
dao层=========================================================
/**
* 教室dao接口
*
* @time 下午2:48:13
* @author retacn yue
* @Email zhenhuayue@sina.com
*/
public interface ClassRoomDao {
public void addStudentRoom(String roomid, String sNo) throws
Exception;
}
public class ClassRoomDaoImpl implements ClassRoomDao {
/**
* 添加教室
*/
@Override
public void addStudentRoom(String roomid, String sNo) throws
Exception {
Connection conn = null;
PreparedStatement pstmt = null;
conn = ConnectionManager.getConnection();
try {
pstmt = conn.prepareStatement("insert into
t_student_classroom(roomid,sno)values(?,?)");
pstmt.setString(1, roomid);
pstmt.setString(2, sNo);
pstmt.executeUpdate();
} catch (SQLException e) {
throw new Exception("add studentClassRoom" +
e.getMessage(), e);
// e.printStackTrace();
} finally {
try {
if (pstmt != null) {
pstmt.close();
pstmt = null;
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
/**
* 学生dao接口
*
* @time 下午2:46:30
* @author retacn yue
* @Email zhenhuayue@sina.com
*/
public interface StudentDao {
public void addStudent(Student student) throws Exception;
}
public class StudentDaoImpl implements StudentDao {
/**
* 添加学生
*/
@Override
public void addStudent(Student student) throws Exception {
Connection conn = null;
PreparedStatement pstmt = null;
conn = ConnectionManager.getConnection();
try {
pstmt = conn.prepareStatement(" insert into
t_student(sno, sname, sage, gender, sbrith) values (?,?,?,?,?)");
pstmt.setString(1, student.getsNo());
pstmt.setString(2, student.getsName());
pstmt.setString(3, student.getsAge());
pstmt.setString(4, student.getGender());
pstmt.setString(5, student.getsBirth());
pstmt.executeUpdate();
} catch (SQLException e) {
throw new Exception("add student " + e.getMessage
(), e);
// e.printStackTrace();
} finally {
try {
if (pstmt != null) {
pstmt.close();
pstmt = null;
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
service层===================================================
/**
*
* @time 下午3:03:30
* @author retacn yue
* @Email zhenhuayue@sina.com
*/
public interface StudentService {
public void addStudent(Student student);
}
/**
*
* @time 下午3:04:46
* @author retacn yue
* @Email zhenhuayue@sina.com
*/
public class StudentServiceImpl implements StudentService {
/**
* 添加学生
*/
@Override
public void addStudent(Student student) {
StudentDao studentDao = new StudentDaoImpl();
ClassRoomDao classRoomDao = new ClassRoomDaoImpl();
try {
// 开 启事务
ConnectionManager.BeginTrans(true);
studentDao.addStudent(student);
classRoomDao.addStudentRoom
(student.getClassRoomId(), student.getsNo());
// 提交事务
ConnectionManager.commit();
} catch (Exception e) {
// 回滚
ConnectionManager.rollback();
e.printStackTrace();
} finally {
try {
// 关闭联接
ConnectionManager.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
工具类================================================
/**
* 读取jdbc配置文件
*
* @time 下午1:32:22
* @author retacn yue
* @Email zhenhuayue@sina.com
*/
public class JdbcProperies {
@SuppressWarnings("unused")
private static Log logger = LogFactory.getLog
(JdbcProperies.class);
public static Properties getPropObjectFromFile() {
Properties properties = new Properties();
// 取得当前线程的类加载器
ClassLoader classLoader = Thread.currentThread
().getContextClassLoader();
URL url = classLoader.getResource("jdbc.properties");
if (url == null) {
classLoader = ClassLoader.getSystemClassLoader();
url = classLoader.getResource("jdbc.properties");
}
System.out.println("=======" + url);
File file = new File(url.getFile());
InputStream inputStream = null;
try {
inputStream = new FileInputStream(file);
properties.load(inputStream);
} catch (IOException e) {
properties = null;
e.printStackTrace();
} finally {
try {
if (inputStream != null) {
inputStream.close();
}
} catch (IOException e) {
e.printStackTrace();
}
}
return properties;
}
}
/**
* 数据库连接工具类
*
* @time 下午1:25:59
* @author retacn yue
* @Email zhenhuayue@sina.com
*/
public class DBConnection {
private static Connection conn = null;
private static DBConnection instance = null;
private static Properties jdbcPro = null;
private static String driveName = null;
private static String userName = null;
private static String pwd = null;
private static String url = null;
/**
* 构造器
*/
private DBConnection() {
}
/**
* 读取配置文件
*
* @return
*/
private static Properties getConfigFromPropertiesFile() {
Properties properties = null;
properties = JdbcProperies.getPropObjectFromFile();
return properties;
}
/**
* 初始化配置文件
*/
private static void initJdbcParameters(Properties properties) {
driveName = properties.getProperty("driver");
userName = properties.getProperty("user");
pwd = properties.getProperty("password");
url = properties.getProperty("url");
}
/**
* 取得connection对象
*
* @return
*/
public static Connection getConnection() {
return conn;
}
/**
* 取得DBConnection对象(单例)
*
* @return
* @throws Exception
*/
public synchronized static DBConnection getInstance() throws
Exception {
if (instance == null) {
jdbcPro = getConfigFromPropertiesFile();
instance = new DBConnection();
}
initJdbcParameters(jdbcPro);
createConnection();
return instance;
}
/**
* 建立连接
*
* @throws Exception
*/
private static void createConnection() throws Exception {
Class.forName(driveName);
conn = DriverManager.getConnection(url, userName, pwd);
}
}
/**
*
* 数据据事务管理工具类
*
* @time 下午1:22:41
* @author retacn yue
* @Email zhenhuayue@sina.com
*/
@SuppressWarnings({ "rawtypes", "unchecked" })
public class ConnectionManager {
private static ThreadLocal tl = new ThreadLocal();
private static Connection conn = null;
/**
* 是否开启事务
*
* @param beginTrans
* @throws Exception
*/
@SuppressWarnings({ "static-access" })
public static void BeginTrans(boolean beginTrans) throws Exception
{
if (tl.get() == null || ((Connection) tl.get()).isClosed
()) {
conn = DBConnection.getInstance().getConnection();
if (beginTrans) {
conn.setAutoCommit(false);
}
tl.set(conn);
}
}
/**
* 取得connection对象
*
* @return
*/
public static Connection getConnection() {
return (Connection) tl.get();
}
/**
* 关闭事务
*
* @throws SQLException
*/
public static void close() throws SQLException {
try {
((Connection) tl.get()).setAutoCommit(true);
} catch (SQLException e) {
e.printStackTrace();
}
((Connection) tl.get()).close();
tl.set(null);
}
/**
* 提交
*/
public static void commit() {
try {
((Connection) tl.get()).commit();
} catch (SQLException e) {
e.printStackTrace();
}
try {
((Connection) tl.get()).setAutoCommit(true);
} catch (SQLException e) {
e.printStackTrace();
}
}
/**
* 回滚
*/
public static void rollback() {
try {
((Connection) tl.get()).rollback();
} catch (SQLException e) {
e.printStackTrace();
}
try {
((Connection) tl.get()).setAutoCommit(true);
} catch (SQLException e) {
e.printStackTrace();
}
}
}
配置文件==============================================
driver = com.mysql.jdbc.Driver
password = ******
url = jdbc:mysql://localhost:3306/threadlocal
user = root
hibernate 里的
getCurrentSession
在hibernate配置文件中需要声明
<!-- 启用session的线程本地化技术,将session绑定到当前的线程
,实现session的传播(service层面上实现事务管理)-->
<property
name="current_session_context_class">thread</property>
openSession和getCurrentSession的区别
openSession需要在finally中关闭
getCurrentSession只需调用rollback和commit就可以
使用场景
service方法中如果对多个dao进行操作,可使用getCurrentSession
参考博客
http://blog.csdn.net/lifetragedy/article/details/7751059
发表评论
-
mina 学习笔记一
2012-11-05 16:33 622mina下载路径 http://mina.apache.or ... -
多线程学习笔记一
2012-09-04 11:03 655/** * 子线程循环10次,主线程100次 如此 ... -
多线程学习笔记二
2012-09-04 11:05 630/** * 传统线程 * * @time 下午06:15 ... -
多线程学习笔记三
2012-09-04 11:06 616/** * 两个线程进行数据交换 * * @time 上 ... -
多线程学习笔记四
2012-09-04 11:08 660/** * 线程范围内的数据共享 * * 应用场景:减少 ... -
java swing 学习笔记一(画板Panel )
2012-09-04 11:18 1074/** * 画板 * * @time 3:38:10 P ... -
java swing学习笔记二(画布Canvas)
2012-09-04 11:19 3253/** * 画布 * @time 11:23:53 AM ... -
java IO流学习笔记一
2012-09-08 17:10 561IO 两大主流 16位和8位 16位对应writer和rea ... -
java 类装载器
2012-09-08 18:12 702public class ClassLoaderTest { ... -
并发库学习笔记一
2012-09-28 16:37 635新建线程并启动的几种 ... -
并发库学习笔记二
2012-09-28 16:38 457阻塞队列(生产者和消费者开发模式) 三种常用的阻塞队 Ar ... -
并发库学习笔记三
2012-09-28 16:40 593Synchronized是lock的一种简化实现,一个l ... -
并发库学习笔记四
2012-09-28 16:42 662ConcurrentHashMap并没有实现Lock-Free ... -
并发库学习笔记五
2012-09-28 16:43 729并发流程控制CountDown ... -
java IO流学习笔记二
2012-10-03 00:24 630/** * * * 目录分隔符用\\或/ * * @ ... -
jdk5.0的特性
2012-10-03 00:28 6411静态导入 导入指定类 ... -
java IO流学习笔记三
2012-10-04 23:39 720转换流 inputStreamReader 字节转字符 o ...
相关推荐
本资源摘要信息中,我们将对CUDA学习笔记进行详细的知识点梳理,涵盖了CUDA程序架构、Thread管理、存储器体系、混合编程、CUDA程序接口描述等方面的知识点。 1. CUDA 程序架构 CUDA 程序架构中引入了Kernels的...
这份"C++多线程学习笔记1"涵盖了基础到进阶的多线程概念,旨在帮助初学者快速掌握这一关键技能。 首先,C++11引入了对多线程的支持,引入了`<thread>`库,使得创建和管理线程变得简单。创建一个新的线程可以使用`...
### ACE网络编程学习笔记知识点详解 #### 一、面向对象中间件体系结构 **1.1 主机基础设施中间件** 主机基础设施中间件的主要目的是封装不同的底层实现,例如socket和线程,提供统一的接口给上层应用。这种封装有...
** BoneCP 连接池学习笔记 ** BoneCP 是一个高效、轻量级的 Java 数据库连接池(JDBC Connection Pool)实现。它在性能上优于其他同类连接池,如 C3P0 和 DBCP,尤其适用于高并发场景。在深入理解 BoneCP 之前,...
### C#学习笔记知识点梳理 #### 一、基础篇知识点详解 **1. 重写ToString()方法** 在C#中,每个类都继承自`object`类,而`object`类有一个`ToString()`方法,它返回对象的类型名称。当我们需要对一个对象进行更加...
4. **线程局部存储**:`std::thread_local`关键字用于声明线程局部变量,每个线程拥有该变量的独立副本,避免了多线程环境中的共享状态问题。 5. **线程池**:线程池是一种管理线程资源的技术,可以预先创建一定...
### Java课堂笔记精要 #### 第一章 SQL Server 基本操作 ##### SQL Server 操作须知 1. **安装路径**: 安装文件及其安装路径都不能包含中文字符,否则可能会导致安装失败或出现其他错误。 2. **版本有效期**: 如果...
- `thread_local`:声明线程局部变量。 - `const`:使变量不可变,全局`const`变量具有内部链接性。 - `volatile`:指示变量可能被外部因素改变,禁止编译器优化。 - `mutable`:允许在`const`对象中修改成员。 ...