java+jsp+sqlserver实现简单的增删改查操作连接数据库代码

1，网站系统开发需要掌握的技术

（1）网页设计语言，html语言css语言等

（2）Java语言

（3）数据库

（4）等

2，源程序代码

package com.jaovo.msg.Util;

import java.sql.*;

public class DBUtil {

    public  static  Connection getConnection() {

        try {

            //1 加载驱动

            Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver").newInstance();

        } catch (InstantiationException | IllegalAccessException | ClassNotFoundException e) {

            // TODO Auto-generated catch block

            e.printStackTrace();

        }

        String user1 = "sa";

        String password = "123456";

        String url = "jdbc:sqlserver://127.0.0.1:1433;DatabaseName=user";

        Connection connection = null;

        try {

            //2 创建链接对象connection

             connection = DriverManager.getConnection(url,user1,password);

        } catch (SQLException e) {

            // TODO Auto-generated catch block

            e.printStackTrace();

        }

        return connection;

    }

    //关闭资源的方法

    public static void close(Connection connection ) {

        try {

            if (connection != null) {

                connection.close();

            }

        } catch (SQLException e) {

            // TODO Auto-generated catch block

            e.printStackTrace();

        }

    }

    public static void close(PreparedStatement preparedStatement ) {

        try {

            if (preparedStatement != null) {

                preparedStatement.close();

            }

        } catch (SQLException e) {

            // TODO Auto-generated catch block

            e.printStackTrace();

        }

    }

    public static void close(ResultSet resultSet ) {

        try {

            if (resultSet != null) {

                resultSet.close();

            }

        } catch (SQLException e) {

            // TODO Auto-generated catch block

            e.printStackTrace();

        }

    }

}

（2）实现增删改查的源代码

package com.jaovo.msg.dao;

import java.sql.*;

import java.util.ArrayList;

import java.util.List;

import com.jaovo.msg.Util.DBUtil;

import com.jaovo.msg.Util.UserException;

import com.jaovo.msg.model.User;

import sun.net.www.content.text.plain;

public class UserDaoImpl implements IUserDao {

    public void add(User user) {

        Connection connection = DBUtil.getConnection();

        try {

            String sql="insert into nlc1(id,username,password,nickname)values('"+user.getId()+"','"+user.getUsername()+"','"+user.getPassword()+"','"+user.getNickname()+"')";

            Statement stmt=connection.createStatement();

            stmt.executeUpdate(sql);

        } catch (SQLException e) {

            e.printStackTrace();

        }finally {

            DBUtil.close(connection);

        }

    }

    @Override

    public void delete(User user) {

        Connection connection = DBUtil.getConnection();

        //System.out.println("执行了");

        try {

            Statement stmt=connection.createStatement();

            String sql = "delete from nlc1 where id = "+user.getId();

            stmt.executeUpdate(sql);

        } catch (SQLException e) {

            e.printStackTrace();

        }finally {

            DBUtil.close(connection);

        }

    }

    @Override

    public void update(User user) {

        Connection connection = DBUtil.getConnection();

        try {

            //String n=user.getId1();

            Statement stmt=connection.createStatement();

            String username=user.getUsername();

            String id=user.getId();

            String password=user.getPassword();

            String nickname=user.getNickname();

            String id1=user.getId1();

            String sql="update nlc1 set id='"+id+"',username='"+username+"',password='"+password+"',nickname='"+nickname+"' where id="+user.getId1();

            stmt.executeUpdate(sql);

        } catch (SQLException e) {

            // TODO Auto-generated catch block

            e.printStackTrace();

        }finally {

            //DBUtil.close(preparedStatement);

            DBUtil.close(connection);

        }

    }

    public void check(User user) {

        Connection connection = DBUtil.getConnection();

        Statement stmt;

        try {

            stmt = connection.createStatement();

            ResultSet rs=stmt.executeQuery("SELECT * FROM nlc1 where id="+user.getId());

            //while(rs.next())

            //System.out.println(rs.getString("id")+"\t"+rs.getString("username")+"\t"+rs.getString("password")+"\t"+rs.getString("nickname"));

        } catch (SQLException e) {

            // TODO Auto-generated catch block

            e.printStackTrace();

        }

    }

