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Îļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
//Óÿͻ§µÄsessionµÄid½¨Á¢Ò»¸öÁÙʱÎļþ£º
//String tempFileName=(String)session.getId();
String tempFileName = (String)session.getId();
//out.println(& ......
¸÷λ´óÏÀ¾ÈÃü°¡ £¡£¡
¸Õ×°ÁËSQL2000 sp3
ÏëÓÃJSPÁ¬½ÓÊý¾Ý¿âµ«ÊdzöÏÖÎÊÌâÁË
ÎÒÓõÄÊÇJDK6.0+tomcat5.0+SQL2000 SP3+JDBC sp3
ËüÏÔʾµÄÊÇ
javax.servlet.ServletException: [Microsoft][SQLServer 2000 Driver fo ......
Óм¸ÖÖÓû§£¬ÆäȨÏÞ²»Í¬¡£Ö»ÓÐÌØ¶¨È¨ÏÞµÄÓû§²ÅÄܽøÐÐÏàÓ¦²Ù×÷¡£ÎÒÏëÔÚjspÒ³ÃæÀï½øÐÐÕâ¸öÉèÖÃ
<input type="submit" value="ÐÞ¸Ä"/> ,ÎÒÏëÈÃÖ»ÓÐÌØ¶¨È¨ÏÞµÄÓû§²ÅÄܰ´Õâ¸ö°´Å¥£¬·ñÔò±¨ ......