package servlet;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class Servlet extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=utf-8");
request.setCharacterEncoding("utf-8");
//注册驱动
try {
Class.forName("com.mysql.jdbc.Driver");
// 获取连接
Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/school","root","ok");
//得到执行语句的statement对象
Statement statement = connection.createStatement();
String sql="select * from grade";
ResultSet resultSet = statement.executeQuery(sql);
while ( resultSet.next()) {
System.out.println(resultSet.getInt(1)+resultSet.getString(2));
//第一列是Int类型的。第二列是String类型。
}
statement.close();
connection.close();
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doGet(request, response);
response.setContentType("text/html");
}
}
jdbc链接mysql数据库,并查询
最新推荐文章于 2024-04-09 23:17:20 发布