testcon.jsp

来自「在线考试软件。 在线考试软件详细设计说明书：说明在线测试这一模块各部分的功能和」· JSP 代码 · 共 48 行

<%@ page contentType="text/html; charset=gb2312" language="java" %>
<%@ page import="java.sql.*"  %>


<%
    Connection con = null;
    Statement stmt = null;
    ResultSet rs = null;
    String DRIVER = "com.mysql.jdbc.Driver";
    String USERNAME = "cbd";
    String PASSWORD = "cbdcosoft@1";

    String CONNECTION_STRING = "jdbc:mysql://localhost/jsptestonline";

	try {
            Driver DriverJinghua = (Driver) Class.forName(DRIVER).newInstance();
            //Con = DriverManager.getConnection(CONNECTION_STRING,USERNAME,PASSWORD);
        }
        catch (ClassNotFoundException e) {
           out.println(" 1 Connection Driver Error: classNotFoundException");
           out.println(e.toString() );
        }
        catch (Exception e) {
           out.println("2 Connection Driver Error: Exception");
           out.println(e.toString() );
        }

        try {
			 //Con = DriverManager.getConnection(CONNECTION_STRING,USERNAME,PASSWORD);
            String strUrl = CONNECTION_STRING + "?user=" + USERNAME +
                "&password=" +
                PASSWORD + "&useUnicode=true&characterEncoding=gb2312";
            con = DriverManager.getConnection(strUrl);

            out.println("########Conncetion OK!");

        }

        catch (Exception e) {
            con = null;
            out.println("3 Connection Error");
            out.println(e.toString() );
        }
        finally{
            con=null;
        }
%>