This example is derived from the example of the Jsp,servlet Generation report course, using the MySQL database
Package Jdbc;import Java.sql.connection;import Java.sql.drivermanager;import java.sql.preparedstatement;import Java.sql.resultset;import Java.sql.sqlexception;import Java.sql.statement;public class JdbcConn {private static String url= "Jdbc:mysql://localhost:3336/testreport";p rivate static string username= "root";p rivate static string Password= "myoa888";p rivate static Connection conn;private static PreparedStatement ps;private static Statement St; private static ResultSet rs;public static Connection getconnection () {try {class.forname ("Com.mysql.jdbc.Driver"); conn =drivermanager.getconnection (URL, username, password);} catch (ClassNotFoundException e) {e.printstacktrace ();} catch (SQLException e) {e.printstacktrace ();} Return conn;}}
A static method to get JDBC mode connection