    public List<User> load() {

        Connection connection = DBUtil.getConnection();

        //准备sql语句

        String sql = "select * from nlc1 ";

        //创建语句传输对象

        PreparedStatement preparedStatement = null;

        ResultSet resultSet = null;

        //集合中只能放入user对象

        List<User> users = new ArrayList<User>();

        User user = null;

        try {

            preparedStatement = connection.prepareStatement(sql);

            resultSet = preparedStatement.executeQuery();

            while(resultSet.next()) {

                user = new User();

                user.setId(resultSet.getString("id"));

                user.setUsername(resultSet.getString("username"));

                user.setPassword(resultSet.getString("password"));

                user.setNickname(resultSet.getString("nickname"));

                users.add(user);

            }

        } catch (SQLException e) {

            // TODO Auto-generated catch block

            e.printStackTrace();

        }finally {

            DBUtil.close(resultSet);

            DBUtil.close(preparedStatement);

            DBUtil.close(connection);

        }

        return  users;

    }

    @Override

    public User load(int id) {

        // TODO Auto-generated method stub

        return null;

    }

    @Override

    public User load(String username) {

        // TODO Auto-generated method stub

        Connection connection = DBUtil.getConnection();

        //准备sql语句

        String sql = "select * from nlc1  where username = ?";

        //创建语句传输对象

        PreparedStatement preparedStatement = null;

        ResultSet resultSet = null;

        User user = null;

        try {

            preparedStatement = connection.prepareStatement(sql);

            preparedStatement.setString(1, username);

            resultSet = preparedStatement.executeQuery();

            while(resultSet.next()) {

                user = new User();

                user.setId(username);

                user.setUsername(resultSet.getString("username"));

                user.setPassword(resultSet.getString("password"));

                user.setNickname(resultSet.getString("nickname"));

            }

        } catch (SQLException e) {

            // TODO Auto-generated catch block

            e.printStackTrace();

        }finally {

            DBUtil.close(resultSet);

            DBUtil.close(preparedStatement);

            DBUtil.close(connection);

        }

        return  user;

    }

}

（3）登录界面代码login.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"

    pageEncoding="UTF-8"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">

<title>登录界面</title>

</head>

<body background="D:\图片\动漫\20150422H2607_fKHLB.jpeg">

<%if(request.getAttribute("error1")!=null){ %>

<h4 >用户名或密码不能为空</h4>

<%} %>

<%if(request.getAttribute("error2")!=null){ %>

<h4>账号或密码错误</h4>

<%} %>

<form action="enter.jsp" method="get">

<table align="center" border="4" width="400">

            <h4 align="center">登录界面</h4>

            <tr>

                <td>用户名称 : </td>

                <td>

                    <input type="text" name="username" />

                </td>

            </tr>

                <tr>

                <td>用户密码:</td>

                <td>

                    <input type="password" name="password" />

                </td>

            </tr>

            <script>

            function a(){window.open("addInput.jsp",'_blank')}

            </script>

            <script>

            function b(){window.open("deleteInput.jsp",'_blank')}

            </script>

            <tr align="center">

                <td colspan="2">

                    <input type="submit" value="登录" />

                    <input type="button" value="注册"onclick="a()"/>

<!--                     <input type="button" value="修改密码"onclick="b()"/> -->

                    <input type="reset" value="重置" />

                </td>

            </tr>

        </table>

        </form>

</body>

</html>

<%@page import="com.jaovo.msg.Util.UserException"%>

<%@page import="com.jaovo.msg.dao.UserDaoImpl"%>

<%@page import="com.jaovo.msg.model.User"%>

<%@ page language="java" contentType="text/html; charset=UTF-8"

    pageEncoding="UTF-8"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">

<title>Insert title here</title>

</head>

<body>

    <%

    String username = request.getParameter("username");

    String password = request.getParameter("password");

    User user = new User();

    UserDaoImpl userDao = new UserDaoImpl();

    user.setUsername(username);

    user.setPassword(password);

    if(username.equals(user.getUsername())&&password.equals(user.getPassword())){

    %>

      <h4 align="center">登录成功</h4>

    <div ><div style="text-align:center;">

      <a href="login.jsp">返回登录界面</a>

      <a href="list.jsp">查看所有用户</a>

    </div>

      <%

      }

      %>

    <%

    if(username == null || "".equals(username.trim())){

        request.setAttribute("error1", "用户名不能为空");

%>

    <jsp:forward page="login.jsp"></jsp:forward>

<%

}

