JAVA连接sqlserver并执行SQL语句

最新推荐文章于 2024-08-05 21:02:05 发布

来口可乐

最新推荐文章于 2024-08-05 21:02:05 发布

阅读量967

点赞数 2

文章标签： sql sqlserver java

本文链接：https://blog.csdn.net/LSMMMM111/article/details/127480858

版权

首先定义一下成员变量

    public static final String JDBC_DRIVER = "com.mysql.cj.jdbc.Driver";
    public static final String DB_URL = "jdbc:sqlserver://localhost:1433;DatabaseName=lsm";
    public static final String username = "自己的用户名";
    public static final String password = "自己的密码";
    private Connection connection = null;
    private PreparedStatement pStatement = null;
    private ResultSet rSet = null;

加载一下驱动

 static {
        try {
            Class.forName(JDBC_DRIVER);
        } catch (ClassNotFoundException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }

连接数据库

    public void  connectDB() {
        try {
            connection = DriverManager.getConnection(DB_URL,username,password);
            System.out.println("数据库链接成功");
        }
        catch (SQLException e) {
            System.out.println("数据库链接失败");
            e.printStackTrace();
        }
    }

再写一下关闭

 public void close() {
        if(rSet != null) {
            try {
                rSet.close();
            } catch (SQLException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
        }

        if(pStatement != null) {
            try {
                pStatement.close();
            } catch (SQLException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
        }

        if(connection != null) {
            try {
                connection.close();
            } catch (SQLException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
        }
    }

接着开始写一下查询

public User queryUser(String id) throws SQLException {
        try {
            connectDB();
            String queryuser = "select * from login where username = ?";
            pStatement = connection.prepareStatement(queryuser);
            pStatement.setString(1,id);

        
            rSet = pStatement.executeQuery();

            if(rSet.next()) {

                String userString = rSet.getString(1);
                String passwordString = rSet.getString(2);


               
                return new User(userString,passwordString);
            } else {
                
                return null;
            }

        } finally {
            close();
        }

    }