jsp连接Mysql

String url = "jdbc:mysql://localhost:3306/test";
   String user = "root";
   String password = "110";
   Connection conn = null;
   PreparedStatement pstmt = null;
   String driverName = "com.mysql.jdbc.Driver";
   try {

    Class.forName(driverName).newInstance();

    conn = DriverManager.getConnection(url, user, password);

   } catch (ClassNotFoundException e) {
    out.println(e);
   } catch (SQLException e) {
    out.println("连接SQLserver数据库失败!!!!!!");
   }

posted on 2012-12-24 09:33  Steven Yang  阅读(78)  评论(0)    收藏  举报

导航