?????????????????????í?????×????????????
???é???÷?ú????????,??????????????????!????×?JSP????MYSQL??????????
JSP?????????????÷??????????
<%@page contentType="text/html;charset=gb2312"%>
<%
//?ù??
java.sql.Connection sqlConn;
java.sql.Statement sqlStmt;
java.sql.ResultSet sqlRst;
//regiester jdbc driver
String DBUser="d12345";
String DBPassword="12345678";
String DBServer="s509.now.net.cn"; // Can't use localhost , you must use IP or CNAME
String DBNAME="db_abc_com"; // change to your db name
Class.forName("org.gjt.mm.mysql.Driver"
.newInstance();
//connect to the database
sqlConn=java.sql.DriverManager.getConnection
("jdbc:mysql://"+DBServer+":3306/"+DBNAME+"?useUnicode=true&characterEncoding=gb2312", DBUser,DBPassword);
//create the driver handle
sqlStmt=sqlConn.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY);
//excute sql
//sqlRst=sqlStmt.executeQuery("select * from test"
;
%>
<html>
<head>
<title>Linux-JSP-JDBC-MYSQL TESTING -SELETCT copyright <a href="mailto:
sanry@newsea.net ">
sanry@newsea.net </a> </title>
</head>
<body>
<table border="1" cellspace ="0" align="center">
<tr><td>DB CONNECT OK , </td></tr>
<tr>
<th>title </th>
<th>type </th>
</tr>
<%// while(sqlRst.next()) {%>
<tr>
<td> <%//=sqlRst.getString(1)%></td>
<td><%//=sqlRst.getString(2)%></td>
</tr>
<%//}%>
</table>
</body>
</html>
<%
//sqlRst.close();
sqlStmt.close();
sqlConn.close();
%>
------------------------------------------------------------------------------------------------------
?????ê?????·??
http://www.now.net.cn/host
?????ê???ê?????????????§??,???????¨?ú??·???!!????
???±??±??????ó??????:
????????A 1800??/?ê 500M??????????+JSP+MYSQL??????
?ê?é?????÷??
http://now.net.cn/host/commerce. ... 8398da69fd1e85fafa9
????????B?÷?ú+.CN?ò?? ?§??PHP??±?????MYSQL?????? 1300 ??/?ê
?ê???é????500 Mb ????WEB???? ???????????? 50 Mb MYSQL?????? ??????????????800 Mb
???ò????C???÷?ú ??CN?ò?? ??800M ???????? 1600 ??/?ê
????????D 2300??/?ê 500M??????????+JSP+SQL SERVER 2000
?ê?é?????÷??
http://now.net.cn/host/commerce. ... 8398da69fd1e85fafa9
???é??ר????A 4300??/?ê 3000M??????????JSP+MYSQL??????
http://now.net.cn/host/vps.net?P ... 8398da69fd1e85fafa9
???ò?é??ר??C???÷?ú ??CN?ò?? ??2000M VIP ?ó?????? 4000 ??/?ê
???é??ר????D 4500??/?ê 3000M??????????JSP+SQL server 2000??????
http://now.net.cn/host/vps.net?P ... 8398da69fd1e85fafa9
??VIP??×????÷?ú 14000M ??????????10000M ???? ??4000M VIP ?ó?????? ?????ò?????????°???????? ???????????????ó??
?? ·????ó????±????????ú300??????,?ù??????.CN?ò??!!!
?? ?ì°?????????????????????????????+32???ù??????????1500????????·±??°?????
?ü?à??????????
http://www.now.net.cn/special
?±?ú????(
www.now.net.cn) ???é???÷?ú????·????? CDN ???ó???????? ?????ò?? ???????÷??·?????????????°????????÷??
???ò????????????CDN??????????
CDN???§????:
http://www.qianju.cn
http://www.molongjy.com/
???????°??????????????·????ùGCDN???ò?????????°????????
???ò??·?×??????°,?????÷
http://www.now.net.cn/customer/moreline.net
?????ú·????±?ú????
http://www.now.net.cn
Q Q????×?????108786612 405881840
TEL??0756-2281071 2281072 2281070
----------------------------------------------------------------------------------
?ó???????????÷???ó???????????ó??×??????????? ??·??ó???????????????ó????·±???ò????3???????????????????óAnti-SPAM·?????????????ר???±??????Anti-VIRUS?????????±×????±?? ????????????
http://www.now.net.cn/email/
?????¨??????3·??????¨???????????????????????×???¨????????????????×????ò???????????¨??????????·??????? ??
http://www.now.net.cn/auto/
·±?ò?¨???? 300 ?????????????ê????????·±????????·?±?????????????????·?????????
http://www.now.net.cn/fjt/
?????ò??????380?? ???????????????¨?????????????¨·?????·????÷????????????±?????×???·????÷??????·????÷??????·????÷??????·????÷????·?????????
http://www.now.net.cn/cyberip/