package com.itquanmingxing.servlet;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
/**
* weixin: it_daimeng
*/
@WebServlet("/TestJdbcServlet4")
public class TestJdbcServlet4 extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
* @see HttpServlet#HttpServlet()
*/
public TestJdbcServlet4() {
super();
// TODO Auto-generated constructor stub
}
/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
//response.getWriter().append("Served at: ").append(request.getContextPath());
request.setCharacterEncoding("utf-8");
response.setContentType("text/html;charset=utf-8");
//1.创建一个驱动对象 并注册到驱动管理器中
try {
//加载类代码的时候会执行类中的静态代码
// java.sql.DriverManager.registerDriver(new Driver());
Class.forName("com.mysql.jdbc.Driver");
//2.创建一个连接对象(用来数据库)
Connection conn= DriverManager.getConnection("jdbc:mysql://localhost:3306/taobao", "root", "root");
//3.创建声明对象(语句命令对象) 传sql语句到数据库
Statement statement= conn.createStatement();
//4.执行sql语句
String sql="select * from student ";
//执行查询返回一个结果集
ResultSet rs=statement.executeQuery(sql);
//5.处理结果
//获得结果集中的列(字段)的信息
ResultSetMetaData resultSetMetaData= rs.getMetaData();
for(int i=1;i<=resultSetMetaData.getColumnCount();i++)
response.getWriter().println(resultSetMetaData.getColumnName(i));
//获得数据 每循环一次 获得一条记录
while(rs.next())
{
//第一种方式 :通过列名获得数据
//String sname= rs.getString("sname");
//第二种方式:通过列的编号获得数据
String sname=rs.getString(2);
int sid=rs.getInt("sid");
response.getWriter().println(sid);
}
//6.关闭连接
statement.close();
conn.close();
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
doGet(request, response);
}
}
javaee jdbc查询操作
最新推荐文章于 2023-09-27 22:05:07 发布