JSP calls the Java class and queries the SQL database (1/2)

JSP Tutorial call Java class and query SQL database tutorial
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 Tutorial://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;
}

Home 1 2 last page