%>

    <%

    user=userDao.load(username);

    if(user==null){

        request.setAttribute("error2", "用户名不存在或密码错误");

        %>

        <jsp:forward page="login.jsp"></jsp:forward>

    <%

    }

    %>

</body>

</html>

（4）增删改查界面源代码

<%@ page language="java" contentType="text/html; charset=UTF-8"

    pageEncoding="UTF-8"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

    <title>用户注销页面</title>

</head>

<body background="D:\图片\动漫\20150422H2607_fKHLB.jpeg">

    <%=request.getAttribute("error") %>

    <form action="delete.jsp" method="get">

    <h4 align="center">删除界面</h4>

        <table align="center" border="4" width="400">

            <tr>

                <td>请输入要删除的用户id:</td>

                <td>

                    <input type="text" name="id" />

                </td>

            </tr>

            <tr align="center">

                <td colspan="2">

                    <input type="submit" value="删除" />

                    <input type="reset" value="重置" />

                </td>

            </tr>

        </table>

    </form>

</body>

</html>

<%@page import="com.jaovo.msg.Util.UserException"%>

<%@page import="com.jaovo.msg.dao.UserDaoImpl"%>

<%@page import="com.jaovo.msg.model.User"%>

<%@ page language="java" contentType="text/html; charset=UTF-8"

    pageEncoding="UTF-8"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

    <title>删除页面</title>

</head>

<body background="D:\图片\动漫\20150422H2607_fKHLB.jpeg" >

<%

    String id=request.getParameter("id");

    if(id == null || "".equals(id.trim())){

        request.setAttribute("error", "用户名不能为空");

%>

     <jsp:forward page="deleteInput.jsp"></jsp:forward>

<%

}

    User user = new User();

    user.setId(id);

    UserDaoImpl userDao = new UserDaoImpl();

    try{

        userDao.delete(user);

%>

    <h4 align="center">注销成功</h4>

    <div style="text-align:center;">

    <a  href="addInput.jsp">注册用户</a>

    <a href="deleteInput.jsp">删除用户</a>

    <a href="updataInput.jsp">修改用户</a>

<!--     <a href="checkInput.jsp">查询用户</a> -->

    <a href="list.jsp">查看列表信息</a>

    <a href=>

    </div>

<%

    }catch(UserException e){

%>

    <h2 style="color:red ; font-size:50px">发生错误 : <%=e.getMessage() %></h2>

    <%

    }

    %>

    </body>

</html>

<%@ page language="java" contentType="text/html; charset=UTF-8"

    pageEncoding="UTF-8"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

    <title>登录注册</title>

</head>

<body background="D:\图片\动漫\57Z58PICJBv_1024.jpg" >

<%=request.getAttribute("error") %>

    <form action="add.jsp" method="get">

        <table align="center" border="4" width="400">

            <h4 align="center">注册界面</h4>

            <tr>

                <td>用户id : </td>

                <td>

                    <input type="text" name="id" />

                </td>

            </tr>

            <tr>

                <td>用户名称 : </td>

                <td>

                    <input type="text" name="username" />

                </td>

            </tr>

                <tr>

                <td>用户密码:</td>

                <td>

                    <input type="password" name="password" />

                </td>

            </tr>

            <tr>

                <td>用户昵称:</td>

                <td>

                    <input type="text" name="nickname" />

                </td>

            </tr>

            <tr align="center">

                <td colspan="2">

                    <input type="submit" value="注册" />

                    <input type="reset" value="重置" />

                </td>

            </tr>

        </table>

    </form>

</body>

</html>

<%@page import="com.jaovo.msg.Util.UserException"%>

<%@page import="com.jaovo.msg.dao.UserDaoImpl"%>

<%@page import="com.jaovo.msg.model.User"%>

<%@ page language="java" contentType="text/html; charset=UTF-8"

    pageEncoding="UTF-8"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

    <title>注册</title>

