<%@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 CNAMEString DBNAME="db_abc_com"; // change to your db name
Class.forName("org.gjt.mm.mysql.Driver").newInstance();//connect to the databasesqlConn=java.sql.DriverManager.getConnection("jdbc:mysql://"+DBServer+":3306/"+DBNAME+"?useUnicode=true&characterEncoding=gb2312", DBUser,DBPassword);//create the driver handlesqlStmt=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><%/
扫码添加,工程师即时响应
扫码添加企业微信 添加时备注:机房 / 带宽需求,更快匹配方案
✓ 已收到,客服将即时与您联系
如需补充机房 / 带宽细节,可直接拨打热线或扫码加微
提交即表示同意我们通过电话 / 微信与您联系
1、云服务器2C 4G 5M 仅498元/年
2、cn域名注册仅需35元/1年
3、1U服务器托管 特惠中
[请选择以下任一渠道进行咨询]