JAVA手写DBUtil工具类和实现模糊查询-----JDBC

旧约Alatus

已于 2023-11-10 15:16:55 修改

阅读量263

点赞数 1

分类专栏： JAVA 文章标签：数据库大数据 java intellij-idea tomcat maven servlet

于 2023-08-08 17:28:43 首次发布

本文链接：https://blog.csdn.net/2201_75960169/article/details/132171870

版权

JAVA 专栏收录该内容

543 篇文章 3 订阅

订阅专栏

package com.powernode.jdbc.utils;

import java.sql.*;
public class Fake
{
    //模糊查询
    public static void main(String[] args)
    {
        Connection connection = null;
        PreparedStatement preparedStatement = null;
        ResultSet resultSet = null;
        try
        {
            //获取连接
            connection = DBUtil.getConnection();
            String sql = "select * from users where username like ?";
            preparedStatement = connection.prepareStatement(sql);
            preparedStatement.setString(1,"_l%");
            resultSet = preparedStatement.executeQuery();
            if(resultSet.next())
            {
                System.out.println(resultSet.getString("email"));
                System.out.println(resultSet.getString("username"));
                System.out.println(resultSet.getString("pssword"));
            }
        }
        catch (Exception e)
        {
            e.printStackTrace();
        }
        finally
        {
            DBUtil.close(connection,preparedStatement,resultSet);
        }
    }
}
package com.powernode.jdbc.utils;

import java.sql.*;
public class Fake
{
//模糊查询
public static void main(String[] args)
{
Connection connection = null;
PreparedStatement preparedStatement = null;
ResultSet resultSet = null;
try
{
//获取连接
connection = DBUtil.getConnection();
String sql = "select * from users where username like ?";
preparedStatement = connection.prepareStatement(sql);
preparedStatement.setString(1,"_l%");
resultSet = preparedStatement.executeQuery();
if(resultSet.next())
{
System.out.println(resultSet.getString("email"));
System.out.println(resultSet.getString("username"));
System.out.println(resultSet.getString("pssword"));
}
}
catch (Exception e)
{
e.printStackTrace();
}
finally
{
DBUtil.close(connection,preparedStatement,resultSet);
}
}
}