</head>

<body background="D:\图片\动漫\57Z58PICJBv_1024.jpg" >

<%

    //接收客户端传递过来的参数

    String id = request.getParameter("id");

    String username = request.getParameter("username");

    String password = request.getParameter("password");

    String nickname = request.getParameter("nickname");

    if(username == null || "".equals(username.trim())){

        request.setAttribute("error", "用户名不能为空");

%>

    <jsp:forward page="addInput.jsp"></jsp:forward>

<%

}   User user = new User();

    user.setId(id);

    user.setUsername(username);

    user.setPassword(password);

    user.setNickname(nickname);

    UserDaoImpl userDao = new UserDaoImpl();

    try{

    userDao.add(user);

%>

    <h2 align="center">注册成功</h2>

    <div style="text-align:center;">

    <a  href="addInput.jsp">注册用户</a>

    <a href="deleteInput.jsp">删除用户</a>

    <a href="updataInput.jsp">修改用户</a>

<!--     <a href="checkInput.jsp">查询用户</a> -->

    <a href="list.jsp">查看列表信息</a>

    </div>

<%

    }catch(UserException e){

%>

    <h2 style="color:red ; font-size:50px">发生错误 : <%=e.getMessage() %></h2>

    <%

    }

    %>

    </body>

</html>

<%@ page language="java" contentType="text/html; charset=UTF-8"

    pageEncoding="UTF-8"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

    <title>用户修改页面</title>

</head>

<body background="D:\图片\动漫\20150422H2607_fKHLB.jpeg">

    <%=request.getAttribute("error") %>

    <form action="updata.jsp" method="get">

    <h4 align="center">修改界面</h4>

        <table align="center" border="4" width="400">

            <tr>

                <td>要修改的用户id : </td>

                <td>

                    <input type="text" name="id1" />

                </td>

            </tr>

            <tr>

                <td>修改后的用户id : </td>

                <td>

                    <input type="text" name="id" />

                </td>

            </tr>

            <tr>

                <td>修改后的用户name : </td>

                <td>

                    <input type="text" name="username" />

                </td>

            </tr>

            <tr>

                <td>修改后的用户password : </td>

                <td>

                    <input type="password" name="password" />

                </td>

            </tr>

            <tr>

                <td>修改后的用户nickname : </td>

                <td>

                    <input type="text" name="nickname" />

                </td>

            </tr>

            <tr align="center">

                <td colspan="2">

                    <input type="submit" value="修改" />

                    <input type="reset" value="重置" />

                </td>

            </tr>

        </table>

    </form>

</body>

</html>

<%@page import="com.jaovo.msg.Util.UserException"%>

<%@page import="com.jaovo.msg.dao.UserDaoImpl"%>

<%@page import="com.jaovo.msg.model.User"%>

<%@ page language="java" contentType="text/html; charset=UTF-8"

    pageEncoding="UTF-8"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

    <title>修改页面</title>

</head>

<body background="D:\图片\动漫\20150422H2607_fKHLB.jpeg">

<%

    //接收客户端传递过来的参数

    String id1 = request.getParameter("id1");

    String id = request.getParameter("id");

    String username = request.getParameter("username");

    String password = request.getParameter("password");

    String nickname = request.getParameter("nickname");

if(id == null || "".equals(id.trim())){

    request.setAttribute("error", "id不能为空");

%>

<%--     <jsp:forward page="updataInput.jsp"></jsp:forward> --%>

<%

}

   User user = new User();

    user.setId1(id1);

    user.setId(id);

    user.setUsername(username);

    user.setPassword(password);

    user.setNickname(nickname);

    UserDaoImpl userDao = new UserDaoImpl();

    try{

    userDao.update(user);

%>

<%

%>

    <h4 align="center">用户修改成功</h4>

    <div style="text-align:center;">

    <a  href="addInput.jsp">注册用户</a>

    <a href="deleteInput.jsp">删除用户</a>

    <a href="updataInput.jsp">修改用户</a>

<!--     <a href="checkInput.jsp">查询用户</a> -->

    <a href="list.jsp">查看列表信息</a>

    </div>

<%

    //userDao.add(user);

    }catch(UserException e){

%>

    <h2 style="color:red ; font-size:50px">发生错误 : <%=e.getMessage() %></h2>

    <%

    }

    %>

    </body>

