测试mysql数据库安装成功

import  java.sql. * ;
import  java.util. * ;
import  java.io. * ;
import  java.sql. * ;
public   class  mysql
  ... {
    Connection conn;
    String driver;
     String url;
    String user;
    String pwd;
    public mysql()
    ...{
        driver = "com.mysql.jdbc.Driver";;
        url="jdbc:mysql://localhost:3306/test";
        user   = "root";
        pwd    = "123+-*/";
        init();
    }
      public void init()
      ...{
           try...{
            Class.forName(driver);
            System.out.println("driver is ok");
            conn = DriverManager.
            getConnection(url,user,pwd);
            System.out.println("conection is ok");
           }catch(Exception e)
                ...{
                     e.printStackTrace();
                }
          }
  
    public static void main(String args [])
    ...{
        new mysql();
    }
}

 

 

<% @ page contentType = " text/html;charset=gb2312 " %>
<% @ page  import = " java.sql.* " %>
< html >
< body >
<% Class.forName( " com.mysql.jdbc.Driver " );
String url = " jdbc:mysql://localhost:3306/mysql " ;
String user = " root " ;
String password = " 123+-*/ " ;  // sa的登陆密码
Connection conn =  DriverManager.getConnection(url,user,password);
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql = " select * from user " ;
ResultSet rs = stmt.executeQuery(sql);
while (rs.next())  ... {%>
您的第一个字段内容为：<%=rs.getString(1)%>
您的第二个字段内容为：<%=rs.getString(2)%>
<%} %>
<% out.print( " 数据库操作成功，恭喜你 " ); %>
<% rs.close();
stmt.close();
conn.close();
%>
</ body >
</ html >