JSP连接MySQL数据库
举个连接班级表的简单例子
MySQL中的班级表里面的数据展现到jsp页面让用户浏览
1.连接数据库
public class Dome {
public final static String URL="jdbc:mysql://localhost:3306/mysql?&useSSL=false&serverTimezone=UTC";
public final static String NAME="root";
public final static String PWD="123456";
private static Connection conn;
public static Connection getconn(){
try {
Class.forName("com.mysql.cj.jdbc.Driver");
try {
conn=DriverManager.getConnection(URL, NAME, PWD);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return conn;}
public static void release(Connection conn){
if (conn!=null) {
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}}}
public static void main