jsp調用java類並查詢sql資料庫(1/2)

jsp教程調用java類並查詢sql資料庫教程
package bean;
import java.sql.*;

public class MyDb_Page{
    private Statement stmt;
    private Connection conn=null;
    private ResultSet rs=null;
    private String navi;
   
    public void connection(String db_name,String user,String pwd) throws  Exception{
        Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
        String url="jdbc:mysql教程://www.111cn.net:3306/" + db_name;
        conn=DriverManager.getConnection(url,user,pwd);
        stmt=conn.createStatement();
    }
   
    public ResultSet query(String sql) throws Exception{
        rs=stmt.executeQuery(sql);
        return rs;
    }

    
   

首頁 1 2 末頁