test
li{
list-style: none;
}
ul,li{
padding: 0;
margin: 0;
}
div{
width: 200px;
border:2px solid#fc9829;
border-radius: 8px;
}
ul{
width:190px;
magin: 0 auto;
}
li{
height: 47px;
line-height: 47px;
font-size: 12px;
font-weight: bold;
padding-left: 50px;
border-bottom: 1px dotted #929292;
}
a{
text-decoration: none;
color: #000;
}
a:hover{
color: #cc5a0f;
}
li:nth-of-type(1){
background: url(../img/icon_01.jpg) no-repeat 0px 0px;
}
li:nth-of-type(2){
background: url(../img/icon_02.jpg) no-repeat 0px 0px;
}
li:nth-of-type(3){
background: url(../img/icon_03.jpg) no-repeat 0px 0px;
}
li:nth-of-type(4){
background: url(../img/icon_04.jpg) no-repeat 0px 0px;
}
li:nth-of-type(5){
background: url(../img/icon_05.jpg) no-repeat 0px 0px;
}
li:nth-of-type(6){
background: url(../img/icon_06.jpg) no-repeat 0px 0px;
}
li:nth-of-type(7){
background: url(../img/icon_07.jpg) no-repeat 0px 0px;
}
li:nth-of-type(8){
background: url(../img/icon_08.jpg) no-repeat 0px 0px;
}
li:nth-of-type(9){
background: url(../img/icon_09.jpg) no-repeat 0px 0px;
}
li:nth-of-type(10){
background: url(../img/icon_10.jpg) no-repeat 0px 0px;
border-bottom: none;
}
productlist 文件要关联下
<link rel="stylesheet" type="text/css" href="css/a.css">
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8" />
<title>test</title>
</head>
<body>
<h2>热门活动</h2>
<ul>
<li><img src="img/img1.png" alt=""><p>推荐活动|原创音乐现金榜T榜</p> </li>
<li><img src="img/img2.png" alt=""><p>推荐节目|《TAImusic》爆笑来袭</p> </li>
<li><img src="img/img3.png" alt=""><p>推荐歌单|继续宠爱张国荣</p> </li>
<li><img src="img/img4.png" alt=""><p>推荐活动|330金属音乐巡演 成都小酒馆音乐空间</p> </li>
</ul>
</body>
</body>
</html>
#/先创建一个数据库，名称为mydb/
CREATE DATABASE mydb;
#/再创建数据库表student/
CREATE TABLE student(
studentno INT(4) NOT NULL PRIMARY KEY,
studentname VARCHAR(50) NOT NULL,
sex CHAR(2) NOT NULL DEFAULT '女',
age INT(4) NOT NULL,
gradeid INT(4) NOT NULL
)CHARSET=utf8;
INSERT INTO student VALUES(10000,'张三','女',18,1);
INSERT INTO student VALUES(10001,'李四','男',19,2);
INSERT INTO student VALUES(10002,'王五','男',18,3);
INSERT INTO student VALUES(10003,'赵六','女',18,1);
SELECT * FROM student WHERE sex='女' ORDER BY age;
SELECT COUNT(*) FROM student WHERE gradeid=1;
#tagSQL
