jspÁ¬½ÓmysqlÊý¾Ý¿â²éѯ£¬²¢ÔÚÒ³ÃæÏÔʾ
jspÁ¬½ÓmysqlÊý¾Ý¿â²éѯ£¬²¢ÔÚÒ³ÃæÏÔʾ Öм䲻ÓÃstruts£¬ÔõôʵÏÖ£¬ÇóÀý×Ó
javabean ×öÁ¬½Ó
jsp Ò³ÃæÊµÀý»¯Àà
jsp Ò³ÃæÏÔʾÊý¾Ý
<%@ page contentType="text/html;
charset=gb2312" language="java"
import="java.sql.*"%>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<%//*******************************
****************
JDBC_ODBCÁ¬½ÓMySqlÊý¾Ý¿â£¬²»ÐèÒªÉèÖÃÊý¾ÝÔ´***********
**********************/
//********** Êý¾Ý¿âÁ¬½Ó´úÂë¡¡¿ªÊ¼ ******/
//ÒÔϼ¸ÏîÇë×ÔÐÐÐÞ¸ÄString server="localhost";
//MYSQL ·þÎñÆ÷µÄµØÖ·String dbname="test";
//MYSQL Êý¾Ý¿âµÄÃû×ÖString user="root";
//MYSQL Êý¾Ý¿âµÄµÇ¼Óû§ÃûString pass="chfanwsp";
//MYSQL Êý¾Ý¿âµÄµÇ¼ÃÜÂëString port="3306";
//SQL Server ·þÎñÆ÷µÄ¶Ë¿ÚºÅ£¬
ĬÈÏΪ1433//Êý¾Ý¿âÁ¬½Ó×Ö·û´®
String url ="jdbc:mysql://"+server+":"+port+"/"+dbname+"?
user="+user+"&passWord="+pass+"&useUnicode
=true&characterEncoding=GB2312";
//¼ÓÔØÇý¶¯³ÌÐòClass.forName("org.gjt.mm.mysql.Driver").newInstance
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÔÚjspÀïÃæ£¬Óøöselect¼ÈÄÜÊäÈë×Ô¶¯Æ¥ÅäÓÖÄÜÏÂÀÑ¡ÔñµÄ£¬ÔõôʵÏÖ£¿
²»»á¡£¡£¡£¡£¡£¡£°ï¶¥ ѧϰ¡£¡£
×Ô¶¯Æ¥ÅäʲôÒâ˼£¿¾ßÌåµã
¾ÍÊÇÄãÊäÈëÄÚÈݺ󣬺ÍÄãÄÚÈÝÏàͬѡÏîµÄ¶¼ÁгöÀ´
ÄãselectÊÇÏÂÀ¿ò¡£¡£ ......
ÎÒÊÇÓÃSTRUTS £¬×öÁËÒ»¸öJSPÒ³Ãæ£¬Ìá½»ºóûÓдæÈëÊý¾Ý¿â¡£
JSP´úÂëÈçÏ£º
aa.jsp´úÂë
<%@ page contentType="text/html;charset=gb2312" language="java"%>
<%@ taglib uri=" ......
jspѧϰǰҪÁ˽âÄÇЩ֪ʶ£¿Ñ§ÁËjavaÁË¡£²»ÖªµÀ»¹ÒªÑ§Ï°Ð©Ê²Ã´ÖªÊ¶²Å¿ÉÒԺܺõÄѧϰjsp
HTML¡¢JavaScript
Ö±½Óѧ¾Í¿ÉÒÔÁË£¬Óöµ½²»»á¾ÍÏÖѧ¾ÍÐС£
Html css servlet
È¥Á˽âä¯ÀÀÆ÷Óëweb·þÎñÆ÷µÄ¼òµ¥½» ......