JSP資料庫操作和調用自己寫的java類

標籤：

作為新手在這卡了很久，其實是個小問題

調用資料庫沒有直接用jsp直接調用資料，因為不知道為什麼那個drive總是配置不好

而是打算用java訪問資料庫，再讓jsp調用Java的介面

 

java代碼：

java必須有個自己的包，不能用預設的包名

package test;import java.sql.*;public class Mysql {        public Mysql(){        String driver = "com.mysql.jdbc.Driver";        // URL指向要訪問的資料庫名scutcs        String url = "jdbc:mysql://127.0.0.1:3306/ems";        String user = "root";        String password = "";        try {            // 載入驅動程式            Class.forName(driver);            Connection conn = DriverManager.getConnection(url, user, password);            if(!conn.isClosed())                System.out.println("Succeeded connecting to the Database!");            // statement用來執行SQL語句            Statement statement = conn.createStatement();            // 要執行的SQL語句            String sql = "select * from pm2_5";                        ResultSet rs = statement.executeQuery(sql);            System.out.println("-----------------");              System.out.println("-----------------");            String name = null;            while(rs.next()){                 name = rs.getString("mark");                //name = new String(name.getBytes("ISO-8859-1"),"utf-8");                //輸出結果                System.out.println(rs.getString("id") + "\t" + name);              }              rs.close();            conn.close();        } catch(ClassNotFoundException e) {            System.out.println("Sorry,can`t find the Driver!");               e.printStackTrace();           } catch(SQLException e) {               e.printStackTrace();           } catch(Exception e) {               e.printStackTrace();           }    }}

jsp代碼:

<%@ page language="java" contentType="text/html; charset=UTF-8"%><%@ page import="java.util.*" import="java.io.IOException"%><%@ page import="test.Mysql" %><%    out.println("哈哈");    new Mysql();%>

控制台輸出:

Succeeded connecting to the Database!----------------------------------1    E354266E-D5CF-8384-D589-A179F92AFEE52    E354266E-D5CF-8384-D589-A179F92AFEE53    E354266E-D5CF-8384-D589-A179F92AFEE54    E354266E-D5CF-8384-D589-A179F92AFEE55    E354266E-D5CF-8384-D589-A179F92AFEE56    E354266E-D5CF-8384-D589-A179F92AFEE57    E354266E-D5CF-8384-D589-A179F92AFEE58    E354266E-D5CF-8384-D589-A179F92AFEE59    E354266E-D5CF-8384-D589-A179F92AFEE510    E354266E-D5CF-8384-D589-A179F92AFEE511    E354266E-D5CF-8384-D589-A179F92AFEE512    E354266E-D5CF-8384-D589-A179F92AFEE513    E354266E-D5CF-8384-D589-A179F92AFEE514    E354266E-D5CF-8384-D589-A179F92AFEE515    E354266E-D5CF-8384-D589-A179F92AFEE516    E354266E-D5CF-8384-D589-A179F92AFEE5

 

然後封裝下java類就行了^_^

JSP資料庫操作和調用自己寫的java類