</html>

<%@page import="com.jaovo.msg.Util.UserException"%>

<%@page import="com.jaovo.msg.dao.UserDaoImpl"%>

<%@page import="com.jaovo.msg.model.User"%>

<%@page import="java.util.List" %>

<%@ page language="java" contentType="text/html; charset=UTF-8"

    pageEncoding="UTF-8"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">

<title>列表</title>

</head>

<body>

<%

    UserDaoImpl userDao = new UserDaoImpl();

    List<User> users = userDao.load();

%>

<body>

    <table align="center" border="1" width="500">

        <tr>

            <td>用户编号</td>

            <td>用户名称</td>

            <td>用户密码</td>

            <td>用户昵称</td>

        </tr>

        <%

            for( User user : users ){

        %>

        <tr>

            <td> <%=user.getId() %></td>

            <td> <%=user.getUsername() %></td>

            <td> <%=user.getPassword() %></td>

            <td> <%=user.getNickname() %></td>

            <td> <a href="deleteInput.jsp ">删除</a></td>

        </tr>

        <%

            }

        %>

    </table>

</body>

</body>

</html>

3，运行结果截图

4，这门课的希望和自己的目标，列出计划每周花费在这门课上的时间

希望：希望学习完这门课之后能够熟练写出一个网站系统，尤其是在网站设计上

目标：熟练写出一个网站系统

计划：在完成其它课程作业的其余时间都扑身于这门课上

java+jsp+sqlserver实现简单的增删改查操作连接数据库代码

java+jsp+sqlserver实现简单的增删改查操作连接数据库代码的相关教程结束。

相关推荐

quarkus数据库篇之二：无需数据库也能运行增删改查(dev模式)

「学习笔记」gdb 调试的简单操作

.Net Core 3.0 对 MongoDB 的多条件查询（两种）操作

2022-12-20：二狗买了一些小兵玩具，和大胖一起玩，一共有n个小兵，这n个小兵拍成一列，第i个小兵战斗力为hi，然后他们两个开始对小兵进行排列，一共进行m次操作，二狗每次操作选择一个数k，

idea连接数据库时区：Server returns invalid timezone. Go to 'Advanced' tab and set 'serverTimezone' prope

2020-01-20：mysql中，一张表里有3亿数据，未分表，要求是在这个大表里添加一列数据。数据库不能停，并且还有增删改操作。请问如何操作？

Django笔记三十三之缓存操作

ASP.NET Core Web API Cassandra CRUD 操作

java+jsp+sqlserver实现简单的增删改查操作 连接数据库代码

java+jsp+sqlserver实现简单的增删改查操作 连接数据库代码的相关教程结束。

相关推荐

quarkus数据库篇之二：无需数据库也能运行增删改查(dev模式)

「学习笔记」gdb 调试的简单操作

.Net Core 3.0 对 MongoDB 的多条件查询（两种）操作

2022-12-20：二狗买了一些小兵玩具，和大胖一起玩， 一共有n个小兵，这n个小兵拍成一列， 第i个小兵战斗力为hi，然后他们两个开始对小兵进行排列， 一共进行m次操作，二狗每次操作选择一个数k，

idea连接数据库时区：Server returns invalid timezone. Go to 'Advanced' tab and set 'serverTimezone' prope

2020-01-20：mysql中，一张表里有3亿数据，未分表，要求是在这个大表里添加一列数据。数据库不能停，并且还有增删改操作。请问如何操作？

Django笔记三十三之缓存操作

ASP.NET Core Web API Cassandra CRUD 操作

java+jsp+sqlserver实现简单的增删改查操作连接数据库代码

java+jsp+sqlserver实现简单的增删改查操作连接数据库代码的相关教程结束。

2022-12-20：二狗买了一些小兵玩具，和大胖一起玩，一共有n个小兵，这n个小兵拍成一列，第i个小兵战斗力为hi，然后他们两个开始对小兵进行排列，一共进行m次操作，二狗每次操作选择一个数k，