haihongyuan.com
海量文库 文档专家
全站搜索:
您现在的位置:首页 > 初中教育 > 初中作文初中作文

emp

发布时间:2014-01-06 11:36:03  

create table lqb_emp(
id bigint primary key auto_increment,
name varchar(50) unique,
salary double,
age int);
create table t_computer(
id int primary key auto_increment,
mosel varchar(50),
pic varchar(100),
prodDesc text,
price double);


create table mv_emp(
id int primary key auto_increment,
name varchar(50),
pic varchar(50) )default charset=utf8;

insert into f_user (username,name,pwd,age,gender,phone,ask) values('lvqibin01','lvqibin','123456',11,'f','111','goodBay');

insert into t_sale(name,qty) values('kkk',1111);

insert into mv_emp(name,pic,age,favor) values('mm8','7.png',18,'cooking');


create table t_sale(
id int primary key auto_increment,
name varchar(50),
qty int ) default charset=utf8;


jdbc:mysql://localhost:3306/lvqibin?useUnicode=true&characterEncoding=utf8


creat table t_computer( id int primary key auto_incermet, mosel varchar(50), pic varchar(100), prodDesc text, price double);

<package name="struts" extends="struts-default">
<action name="demo01" class="lvqibin.WecomeAction">
<result name="success">/demo01.jsp</result>
<result name="fil">/nameform.jsp</result>
</action>
<action name="nameform"class="lvqibin.NameAction">
<result name="success">/nameform.jsp </result>
</action>
</package>

<%@page pageEncoding="utf-8" contentType="utf-8" isELIgnored="false"%>


<meta http-equiv="Content-Type" content="text/palin; charset=UTF-8">
<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>


<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE struts PUBLIC
"-//Apache Software Foundation//DTD Struts Configuration 2.0//EN"
"http://struts.apache.org/dtds/struts-2.1.7.dtd">
<struts>



<c:forEach var="list" items="${list}">



<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE struts PUBLIC
"-//Apache Software Foundation//DTD Struts Configuration 2.0//EN"
"http://struts.apache.org/dtds/struts-2.1.7.dtd">
<struts>

<package name="mm" extends="struts-default">
<action name="mmlist" class="qq.ListAction">
<result name="success">META-INF/jsp/dome05_1.jsp</result>
</action>
</package>
</struts>


select * from mv_emp limit?(开始位置),?(一页的条数目)表单分页(mysql特有)



<!-- <script type="text/javascript" src="js/jquery-1.4.3.js"></script>-->
<!-- <script type="text/javascript">-->
<!-- $(function(){-->
<!-- $("a:first").bind("click",function(){-->
<!-- alert($("#id").val);-->
<!-- if($("#id").val=0){-->
<!-- $("a:first").hide();-->
<!-- }-->
<!-- });-->
<!-- });-->
<!-- </script>-->



<!-- <c:choose>-->
<!-- <c:when test="${page gt 1}">-->
<!-- <a href="pagelist.action?page=1">第一页</a>-->
<!-- <a href="pagelist.action?page=${page-1 }">上一页</a>-->
<!-- </c:when>-->
<!-- <c:otherwise>-->
<!-- <a>第一页</a>-->
<!-- <a>下一页</a>-->
<!-- </c:otherwise>-->
<!-- </c:choose>-->
<!-- |第${page}页|总页数为:${maxPage}-->
<!-- <c:choose>-->
<!-- <c:when test=

"${page lt maxPage }">-->
<!-- <a href="pagelist.action?page=${page+1 }">下一页</a>-->
<!-- <a href="pagelist.action?page=${maxPage }">最后一页</a>-->
<!-- </c:when>-->
<!-- <c:otherwise>-->
<!-- <a>下一页</a>-->
<!-- <a>最后一页</a>-->
<!-- </c:otherwise>-->
<!-- </c:choose>-->

上一篇:写给妈妈
下一篇:感受友谊
网站首页网站地图 站长统计
All rights reserved Powered by 海文库
copyright ©right 2010-2011。
文档资料库内容来自网络,如有侵犯请联系客服。zhit326@126.com