Skip to content

Instantly share code, notes, and snippets.

View dodangquan's full-sized avatar

Đỗ Đăng Quân dodangquan

View GitHub Profile
@dodangquan
dodangquan / tiles.xml
Last active August 29, 2015 14:27
Apache Tiles Template Demo
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE tiles-definitions PUBLIC
"-//Apache Software Foundation//DTD Tiles Configuration 2.0//EN"
"http://tiles.apache.org/dtds/tiles-config_2_0.dtd">
<tiles-definitions>
<definition name="template2" template="/WEB-INF/views/layout2.jsp">
<put-attribute name="home" value="" />
</definition>
@dodangquan
dodangquan / tiles.xml
Created August 9, 2015 06:22
Java-Blog
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE tiles-definitions PUBLIC
"-//Apache Software Foundation//DTD Tiles Configuration 2.0//EN"
"http://tiles.apache.org/dtds/tiles-config_2_0.dtd">
<tiles-definitions>
<definition name="common" template="/WEB-INF/layout/classic.jsp">
<put-attribute name="header" value="/WEB-INF/pages/common/header.jsp" />
<put-attribute name="content" value="" />
<put-attribute name="footer" value="/WEB-INF/pages/common/footer.jsp" />
</definition>
@dodangquan
dodangquan / user-detail.js
Last active August 29, 2015 14:27
Java-Blog: Show first tab, jquery form validate
$(document).ready(function() {
$('.nav-tabs a:first').tab('show');
});
$(document).ready(function() {
$('.triggerRemove').click(function(e) {
e.preventDefault();
$("#modalRemove .removeBtn").attr("href", $(this).attr("href"));
$("#modalRemove").modal();
});
SELECT * FROM [Sinh Vien]
WHERE [Ma Sinh Vien] NOT IN (
SELECT DISTINCT [Ma Sinh Vien] FROM [Bang Dang Ky]);
@dodangquan
dodangquan / Tìm danh sách môn học mà sinh viên chưa đăng ký.sql
Created August 9, 2015 06:44
Tìm danh sách môn học chưa đăng ký của sinh viên có MSV = 10
SELECT * FROM [Mon Hoc]
WHERE [Ma Mon Hoc] NOT IN (
SELECT A.[Ma Mon Hoc]
FROM (
SELECT S.*, B.[Ma Mon Hoc], B.[Thoi Gian Dang Ky]
FROM
[Sinh Vien] S RIGHT JOIN [Bang Dang Ky] B ON
S.[Ma Sinh Vien] = B.[Ma Sinh Vien]
) A
WHERE A.[Ma Sinh Vien] = 10);
SELECT * FROM [Mon Hoc]
WHERE [Ma Mon Hoc] NOT IN (
SELECT DISTINCT [Ma Mon Hoc] FROM [Bang Dang Ky]);
declare @current_offset int = 0;
declare @current_increment int = 2;
SET @current_offset = @current_offset + @current_increment;
SELECT * FROM [Sinh Vien]
ORDER BY [Ten Sinh Vien]
OFFSET @current_offset rows
fetch next @current_increment ROWS ONLY;
@dodangquan
dodangquan / Book.java
Created January 8, 2016 10:14
Project BookStore
package com.dangquan.webapp.bookstore.entity;
import org.apache.commons.lang3.builder.EqualsBuilder;
import org.apache.commons.lang3.builder.HashCodeBuilder;
import org.apache.commons.lang3.builder.ToStringBuilder;
import org.apache.commons.lang3.builder.ToStringStyle;
import org.hibernate.validator.constraints.NotEmpty;
import javax.persistence.Column;
import javax.persistence.Entity;
@dodangquan
dodangquan / BookController.java
Created January 18, 2016 01:00
Tùy chỉnh ngoại lệ không tìm thấy tài nguyên khi duyệt web
@Controller
public class BookController {
private static final Logger logger = LoggerFactory.getLogger(BookController.class);
@Autowired
@Qualifier("bookService")
private BookService bookService;
@Autowired
@dodangquan
dodangquan / form-validate.js
Created January 18, 2016 01:09
Form validate sử dụng jquery-validate plugin
/**
* Created by DangQuan on 16/1/2016.
*/
$(document).ready(
function () {
$('.form-validate').validate(
{
rules: {
"account.username": {
required: true,