//设置类对象
package code;
public class use {
private String id;
private String name;
private String pre_cno;
private String grade;
use a;
public String getId() {
return id;
}
public void setId(String id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getPre_cno() {
return pre_cno;
}
public void setPre_cno(String pre_cno) {
this.pre_cno = pre_cno;
}
public String getGrade() {
return grade;
}
public void setGrade(String grade) {
this.grade = grade;
}
}
//获取数据库连接
package code;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class test {
public static Connection conn=null;
// 加载数据库驱动 com.mysql.jdbc.Driver
public static Connection getConn(){
String driver = “com.mysql.jdbc.Driver”;
// 获取mysql连接地址
String url = “jdbc:mysql://localhost:3306/user?&useSSL=false&serverTimezone=UTC”;
// 数据名称
String username = “****”;//填自己的用户名
// 数据库密码
String password = “root”;
// 获取一个数据的连接
// 获取连接的一个状态
try{
Class.forName(driver);
//getConnection()方法,连接MySQL数据库!
conn=DriverManager.getConnection(url,username,password);
}
catch(ClassNotFoundException e){
//数据库驱动类异常处理
System.out.println("数据库驱动加载失败!");
e.printStackTrace();
}
catch(SQLException e1){
//数据库连接失败异常处理
e1.printStackTrace();
}
catch(Exception e2){
e2.printStackTrace();
}
return conn;
}
}
在这里插入代码片
package code;
import java.io.IOException;
import javax.servlet.ServletConfig;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
/**
* Servlet implementation class test01
*/
@WebServlet("/test01")
public class test01 extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
* @see HttpServlet#HttpServlet()
*/
public test01() {
super();
// TODO Auto-generated constructor stub
}
/**
* @see Servlet#init(ServletConfig)
*/
public void init(ServletConfig config) throws ServletException {
//