JSP實現MySQL數據結構查詢

2019-11-17 04:10:43

字體：大中小

來源：轉載

供稿：網友

流程簡介:

登錄<----------->選擇數據庫<--------->選擇表<---------->顯示表結構

logout back back

0.數據庫處理的javabean:(我厚道吧,這都貼出來了)

MySQLmeans.java(位置:MySQL/mysqlmeans.java):

package MySQL;
import java.sql.*;
/**
*
* @author lucifer
*/

public class mysqlmeans {
     Connection con;
    String username = "";
    String passWord = "";
     String server = "";
     String dbname = "";
     public void setPRoperties(String serv,String db,String name,String pass){
          server = serv;
          dbname = db;
          username = name;
          password = pass;
     }

     public void setUserName(String username){
          this.username = username;
     }
     public String getUserName(){
          return username;
     }

     public void setPassword(String password){
          this.password = password;
     }
     public String getPassword(){
          return password;
     }

     public void setServer(String server){
          this.server = server;
     }
     public String getServer(){
          return server;
     }

     public void setDataBase(String daname){
          this.dbname = daname;
     }
     public String getDataBase(){
          return dbname;
     }

     public Connection getConnection(){
        try{
            Class.forName("com.mysql.jdbc.Driver");
            con = DriverManager.getConnection
                       ("jdbc:mysql://"+server+"/"+dbname+"?user="+username+"&password="+password, username, password);
            return con;
        }catch(Exception e){
            e.printStackTrace();
            return null;
        }
    }

    public void exeUpdate(String sql){
        Connection upCon = getConnection();
        try{
            Statement stmt = upCon.createStatement();
            stmt.executeUpdate(sql);
            stmt.close();
            upCon.close();
        }catch(Exception e){
            e.printStackTrace();
        }
    }

    public ResultSet getResult(String sql){
        ResultSet rs = null;
        try{
            Statement stmt = con.createStatement
                       (ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
            rs = stmt.executeQuery(sql);
        }catch(Exception e){
            e.printStackTrace();
        }
        return rs;
    }

    public void closeConnection(){
        try{
            con.close();
        }catch(Exception e){
            e.printStackTrace();
        }
    }

    public void closeResultSet(ResultSet rs){
        try{
            rs.close();
        }catch(Exception e){
            e.printStackTrace();
        }
    }

    public void closeStatement(Statement stmt){
        try{
            stmt.close();
        }catch(Exception e){
            e.printStackTrace();
        }
    }

}

1.登錄:

<%--
    Document   : choose
    Created on : 2009-10-5, 19:07:36
    Author     : lucifer
--%>

<%@page contentType="text/html" pageEncoding="UTF-8" errorPage="login_error.jsp"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"

<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>登錄</title>
    </head>
    <body bgcolor="#c0c0c0">
         <center>
              <font face="楷體" size="+3">
                   Sir_LuciFer<br>數據庫查詢系統
              </font>
              <br><br>
              <form method="post" action="chooseDataBase.jsp" name="form">
              <B>
              服務器：
              <input type="text" name="server" value="localhost"><br>
              用戶名：
              <input type="text" name="username" value="root"><br>
              密碼：
              <input type="password" name="password"><br>
              <input type="submit" value="Login!">
              </B>
         </form>
         </center>
    </body>
</html>
http://m.survivalescaperooms.com/

2.選擇要使用的數據庫:

chooseDataBase.jsp:

<%--
    Document   : choose
    Created on : 2009-10-5, 19:07:36
    Author     : lucifer
--%>

<%@page contentType="text/html" pageEncoding="UTF-8" import="java.sql.*"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
   "<jsp:useBean id="mysql" class="MySQL.mysqlmeans"/>
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>選擇數據庫</title>
        <scr ipt type="text/Javascript">
             function getDataBase(){
                  alert(document.getElementById("db").value)
             }
        </script>
    </head>
    <%
          String user = request.getParameter("username");
          String pass = request.getParameter("password");
          String serv = request.getParameter("server");
          mysql.setUserName(user);
          mysql.setPassword(pass);
          mysql.setServer(serv);
          String sql = "show databases";

          mysql.getConnection();
          ResultSet rs = mysql.getResult(sql);
    %>

    <body bgcolor="#c0c0c0">
         <center>
         <table border="1px">
              <tr>
                   <td>
                        數據庫：
                   </td>
              </tr>
              <%
                    while(rs.next()){%>
                    <tr>
                    <td>
                         <%=rs.getString("Database")%>
                    </td>
                         </tr>
                    <%
                    }
                    mysql.closeResultSet(rs);
                    mysql.closeConnection();
                %>
         </table>
         <form method="post" action="chooseTable.jsp" name="form">
              <B>
              請選擇數據庫名稱：
              </B>
              <input type="text" name="database" value="test"><br>
              <input type="hidden" name="username" value="<%=user%>">
              <input type="hidden" name="password" value="<%=pass%>">
              <input type="hidden" name="server" value="<%=serv%>">
              <input type="submit" value="USE!">
         </form>
         <form method="post" action="login.jsp">
                   <input type="submit" value="Logout!">
         </form>
         </center>
    </body>
</html>