package org.lsy.servlet; import java.io.IOException; import java.io.PrintWriter; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; 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 MMC_01 extends HttpServlet { public static final String DBURL = "jdbc:mysql://localhost:3306/kui"; // 连接数据库的用户名 public static final String DBUSER = "root"; // 连接数据库的密码 public static final String DBPASS = "001011"; public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { //设置请求和响应的编码 ，不然页面上容易出现乱码 request.setCharacterEncoding("UTF-8"); response.setCharacterEncoding("UTF-8"); response.setContentType("text/html;UTF-8"); //输出流 PrintWriter out = response.getWriter(); //数据库连接代码 try { Connection conn = null; // 表示数据库的连接的对象 Statement stmt = null; // 表示数据库的更新操作 String sql="insert into student(name,calssGrent,result) values('PS4','2333',' 2998')"; System.out.println(sql) ; // 1、使用Class类加载驱动程序 Class.forName("com.mysql.jdbc.Driver"); // 2、连接数据库 conn = DriverManager.getConnection(DBURL, DBUSER, DBPASS); // 3、Statement接口需要通过Connection接口进行实例化操作 stmt = conn.createStatement(); ResultSet rs=stmt.executeQuery("select *from student"); out.println(""); out.println(""); out.println(" A Servlet"); out.println(" "); out.println("
设备管理系统"); out.println("
"); //输出表头部分 out.print(""); while(rs.next()) { //获取数据库中的ID String name=rs.getString("name"); //输出一列元素 out.print("" + "" + ""); } out.println(""); out.println(" "); out.println(""); conn.close(); } catch (Exception e) { e.printStackTrace(); } out.flush(); out.close(); } }
设备名称" + "数量价格修改删除
"+rs.getString("name") +""+rs.getString("calssGrent")+"" + ""+rs.getString("result")+"修改 删除
添加数据