ͨ¹ýjsp(SUNÆóÒµ¼¶Ó¦ÓõÄÊ×Ñ¡)³ÌÐò»ñµÃdatabaseÀïµÄÊý¾Ý£¬È»ºóͨ¹ý³ÌÐò¿ØÖÆÆäÏÔʾ·½Ê½£¬ÕâÖÖ·½Ê½Ã÷ÏÔȱµãÊÇÈç¹ûÊý¾ÝÁ¿±È½Ï´óµÄʱºò»áÓÐÃ÷ÏÔµÄÐÔÄÜϽµ
ÏÖ½«²âÊÔ´úÂë·îÉÏ£¬¾¡¹ÜÎÒ¾¡Á¿ÏÞÖÆ´úÂëµÄ³¤¶È
ÏÈ˵Ï¿ª·¢²½Ö裻DB½Å±¾£¬²âÊÔ»ñµÃµÄÊý¾ÝÊÇ·ñÕýÈ·µÄÏÔʾÔÚÒ»¸ötableÖУ¬Ìí¼ÓÄÇЩ¸ÃÏÔʾÄÇЩ²»¸ÃÏÔʾ£¬Ìí¼ÓÁËÊ×Ò¶ÉÏÒ¶ÏÂҶβҶµÄ¹¦ÄÜ£¬Ìí¼Óµ±Ç°Î»ÖñêÇ©±ÈÈç4/5£¬Ìí¼ÓÖ±½ÓÌøתµ½Ä³Ò³µÄ¹¦ÄÜ£¬´¦ÀíµôһЩbug¡£¡£
1¡£ÏÈдÊý¾Ý¿â¶Ë²âÊԽű¾£º
--ɾ³ý±í
drop table person;
--½¨Á¢±í
create table person (
id int auto_increment not null Prima(×îÍêÉƵÄÐéÄâÖ÷»ú¹ÜÀíϵͳ)ry key ,
uid varchar(32),
name varchar(32),
password varchar(20)
);
--²åÈëÊý¾Ý£¿²»Ö§³ÖÖÐÎÄ£¬±ØÐëÖ¸¶¨±íÄÚͶӰ,²åÈë¶àÓÚ30Ìõ¼Ç¼ÓÃÓÚ²âÊÔ·ÖÒ³
insert into person(uid,name,password) values('uid1','testname','123456');
insert into person(uid,name,password) values('uid1','testname','123456');
insert into person(uid,name,password) values('uid1','testname','123456');
insert into person(uid,name,password) values('uid1','testname','123456');
insert into person(uid,name,password) values('uid1','testname','123456');
insert into person(uid,name,password) values('uid1','testname','123456');
insert into person(uid,name,password) values('uid1','testname','123456');
insert into person(uid,name,password) values('uid1','testname','123456');
insert into person(uid,name,password) values('uid1','testname','123456');
--ÊÂÎñÌá½»
2¡£Õû¸ö³ÌÐò²¿·Ö¡£
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@page import="java.sql.*"%>
<html>
<head>
<title>jsp(SUNÆóÒµ¼¶Ó¦ÓõÄÊ×Ñ¡)ͨ¹ý³ÌÐòÀ´¿ØÖÆ·ÖÒ³</title>
<script type="text/javascript">
function openPage(currentpage) {
document.getElementById("cp").value = currentpage;
&nbs
JSPͬÑùÊÇʵÏÖ¶¯Ì¬ÍøÒ³µÄÒ»¸öÀûÆ÷¡£ÓÉÓÚËûµÄ½Å±¾ÓïÑÔÊÇJAVA£¬ËùÒԼ̳ÐÁËJAVAÖî¶àÓŵ㡣ÄÇôÓëASPÏà±È£¬Ó¦¸Ã¿ÉÒÔ˵ASPºÍJSP»ù±¾²»ÊÇÒ»¸öµµ´ÎÉϵġ£ÄÇôASP.NETºÍJAVAÈ´ÊÇ¿ÉÒÔ¿¹ºâµÄ¡£
JSPºÍASPÏà±È½Ï£º ÔËÐÐËٶȡ¢ÔËÐпªÏú¡¢ÔËÐÐƽ̨¡¢À©Õ¹ÐÔ¡¢°²È«ÐÔ¡¢º¯ÊýÖ§³Ö¡¢³§ÉÌÖ§³Ö¡¢¶ÔXMLµÄÖ§³ÖµÈµÈ£¬ASP¶¼²»ÊÇJSPµÄ¶ÔÊÖ¡£COM ......