IDEA连接数据库及简单数据的插入

最新推荐文章于 2024-05-19 01:30:12 发布

橘然*

最新推荐文章于 2024-05-19 01:30:12 发布

阅读量197

点赞数 2

文章标签： intellij-idea 数据库 java

本文链接：https://blog.csdn.net/m0_74241787/article/details/138231782

版权

该篇文章详细描述了如何在JavaWeb应用中，使用JDBC连接到MySQL数据库，包括查询（如获取学生信息）和插入数据（如添加新记录）。

摘要由CSDN通过智能技术生成

连接数据库

<body>
<%
        request.setCharacterEncoding("UTF-8");
        String num=request.getParameter("id");
        String name=request.getParameter("name");
        String sex=request.getParameter("sex");
        Class.forName("com.mysql.jdbc.Driver");
        String url="jdbc:mysql://localhost:3306/ma?useSSL=" +
                "false&characterEncoding=UTF-8&serverTimezone=GMT%2B8";
        Connection con= DriverManager.getConnection(url,"root","123456");
        String username="root";
        String password="123456";
    String sql="select* from tablename1 where id=?";
    PreparedStatement ps= con.prepareStatement(sql);
    ps.setString(1,num);
    ResultSet rs=ps.executeQuery();
    while (rs.next()){
        out.println("学号："+rs.getInt(1)+"<br>");
        out.println("姓名："+rs.getString(2)+"<br>");
        out.println("性别："+rs.getString(3)+"<br>");
    }
    rs.close();
    ps.close();
    con.close();
%>
</body>

<body>
<form action="index2.jsp">
   学号： <input type="text" name="id"><br>
   姓名： <input type="text" name="name"><br>
   性别：<input type="radio" id="male" name="sex" value="男">
    <label for="male">男</label>
    <input type="radio" id="female" name="sex" value="女">
    <label for="female">女</label><br><br>
<input type="submit"></form>
</body>

<body>
<%
        request.setCharacterEncoding("UTF-8");
        String num=request.getParameter("id");
        String name=request.getParameter("name");
        String sex=request.getParameter("sex");
        Class.forName("com.mysql.jdbc.Driver");
        //String url="jdbc:mysql://localhost:3306/ma?useUnicode=true&characterEncoding=utf-8";
        //Connection con= DriverManager.getConnection("jdbc:mysql://localhost:3306/exam1?" + "useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=url","root","120123");
        String url="jdbc:mysql://localhost:3306/ma?useSSL=false&characterEncoding=UTF-8&serverTimezone=GMT%2B8";
        Connection con= DriverManager.getConnection(url,"root","123456");
        String username="root";
        String password="123456";
        String sql="insert into tablename1 value(?,?,?)";
        PreparedStatement ps=con.prepareStatement(sql);
        ps.setString(1,num);
        ps.setString(2,name);
        ps.setString(3,sex);
        int i= ps.executeUpdate();
        if (i>0){
            out.print("插入成功");
        }else{
            out.print("插入失败");
        }
        ps.close();
    con.close();
%>
</body>