testcon.jsp
Upload User: nbluoke
Upload Date: 2013-08-09
Package Size: 4851k
Code Size: 1k
Development Platform:

WORD

  1. <%@ page contentType="text/html; charset=gb2312" language="java" %>
  2. <%@ page import="java.sql.*"  %>
  3. <%
  4.     Connection con = null;
  5.     Statement stmt = null;
  6.     ResultSet rs = null;
  7.     String DRIVER = "com.mysql.jdbc.Driver";
  8.     String USERNAME = "cbd";
  9.     String PASSWORD = "cbdcosoft@1";
  10.     String CONNECTION_STRING = "jdbc:mysql://localhost/jsptestonline";
  11. try {
  12.             Driver DriverJinghua = (Driver) Class.forName(DRIVER).newInstance();
  13.             //Con = DriverManager.getConnection(CONNECTION_STRING,USERNAME,PASSWORD);
  14.         }
  15.         catch (ClassNotFoundException e) {
  16.            out.println(" 1 Connection Driver Error: classNotFoundException");
  17.            out.println(e.toString() );
  18.         }
  19.         catch (Exception e) {
  20.            out.println("2 Connection Driver Error: Exception");
  21.            out.println(e.toString() );
  22.         }
  23.         try {
  24.  //Con = DriverManager.getConnection(CONNECTION_STRING,USERNAME,PASSWORD);
  25.             String strUrl = CONNECTION_STRING + "?user=" + USERNAME +
  26.                 "&password=" +
  27.                 PASSWORD + "&useUnicode=true&characterEncoding=gb2312";
  28.             con = DriverManager.getConnection(strUrl);
  29.             out.println("########Conncetion OK!");
  30.         }
  31.         catch (Exception e) {
  32.             con = null;
  33.             out.println("3 Connection Error");
  34.             out.println(e.toString() );
  35.         }
  36.         finally{
  37.             con=null;
  38.         }
  39. %>