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 { out.print("

\r\n" + "设备名称：

\r\n" + ""+ ""); Connection conn = null; // 表示数据库的连接的对象 Statement stmt = null; // 表示数据库的更新操作 String sql="insert into student(name,calssGrent,result) values('PS的4','3的3',' 发98')"; 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.print(""); out.println(" "); //输出表头部分 out.print("

设备管理系统

"); out.print("

"); while(rs.next()) { //获取数据库中的ID String name=rs.getString("name"); //输出一列元素 out.print("" + "" + ""); } out.println(""); out.print("返回主页"); out.println(" "); out.println(""); conn.close(); } catch (Exception e) { e.printStackTrace(); } out.flush(); out.close(); } }

设备名称" + "	数量	价格	修改	删除
"+rs.getString("name") +"	"+rs.getString("calssGrent")+"" + "	"+rs.getString("result")+"	修改	删除
添加数据