jdbc_jsp

小象杰森

于 2021-11-01 15:39:33 发布

阅读量71

点赞数

文章标签： java eclipse

本文链接：https://blog.csdn.net/lileo0000/article/details/121081455

版权

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<%@ page import="java.sql.*" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">

<title>My JSP 'Insert.jsp' starting page</title>

   <meta http-equiv="pragma" content="no-cache">
   <meta http-equiv="cache-control" content="no-cache">
   <meta http-equiv="expires" content="0">
   <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
   <meta http-equiv="description" content="This is my page">

</head>

<body>
<%
   String bh = request.getParameter("bh");
   String xh = request.getParameter("xh");
   String xm = request.getParameter("xm");
   String yw = request.getParameter("yw");
   String sx = request.getParameter("sx");
   String yy = request.getParameter("yy");
   double zf = Double.parseDouble(yw) + Double.parseDouble(sx) + Double.parseDouble(yy);
   try {
       //1.加载驱动程序
   Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
   //2. 获得数据库连接
   String url = "jdbc:sqlserver://localhost:1433/DatabaseName=student";
       String user = "sa";
       String password = "123456";
   Connection conn = DriverManager.getConnection(url, user, password);
   //3.操作数据库，实现增删改查
   String sql = "insert into score(xh,xm,yw,sx,yy,zf,bh)";
   sql = sql + " values('"+xh+"','"+xm+"',"+yw+","+sx+","+yy+","+zf+",'"+bh+"')";
   Statement stmt = conn.createStatement();
   int n = stmt.executeUpdate(sql);
   if (n > 0) {
       out.print("添加成功！");
   }
   else {
       out.print("添加失败！");
   }
   stmt.close();
   conn.close();
   }
   catch (Exception e) {
       out.print(e.toString());
   }
%>
</body>
</html>