yanhua365’s gists

yanhua365 / del_svn_info.py

Last active August 29, 2015 13:57

删除svn文件的python代码

yanhua365 / UserDaoHibernate.java

Created February 17, 2014 09:00

Hibernate里使用Spring JdbcTemplate的代码。来自appfuse的UserDaoHibernate。

	public String getUserPassword(Long userId) {
	JdbcTemplate jdbcTemplate =
	new JdbcTemplate(SessionFactoryUtils.getDataSource(getSessionFactory()));
	Table table = AnnotationUtils.findAnnotation(User.class, Table.class);
	return jdbcTemplate.queryForObject(
	"select password from " + table.name() + " where id=?", String.class, userId);
	}

yanhua365 / mysqldump-sample.cmd

Created January 24, 2014 03:48

MySQL导出（备份）数据库的命令—— mysqldump 的用法

	几个常用用例：
	1.导出整个数据库
	mysqldump -u 用户名 -p 数据库名 > 导出的文件名
	mysqldump -u wcnc -p smgp_apps_wcnc > wcnc.sql
	2.导出一个表
	mysqldump -u 用户名 -p 数据库名表名> 导出的文件名
	mysqldump -u wcnc -p smgp_apps_wcnc users> wcnc_users.sql
	3.导出一个数据库结构
	mysqldump -u wcnc -p -d --add-drop-table smgp_apps_wcnc >d:\wcnc_db.sql
	-d 没有数据 --add-drop-table 在每个create语句之前增加一个drop table

yanhua365 / JpaNamedQueryAnnotationQueryHintsSample.java

Created January 23, 2014 06:28

Spring Data JPA 或 JPA Named Query里用注解声明Query Hint

	@Entity
	@NamedQuery(name="findProfessorNoCache",
	query="SELECT e FROM Professor e WHERE e.id = ?1",
	hints={@QueryHint(name="toplink.cache-usage", value="DoNotCheckCache")})
	public class Professor {
	@Id
	private int id;
	private String name;
	private long salary;

yanhua365 / SplitQueryParmas.java

Created January 20, 2014 05:26

用Java解析HTTP Request的params参数，生成一个Map的代码。http://stackoverflow.com/questions/13592236/parse-the-uri-string-into-name-value-collection-in-java

	public static Map<String, String> splitQuery(URL url) throws UnsupportedEncodingException {
	Map<String, String> query_pairs = new LinkedHashMap<String, String>();
	String query = url.getQuery();
	String[] pairs = query.split("&");
	for (String pair : pairs) {
	int idx = pair.indexOf("=");
	query_pairs.put(URLDecoder.decode(pair.substring(0, idx), "UTF-8"), URLDecoder.decode(pair.substring(idx + 1), "UTF-8"));
	}
	return query_pairs;
	}

yanhua365 / knockoutjs-updown-array.js

Created January 16, 2014 09:23

KnockoutJS 交换数组里元素的数据（实现上移，下移功能）

	function FilesViewModel() {
	var self = this;

	self.fileServers =ko.observableArray([{"url":"http://192.168.109.130/4337/"},{"url":"http://192.168.109.122/3366/"}});

	self.upFileServer = function() {
	var index = self.fileServers.indexOf(this);
	if(index > 0){
	var temp = self.fileServers()[index-1];
	self.fileServers.splice(index-1, 1);

yanhua365 / GetSessionFactoryFromEMF.java

Last active January 3, 2016 03:09

从JPA的EMF中得到Hibernate的SessionFactory，参考：http://www.jroller.com/RickHigh/entry/getting_sessionfactory_from_entitymanagerfactory_in

	public static SessionFactory getSessionFactory(EntityManagerFactory hemf) {
	return ((HibernateEntityManagerFactory)hemf).getSessionFactory();
	}

yanhua365 / OrderCommandsController.java

Created January 7, 2014 06:24

Spring MVC REST 实现返回不同状态的控制器，代码来自：http://spring.io/guides/tutorials/rest/2/

	@RequestMapping(method = RequestMethod.DELETE, value = "/{id}")
	public ResponseEntity<Order> cancelOrder(@PathVariable String id) {

	OrderDeletedEvent orderDeleted = orderService.deleteOrder(new DeleteOrderEvent(UUID.fromString(id)));

	if (!orderDeleted.isEntityFound()) {
	return new ResponseEntity<Order>(HttpStatus.NOT_FOUND);
	}

	Order order = Order.fromOrderDetails(orderDeleted.getDetails());

yanhua365 / SpringMvcModelAttributeSample.java

Created January 7, 2014 02:07

Spring MVC中用一个独立的私有方法指定@ModelAttribute属性。代码来源于：http://spring.io/guides/tutorials/web/5/

	@Controller
	@RequestMapping("/order/{orderId}")
	public class OrderStatusController {

	private static final Logger LOG = LoggerFactory
	.getLogger(OrderStatusController.class);

	@Autowired
	private OrderService orderService;

yanhua365 / bootstrap-tabs-sample.html

Created January 6, 2014 02:29

Bootstrap的Tab示例

	<ul class="nav nav-tabs" id="myTab">
	<li class="active"><a href="#home">Home</a></li>
	<li><a href="#profile">Profile</a></li>
	<li><a href="#messages">Messages</a></li>
	<li><a href="#settings">Settings</a></li>
	</ul>

	<div class="tab-content">
	<div class="tab-pane active" id="home">...</div>
	<div class="tab-pane" id="profile">...</div>

yanhua365 yanhua365