jsp数据库在jsp页面增删改查

最新推荐文章于 2023-02-20 20:54:54 发布

weixin_43268298

最新推荐文章于 2023-02-20 20:54:54 发布

阅读量523

点赞数

文章标签： mysql

本文链接：https://blog.csdn.net/weixin_43268298/article/details/106260237

版权

  <body>
<a href="ch6/add.jsp">新增记录</a><br>

<a href="ch6/upd.jsp">更改记录</a><br>
<a href="ch6/sel.jsp">查找记录</a><br>
<a href="ch6/del.jsp">删除记录</a><br>

<form action="ch6/par.jsp" method="post">
学号<input type="text" name="xh">
姓名：<input type="text" name="xm">
 <input type="submit" value="提交">
</form>
</body>

add。jsp

```java
 <%
     String driverClass="com.mysql.cj.jdbc.Driver"; 
     String serverIp="localhost";
     String databaseName="my";
     String username="root";
     String password="zp1536338";
     String url="jdbc:mysql://localhost:3306/my?useSSL=false&serverTimezone=UTC";
     Class.forName(driverClass);
     Connection conn = DriverManager.getConnection(url, username, password);
     if(conn != null){
  //  System.out.println("连接成功");
   String sql ="insert into student(stuno,stuname) values('2017117191','刘备')";
   Statement stmt= conn.createStatement();
   int result = stmt.executeUpdate(sql);
   if(result >0){
   System.out.print("插入数据成功");
 }else{
    System.out.print("插入数据失败");
 }
    
     }else{
      System.out.println("连接失败");
     }
      conn.close();
   %>
   <p>ok</p>
     <% 
       String strHtml="";
     String driverClass="com.mysql.cj.jdbc.Driver"; 
     String serverIp="localhost";
     String databaseName="my";
     String username="root";
     String password="zp1536338";
     String url="jdbc:mysql://localhost:3306/my?useSSL=false&serverTimezone=UTC";
     Class.forName(driverClass);
     Connection conn = DriverManager.getConnection(url, username, password);
     if(conn != null){
  //  System.out.println("连接成功");
   String sql =" select  * from student";
   Statement stmt= conn.createStatement();
     ResultSet result=   stmt.executeQuery(sql);
     
     while(result.next()){
       strHtml += result.getInt("id") +" | "+ result.getString(2) +" | " + result.getString(3);
       strHtml +="<br>";
     }
     
     }else{
      System.out.println("连接失败");
     }
      conn.close();
   %>
   <%= strHtml %>
  </body>